Skip to main content
Solved

Quantity on hand with Receipt number in Generi inquiry


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.

 

Best answer by Jennifer Douglas

I believe this is populated from INCostStatus.QtyOnHand.  

View original
Did this topic help you find an answer to your question?

3 replies

Jennifer Douglas
Varsity I
Forum|alt.badge.img+1

I believe this is populated from INCostStatus.QtyOnHand.  


  • Author
  • Freshman I
  • 2 replies
  • June 8, 2023

Hi Thanks , that is the one I want


Forum|alt.badge.img+1
  • Semi-Pro I
  • 97 replies
  • August 28, 2024

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

https://community.acumatica.com/ideas/auto-select-receipt-number-on-inventory-adjustments-in-fifo-18919

 

which so many others have struggled with

https://community.acumatica.com/distribution-6/inventory-adjustment-error-asking-for-receipt-nbr-8262https://community.acumatica.com/distribution-6/inventory-adjustments-with-multiple-lines-of-the-same-inventory-id-11099

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings