When I run the Inventory Valuation Summary Report and sort by Item, I need to have the total quantity shown in the report as well as the monetary value which is there already.
I have tried to add the field TotQty which is in the detailed report, but the field is unavailable in the ReportData pipe.
How do I add this field to the Summary Report.
Your assistance would be appreciated as our Auditors insist that the Qty be shown in the report.