Scenario 1: Printing the Terms on the packing slip PDF wasn’t possible since the purchase order terms is not accessible from the advanced PDF/HTML markup. Solution: In the Advance PDF template, not possible to get the terms value directly from Purchase order. We need to create two custom fields ( custbody_jj_po, custbody_jj_terms ) in packing slip for… Continue reading PDF Template for Packing slip from Supplier Return Authorization.
Author: Vairamuthu
Recurring POs Using Workflow Action script.
To include the Parent PO record on the copied Record when the user creates a PO using Make a Copy and reduce the recurrence count by one whenever a user creates a Copy PO record by Make a Copy. please reduce this integer by 1 every time a user makes a copy of the PO… Continue reading Recurring POs Using Workflow Action script.
“Invalid Canadian Tax Code: xxx-xxxx” on Sales Order with Canadian Shipping Address.
Issue: While creating sales order with Canadian tax code and body level discount item, The error message is showing like this Solution: When transaction used a tax code as the tax item per lookup, system will throw “Invalid Canadian Tax Code: xxx-xx” notice since for Canada Tax, system required Tax Groups to be used instead… Continue reading “Invalid Canadian Tax Code: xxx-xxxx” on Sales Order with Canadian Shipping Address.
Making Fields Mandatory In Return Authorization Record (UI Context)
Requirements: Make the item sublist fields: FAILURE REASON, PRIMARY ISSUE, SECONDARY ISSUE & ACTION is mandatory in the Return Authorization record if the item types are any of Inventory, Assembly, or Kit. Our Solution This can be achieved by using Suite scripts. As per the requirement, the item line fields: FAILURE REASON, PRIMARY ISSUE, SECONDARY… Continue reading Making Fields Mandatory In Return Authorization Record (UI Context)
Script for updating Sales Effective date
to customize the customer portal by automating the field named Sales Effective/ Shipping Date in the Sales Order. When the Sales Rep must approve the SO, the Sales Effective/Shipping Date shall be applied. Depending on the Customer Price Level (e.g. OEM, Distributor, Dealer, Builder) there would be specific number of working days added to the… Continue reading Script for updating Sales Effective date
Difference of Item Level and Body Level Discount Apply In Sales Order
Scenario: You might regard Item Level Discounts to be the same as Order Level Discounts in NetSuite, however, they are different and follows a different workflow. Here is an explanation on the difference between the two. Solution: Item Level Discounts: Item level Discounts applies the Discount on the price of the individual line item. This… Continue reading Difference of Item Level and Body Level Discount Apply In Sales Order
Monthly Sales order Email Notification for Sales Rep
Send a email notification to all Sales Rep once a month. We need to send the customer sales information of the previous month to the corresponding Sales Rep. This email notification should contain the Customer Name and Customer Email, Sales Order document Number, Sales Amount which is attached as a CSV File to the email.… Continue reading Monthly Sales order Email Notification for Sales Rep