Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to Search Qty on hand as on any specific Date by using Formula Field
I created a Transaction search for Item Receipt and Item Sales.
Criteria:Type is Invoice And Main Line is false And Tax Line is false And Account is Sales Account
Or
(Type is Item Receipt And Account is Sales Account (Gross) And Main Line is false)
Result:Date, Number, Type, Name, Item, Quantity, Amount
Now I want to add/include a Formula field to find out the Item Stock (On hand) quantity as on 31st December or any specific Date qty.
Which formula I use here to get the On Hand qty as on specific date. Any help will be appreciate.