ANS-0678 · INVENTORY & ITEM MANAGEMENT
How to Monitor Inventory Adjustment Costing Method Recalculations in NetSuite
NetSuite offers two primary methods, scheduled scripts with saved searches or user event scripts, to track changes in inventory adjustment costing.
Short answer
Monitoring Inventory Adjustment costing method recalculations in NetSuite can be achieved through two main approaches. Utilize a scheduled script with a saved search to identify relevant system notes, or leverage a BeforeLoad user event script on the Inventory Adjustment record to trigger custom processing when updates occur. These methods provide flexibility for tracking and responding to costing changes.
Scenario
Organizations often need to track when the costing method for an Inventory Adjustment record is recalculated in NetSuite. This monitoring is crucial for maintaining accurate financial records, ensuring compliance, and triggering subsequent business processes. Identifying these specific recalculation events can be challenging without a structured approach.
Solution
There are two primary methods for monitoring Inventory Adjustment costing method recalculations:
Implement a scheduled script that executes a saved search. This search should target Inventory Adjustment records and filter their System Notes. The filters should include
System Notes Type is Changeand potentially other relevant system note types or filters that indicate an impact on costing. Within the search results, theOld Value / New Valuefield may contain details or a reference, such as a URL-like string, indicating the specific transaction or change, for example, a format similar tohttps://system.netsuite.com/app/accounting/transactions/invadjst.nl?id’5715&whence#.Utilize a BeforeLoad User Event script. When NetSuite updates an Inventory Adjustment, a
BeforeLoaduser event is triggered. Although the event type isview, this script can be configured to monitor the transaction for specific changes. Within this script, you can schedule a subsequent event or call a Suitelet to perform additional processing based on the detected update.
Expert NetSuite Support
Need help with this NetSuite issue?
Inventory & Item Management consulting and configuration support
