Audit Report in XLR or Query
Can you please help me to create audit report including batches in XLR ir query. First I would like to anderstand how can I create Audit report and then I will join batched to this report
Julie Jamieson replied
I have a Stock Audit report developed in XLR. It uses the Items and Warehouses Dimensions, Report defaults ITM Onhand <>0, and uses a parameter to select the warehouse.
The row just groups by itemCode.
I have selected the following:
ItemCode, ItemDecsription from Items, OnHand (in Stock) and Transaction Value from Stock Management. Transaction Value divided by on hand gives you the moving average price per unit.
Hope this helps