Introduction
NetSuite does not include a built-in feature to track the date when vendor prices were last updated. If you need to monitor vendor price changes for purchasing, inventory control, or audit purposes, you can use a SuiteApp bundle or maintain a manual comparison process.
Using the Effective Date Pricing SuiteApp bundle
A SuiteApp bundle called Effective Date Pricing can be used to track vendor price update dates in the system. If this bundle is available in your NetSuite account, it may provide a more structured way to manage pricing history and effective dates.
What to do
- Check whether the Effective Date Pricing bundle is installed in your NetSuite account.
- If it is not installed, confirm whether your NetSuite administrator can add it or whether it is available through your account configuration.
- Review the bundle documentation to understand how it records pricing changes and effective dates.
- Use the bundle to view or report on vendor price changes by date, if supported in your setup.
Manual tracking method
If you do not have the Effective Date Pricing bundle, you can track vendor price updates manually by saving a copy of the item master each time it is downloaded and comparing it with the previous version.
Recommended manual process
- Keep the last downloaded copy of the item master in a secure location.
- When a new item master is downloaded, save it with the download date in the file name.
- Compare the old and new files to identify vendor price changes.
- Record the old price, new price, and the date of the download for each change.
- Use a spreadsheet or internal log to maintain a clear price history.
Best practices
- Use a consistent file naming convention for each downloaded item master.
- Store historical files in a controlled folder with restricted access.
- Document the source of each price update so changes can be audited later.
- Review vendor pricing on a regular schedule to reduce missed updates.
Additional information
If you need a more automated approach, consider working with your NetSuite administrator or implementation partner to evaluate pricing history tools, SuiteApps, or custom reporting options that fit your workflow.
If you have not yet confirmed whether Effective Date Pricing is available in your environment, contact your NetSuite support team or system administrator for assistance.