Skip to main content

I want to have a generic inquiry form with 3 columns : Inventory ID, receipt number, quantity on hand.

Does anyone knows how can I get these data from database?

I can see this form on Adjustments screen. but can not see the details from here.

 

I believe this is populated from INCostStatus.QtyOnHand.  

Hi Thanks , that is the one I want

I’m trying to build a GI that would allow us to pull the required fields for uploading adjustments into a system that uses FIFO - specifically I need:

  • Inventory ID
  • Warehouse (Site ID)
  • Location
  • Quantity
  • Cost
  • Receipt Nbr.
     

INCostStatus is essential to get the Receipt Nbr. as well as INCostStatus.QtyOnHand and INCostStatus.TotalCost which we need because of FIFO. But these seem to be entirely unrelated to INLocationStatus, which we also need to specify for INLocationStatus.qtyOnHand

 

Does any happen to have a similar report already built or know how we can build a relation between INCostStatus and INLocationStatus? It seems like these are entirely unrelated and we could have inventory in multiple locations spread across numerous receipts and cost layers..

 

Of course, this would all be much easier if adjustments could auto-allocate the cost layers according to the logics of FIFO

 

which so many others have struggled with

 

Reply


Terms & ConditionsCookie settings
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 — 2024  Acumatica, Inc. All rights reserved