Skip to Content
avatar image
Former Member

Physical Inventory verification of fixed assets

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 27, 2014 at 09:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2014 at 05:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    May 27, 2014 at 04:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded