Process analytics for SAP current asset transactions

Posted by Prof. Dr. Nick Gehrke on Nov 29, 2016 5:05:00 PM

Part VI of the series: "Digitization of auditing SAP Fixed Asset and Inventory Processes"

Today's blog post presents three interesting indicators for detecting process weaknesses in the area of current asset transactions in SAP.

 

1. Auditing SAP processes in fixed asset and inventory
2. Master Data audit of SAP fixed assets
3. How to audit fixed assets procurement in SAP
4. SAP data analytics for fixed asset depreciation
5. Auditing fixed asset retirement in SAP
6. Process analytics for SAP current asset transactions
7. Segregation of Duties in SAP asset management
8. Fixed asset data structure in SAP
9. Professional Judgement in auditing SAP fixed assets

 

Before you proceed reading on the details of the indicators, I would recommend you read the concept of indicators first.

 

puzzle-673250_640.jpg

 

Three TOP indicators for auditing SAP inventory

As already mentioned, every indicator is associated with a process, a process area, an audit objective and a risk respectively. In the following, three selected indicators in the area of current asset transactions are presented.

Altogether I have designed and implemented 22 indicators for the fixed asset and inventory process. You can download the details about all fixed asset and inventory indicators here:

 

Download pdf

 

Stock transfer with different stock valuations

This indicator aims at identifying compliance and correctness.

There is the risk that the stock value in the balance sheet changes due to internal stock transfers, because different valuations are used in different plants.

The criteria for this indicator is:

The FI document has been marked because it is linked to a material document which is indicated to be a stock transfer between plants. The involved plants are not assigned to the same valuation area, but the valuation areas belong to the same company code. Furthermore, the valuation class (MBEW-BKLAS), the price control indicator (MBEW-VPRSV), the standard price (MBEW-STPRS) or the moving average price (MBEW-VERPR) for the transferred material are not the same.

 

Goods movement after stock taking

This indicator aims at identifying compliance and correctness.

There is the risk that inventory is not accurate because a goods movement was posted after stock taking with a posting date prior to stock taking.

The criteria for this indicator is:

The FI document has been marked because it is linked to a stock taking material document and there is another material document that has been processed after the posting date of the stock taking material document, but has a posting date prior to the posting date of the stock taking material document and both, material and plant are the same.

 

Physical inventory documents posted by users without tolerance groups for inventory differences

This indicator aims at identifying restricted access.

There is the risk that inventory differences could be posted during physical inventory without any limits.

The criteria for this indicator is:

The document has been marked because it is linked to a material document which is indicated to be a physical inventory document (MSEG-BWART=7xx) and the physical inventory document was posted by a user who is not assigned to a tolerance group for inventory differences (Table T043).

 

Topics: SAP, Audit, inventory, process analytics

Blog Commentary