Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Audit Report in XLR or Query

Hi,

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

Thanks,

Olga

replied

Hi Olga,

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question