Audit Report in XLR or Query

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

Thank you for the information. I don't have B1 2004 and it will take time to reinstall it. Is it possible to download audit queries?

Thanks,

Olga

[former_member186095]

Hi Olga,

In SAP B1 2004A, there are 4 audit reports using query.

using XLR, it will take many efforts. I suggest you to join XL reporter mailist.

If using query PLD, it has many limitations but you could try. Check this note 1155872 and 854321

Rgds,