Requirement We need to change the standard status field, which is not displayed on the task form based on the custom status field. Solution We can create a user event script to update the standard field for this purpose.
Author: Jesna John
Dynamic connection to Excel
Requirement We need to create a Suitelet page to load the saved search and the search results should be loaded to the Excel sheet by connecting Excel to the Netsuite using the Suitelet URL. Suitelet should be respond with CSV file format. Solution We will be creating a suitelet script to load the saved search… Continue reading Dynamic connection to Excel
Adding Planogram Button in customer Record
Requirement We need to create a Planogram button in customer record. If the customer record doesn’t have a planogram custom record entry yet, we need to set show a button .If not hide the button. On button click, we need to show a planogram and create a page in a new tab with the customer… Continue reading Adding Planogram Button in customer Record
Proposal For Custom Cash Projection report
Proposal summary This proposal is to create a cash flow report showing the invoice, bills, journals, bill payments, deposits and checks on weekly basis. Requirement Yash Industries Pvt Ltd needs to have a the cash flow projection report showing the invoice, bills, journals, bill payments, deposits and checks. They need to see the report of… Continue reading Proposal For Custom Cash Projection report
PROPOSAL FOR SPLIT CUSTOMER DEPOSIT
PROPOSAL SUMMARY This proposal is to prevent the deposit amount from fully applying to the invoice and apply only a predefined amount. REQUIREMENT Need to apply on particular deposit amount to be applied for invoices. Scenario: The user will create a deposit attached to a sales order. The full deposit amount need not be… Continue reading PROPOSAL FOR SPLIT CUSTOMER DEPOSIT
Update Item status to inactive
Requirement We need yo update an to inactive item records if the following conditions are satisfied: Item is discontinued item Total inventory is zero (Quantity on hand in item record is zero) If there is no purchase orders exist for the item in the following status Purchase order: Pending Supervisor approval Purchase order: Partially received … Continue reading Update Item status to inactive
Email sending on save action of task record
Requirement When a task record is opened, in the escalation tab, when we enter data in the escalation record and save the task record then send an email to the employee in the escalation record. When task record is saved, the escalation record needs to become empty. Solution A userevent script is created to send… Continue reading Email sending on save action of task record
Display External Id in Sales Channel
Requirement We need to display the external Id to the custom field in Sales Channel record. Solution We need to create a custom field to store the external Id sourced from the standard External Id field. Then the value is set to this custom field using a userevent script.
Masking Amounts in PA and Invoices
Requirement The amount shown in transactional lines in all Invoice/PA(sales order) needs to be masked so no one can change it. If a user attempts to change the amount of an invoice or payment agreement record when it is created or edited, the amount value must not be changed through the user interface. Solution
Display External IDs in Department record
Requirement We need to display the external Id to the custom field in Department record. Usually External Ids are not displayed in any transactions/ records. Solution