Physical Inventory verification of fixed assets

[emad_gamal]

Could you explain the process of Physical Inventory verification of fixed assets in SAP. My questions are

1. How we will create lists based on sort criterial and distribute them to the users who are performing the physical count.

2. Once they update the lists is the system automatically updates the "Last Inventory on" field in Asset Master record. If not how to update the field at a time for all the assets.

3. where we can see the differences for the physical count and action taken for the differences.

[former_member190588 · Accepted solution]

Hello Emmo,

Definitely if you require the whole process to be automated is to start from the inventory checking by using bar code tagging. Based on the bar code tagging the user can get the data of the physical assets. You need to have some abap developed or use existing some program which will upate the asset master with the inventory status.

Honestly, other than this option, user have to take a print out of the list of assets from any of the asset reports  and perform a checking against physical asset.

regards

pbb

[ajaycwa1981]

Hi Emad

You can use Asset Mass changes option to do this

Write a Asset Substitution for the Mass Changes on Inventory field and the date can be mentioned in a SET (GS01)

When you process a worklist from AR31/32, the changes get updated

Otherwise, use an LSMW

Br. Ajay M

[emad_gamal]

hello experts ,

firstly , i appreciate your quick response   ,

secondary really  Nitin is a very useful report you are sent but i need to know more about how can post the difference using whether by Special transaction type or other .

if it uploaded by LSMW could you explain what is the object & method & program can used it .

[Former Member]

Hi Emad,

if there is a difference between the accounting data & physical inventory count, then definitely some event/transaction has happened which has not been accounted for in the system as far as Physical asset is concerned.

Once the reason for that is ascertained you can pass the relevant entries in the system through various transactions such as Asset retirement, scrapping etc. This is what i meant by posting using transaction type.

You may need to get in touch with the ABAP consultant to check on the LSMW details, i am not sure of that part.

Hope it helps

Regards

Nitin

[Former Member]

Hi Emaad,

1. You can download the Asset List by various criteria from the below mentioned path

Accounting  / Fixed Assets  / Information System / Reports on Asset Accounting / Asset Balances  / Inventory Lists / Physical Inventory List

2. You may need to create a LSMW to update all the asset records at once for the asset.

3. If there is a difference between the accounting data  & physical inventory count the difference can be posted in the system using Special transaction type.Though How to display it i am not sure on

Regards

Nitin