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?
Answer
Update inventory valuation report to display Qty Available instead of Qty on Hand
Best answer by ejmillar
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.
+1You 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.
Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
+19Hello,
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
~ Laura Barber, WM Synergy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.