By using this website, you agree to our Terms of Use (click here)
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 tables it is using(Screenshot attached)
Hi Terry,
I hope this helps. Please let me know.
Rgds,
Claudio
@crm001 Thanks, your screenshot is very helpful for me to find the right table. This guided me to the DAC Schema Browser, where I found the data I need on the INCostStatus table.
@terry5201 No worries Terry. I am trying to get more active on the forum. I am still fairly new to working with Acumatica in "real life".
Rgds,
Claudio
To get quantity on hand, we use INSiteStatus.QtyOnHand
@rpiester I need link with inventroy receipt number, so I found INCostStatus.QtyOnHand. it works ,thanks again
Online Members
