Working on a modified version of the Inventory Valuation report to act as an inventory transaction log. Trying to get a beginning balance field set up. The goal would be for the report to calculate the total on-hand quantity for the item from BEFORE the date specified in the @TransactionDateFROM parameter. Any ideas?
+11Hi ā
Please refer to the "Historical Inventory Balance" report to see how to create the Beginning Balance Qty.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! š https://www.linkedin.com/in/truongpham80
1 person likes this
Hello, ā
The issue with that report is that it is grouping by period. As such, it is able to utilize ItemHistCurr, which apparently contains fields that calculate the beginning and end balance for each period. The parameters Iām using in my report are looking at dates, rather than periods.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.