Ok, let's see if I can break this down:
Each Item has unlimited locations. Each location can have many transactions (receipts, xfers, stock issues, etc). These values are stored in three records: Item Master, Item Locations, Item Trans.
I am trying to take the Sum of the QTYONHAND from the...
I am trying to create a report to show a QTY for a value based on several different levels. These values come from three different records. Transaction level, a "location" level, and finally a Total value level. When I sum the "location" and compare it to the Total level, it...
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.