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 Boga
Hi
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.
Formulas:
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!!
+19Hi
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.
Formulas:
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!!
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.
Hey
Landon
@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.
Hello,
A little late on the conversation but I just saw the Inventory Aging report (by Tim) mentioned above and it says it does not work with Std or Avg cost valuation methods. Does anyone have come up with a GI for “As Of” valuation by time frame (day, is what I need) when using Std or Avg?
If so, would you tell me the tables to join, or better yet, can you share the XML?
Thank you very much,
Rgds,
Claudio
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
