Requirement – Customer Vendor Price Automation
The requirement is to Populate the Item rate in the custom record to the standard rate field in the purchase order if the PO vendor, Subsidiary, and market match the custom record data.
Custom Records created as part of this requirement:
-Vendor – Vendor list
-Subsidiary – subsidiary list
-Market – geography
-Purchase Price – Decimal Number field
If the PO vendor, subsidiary, and market match the data from the custom record, it is necessary to populate the item rate in the custom record to the standard rate field in the purchase order.
Confirm the below points is considered in NetSuite scripts optimization.
-Use SuiteScript 2.0
-Minimize database calls
-Optimize loops and conditional statements
-Use caching
-Monitor system performance
After script optimization, make sure the vendor pricing customization function works correctly.