Solved

INItemSiteHistDay.QtyIn (and QtyOut) not available for formula or selection criteria

  • 17 January 2022
  • 5 replies
  • 56 views

Userlevel 4
Badge

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!

icon

Best answer by Naveen Boga 17 January 2022, 16:58

View original

5 replies

Userlevel 3

@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.

Hey @ltussing03  were you able to create a report for aging? I’ve been trying to create a GI and have been unsuccessful.

 

Landon

Userlevel 4
Badge

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.  

Userlevel 4
Badge

It sure does help!

 

THANSK!

Userlevel 7
Badge +12

Hi @ltussing03 

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!!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved