Hello everyone,
I am in the process of creating a generic inquiry that shows an inventory valuation by date. The reports that are pre-built with Acumatica only show by financial period. The most important column is the quantity on hand (which is used to calculate the value of the inventory).
Here are my joins:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/74ec06da-188d-4e87-a9d6-46e2bbaa39b4.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8b7f3e2e-e265-4c43-9c56-4a5d92d5898c.png)
Most of my joins are on inventoryID or siteID.
For quantity on hand I am using this:
The problem is that the quantity on hand that I am picking up is simply the latest quantity on hand, rather than the quantity on hand as of the date chosen in the parameter: Does this seem to be a conditions/parameter issue? I am in the process of testing with trial and error on the conditions and parameters. Maybe there is another table I should use for qty on hand? Thank you all for any input.