Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Search to show running total of stock
I have created a saved search to list all 'stock affecting' transactions for a product, and then use an Advanced PDF template to generate a 'running total' of stock over time.
Can anyone confirm (definitively) what transactions are stock affecting?
My current search is using:
Type is any of:
Cash Refund
Cash Sale
Inventory Adjustment
Inventory Distribution
Inventory Transfer
Inventory Worksheet
Invoice
Item Fulfillment
Item Receipt
Account is:
1001 Current Asses : Stock
I thought this was working correctly, but I've just come across an item where the report is 2 out - so presumably it is not including some necessary transaction type(s).
3