This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

This is a long shot but has anyone seen this too?

This is the *AggregateItemLocation* table and the pictured column is supposed to (I think) update the date/timestamp when a transaction changes the qty available. I created an *Inventory Status Change* which moved the item to FAULTY. This has reduced the qty available in the same table, but the timestamp has not updated.

I can see other transaction types (Sales Order, Transfer Order, Item Receipt etc) do cause the date/timestamp to change.

I recall encountering situations where NetSuite considers available to be just
```qtyOnHand - qtyCommitted```
regardless of status - I wonder if that's happening here

I'd say it's a defect, NetSuite say it's a feature request :smile: