Thank you for your help. It seems to be working now, for the most part.
Yes I am updating the quantity by reducing the qty_on_hand in table IMINVLOC_SQL.
Also, "disbursements" was a typo. I meant "distributions".
I do have a couple more questions:
1. In the IMDISFIL_SQL table, what goes in...
Does anyone know the sql behind the Inventory Transaction History Report? I am attaching a screen shot.
I am manually entering an Issue (doctype=I) into the macola database, instead of entering it through the Macola application. I have successfully entered a transaction into the IMINVTRX_SQL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.