I am using INItemSiteHistDay to write a GI for inventory aging. The field INItemSiteHistDay.QtyIn is available for the results grid. However, INItemSiteHistDay.QtyIn and INItemSiteHistDay.QtyOut are not available for formulas or selection criteria. I need the QTY for every transaction in and out of inventory and these seem like the 2 fields I need. I’m unsure why they are only available to the results grid.
Thanks for any guidance!
Best answer by Naveen BogaView original
INItemSiteHistDay.QtyIn and INItemSiteHistDay.QtyOut will NOT be available for in GI formulas, because these are NOT bound fields instead of calculated fields dynamically.
If you review the INItemSiteHistDay DAC file, you will understand how calculations are happening for the QtyIn and QtyOut.
QtyIn = INItemSiteHistDay.qtyReceived + INItemSiteHistDay.qtyTransferIn + INItemSiteHistDay.qtyAssemblyIn
QtyOut = INItemSiteHistDay.qtyIssued + INItemSiteHistDay.qtySales + INItemSiteHistDay.qtyCreditMemos + INItemSiteHistDay.qtyTransferOut + INItemSiteHistDay.qtyAssemblyOut
In the GI formula, you can use the above fields instead of QtyIN and QtyOut.
Hope this helps!!
It sure does help!
So many of Acumatica users are in need of an inventory aging report. If you are so inclined, please tell us more about your report and how it is working.
@ltussing03 were you able to create a report for aging? I’ve been trying to create a GI and have been unsuccessful.
@ipenrod - Check out Tim Rodman’s Generic Inquiry and Pivot tables course. He has an example of how to create an Inventory Aging Report in his appendix of Tips and Tricks.