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:

  1. 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 Change and potentially other relevant system note types or filters that indicate an impact on costing. Within the search results, the Old Value / New Value field may contain details or a reference, such as a URL-like string, indicating the specific transaction or change, for example, a format similar to https://system.netsuite.com/app/accounting/transactions/invadjst.nl?id’5715&whence#.

  2. Utilize a BeforeLoad User Event script. When NetSuite updates an Inventory Adjustment, a BeforeLoad user event is triggered. Although the event type is view, 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

Talk to a consultant