Requirement In our NetSuitecustomer record, we also use 3 main contact fields under “Email / Phone / Address” section on the main body:Main ContactMain Contact EmailMain Contact PhoneIf there’s conflicting information for these 3 fields, can you create a new contact record using these 3 fields of the duplicate record and then link this new… Continue reading Creating Contact Records For Customer Merge Functionality
Author: Lakshmi priya Suresh
Automatically Show the amount on Passthrough/Expence Field
Requirement: Display the sum of amounts (passthrough account number ranges from 1251 to 1271) entered in the expense lines of a Bill in the custom field passthrough/expense on saving the Bills record. Solution:
Automatically Show the amount on Passthrough/Expence Field-Proposal
Client Requirement: What I mean is: 1.- I will create a bill (total amount of the bill 1,720 usd)2.- I entered the expense accounts as follows:6300 – 20 usd1261 – 5001261 – 1,200 What I want is that before click save, on the new field created “passthrough / expense”, NS automatically shows me the total… Continue reading Automatically Show the amount on Passthrough/Expence Field-Proposal
Remove the CORRESPONDING PO and ETA Column Values from Sales Orders.
REQUIREMENT Determine which sales orders are included in the corresponding PO and make sure thecommitted quantity equals the order quantity. If the condition is met, remove thecorresponding PO value and the estimated time of arrival (ETA) from the corresponding salesorder column. SOLUTION
Notify the purchase order’s quantity update by email
Requirement: Send an email to acknowledge the quantity update on the purchase order’s items. When a user or system modifies the number of products in a purchase order. Check that the PO is listed in the “corresponding PO” column of the sales order. If the purchase order is included in the “corresponding PO” column of… Continue reading Notify the purchase order’s quantity update by email
Notify the purchase order’s quantity update by email
REQUIREMENT: Send an email to acknowledge the quantity update on the purchase order’s items. When a user or system modifies the number of products in a purchase order. Check that the PO is listed in the “corresponding PO” column of the sales order. If the purchase order is included in the “corresponding PO” column of… Continue reading Notify the purchase order’s quantity update by email
Automate spiff report email
Requirement: The automation is used to send the spiff reports via email. This automation script will run at the end of each month and send the spiff data to the appropriate spiff person in CSV format. Solution:
Remove Button Action
To remove a button from a record, use the Remove Button action in a workflow instance Use this action to remove both standard NetSuite buttons and custom buttons, based on conditions such as the user that views the record or the state of the record The following screenshot shows the workflow action page for the Remove… Continue reading Remove Button Action
Scheduling a Workflow Transition
You can use the Scheduled trigger with a transition to create a scheduled transition. You can schedule a transition to execute after a certain number of hours or days have passed after the record enters the state for the transition. To schedule a transition: create a transition, make sure to set the Trigger On property to Scheduled. (Created… Continue reading Scheduling a Workflow Transition
Warning : This invoice already has a payment applied to it, net of applicable withholding tax. Editing is not allowed for this transaction. For more information contact your NetSuite Administrator.”
Scenario: In a payment record, I needed to calculate the sum of subtotals for each invoice.As part of this, when I tried to load an invoice through script that had no edit option and was subject to withholding tax, I received an error message that said “Warning : This invoice already has a payment applied… Continue reading Warning : This invoice already has a payment applied to it, net of applicable withholding tax. Editing is not allowed for this transaction. For more information contact your NetSuite Administrator.”