Requirement: Over a seven-day period, we have issued email alerts to customers to recognize the sales order is ready for distribution. We are not checking the partial item fulfillment situation of the sales order in the present functionality. When several item fulfilment records are created from the same sales order, the consumer becomes confused as… Continue reading Email sending functionality when an item fulfilment is created over a 7-days period
Author: Lakshmi priya Suresh
Repeat a string n times in freemarker
Requirement: Need to repeat a string of characters n times, where n is a variable Solution: Use list to iterate a range:
Remove the CORRESPONDING PO and ETA Column Values from Sales Orders (update)-Proposal
Requirement Identify the sales orders when it’s ordered and committed quantities become equal and remove the corresponding PO and ETA column values from the sales orders item line. Our Solution We will develop a Map/Reduce script that executes twice in a day. So, the script will fetch all sales orders having at least one purchase… Continue reading Remove the CORRESPONDING PO and ETA Column Values from Sales Orders (update)-Proposal
Creating Contact Records For Customer Merge Functionality
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
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: