How to resolve the error: 'Inventory Revaluation is no longer the first transaction in the item's history'.

This is a common error message that occurred to many users and want to share the quick solution. After you enter a transaction for a Standard Cost Item, you might have encountered the error message.

You encountered this message unless the following steps are taken.

1. A Standard Cost Version has been created under Lists > Accounting > Standard Cost Versions
2. A Planned Standard Cost has been assigned to the item under Lists > Accounting > Planned Standard Costs
3. This is not always necessary. If you decide to activate an existing Cost Version, you may manually revalue a single item through Transactions > Inventory > Revalue Inventory Cost
4. Update the standard cost of items with the effective date by running the Inventory Cost Revaluation under Lists> Accounting> Revalue Standard Cost Inventory

You may want to create a saved search to identify which Items and in which Location need to have an Inventory Costing Revaluation. I will walk you through to create a saved search to view Items with no Inventory Cost Revaluation per Location.

1. Create an Item Search (Lists > Search > Saved Searches > New > Item)
2. Under Criteria:
3. Costing Method is Standard
4. Current Standard Cost is Empty
5. Under Results:
6. Item
7. Inventory Location
8. Note: add additional columns as needed.
9. The result lists down Items and the Inventory Location where the Current Standard Cost is Null or Empty.

I hope this helps you to resolve the error: 'Inventory Revaluation is no longer the first transaction in the item's history'. Do you want to learn more about Item Costing, and Revaluing Standard Cost Inventory in NetSuite, or get guided support or training? Contact Concentrus today to discuss your needs.

About Us

Concentrus is a complete NetSuite solutions provider that guides organizations through how to use NetSuite to reach highly focused business goals and objectives. We provide NetSuite implementation, developer, integration, and customization services to ensure that you have a long-term solution that is tailored to fit your systems, people, and processes.

Read About Our Implementation Methodology

Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos