I need to add the Qty available to the Inventory Valuation report, however the entire report seems to be based off Qty on hand in the INTranCost table. We need to know how much of a given product is available and the total cost of everything sitting on the shelf unsold. Has anyone else tried adding this field to the report in report designer?
Update inventory valuation report to display Qty Available instead of Qty on Hand
Userlevel 4
You will need to add INSiteStatus as a datasource to the report.
INSiteStatus can be joined to INSite table by the SiteID.
INSiteStatus.QtyAvail is the field that you will need to add.
Is there a trick to joining these tables? I tried a couple of times and the report fails to open.
+18
Hello,
Please, can you show your join, show any error that appears on screen when the report does not open, and any details of the errors showing in Tools → Trace?
Thank you.
Laura
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.