Tracking assets in inventory (MMBE)

[Former Member]

Hi folks,

Is there some way to simultaneously track a material in inventory (via its serial number) and as a fixed asset for accounting purposes?

The scenario is the following:

1) create purchase orders for materials

2) perform goods receipts in plant/storage location A (serial number recorded for each material)

3) as required by the business, transfer materials to plant/storage location B (serial number recorded for each material)

4) At any point in time we must be able to know the quantity and serial numbers of all materials in plant/storage location A, and the quantity and serial numbers of all materials in plant/storage location B

5) At month end these materials should all be treated as fixed assets and have their depreciation calculated and posted

Thanks,

Sebastian

[former_member533946]

Hi dear,

You first 4 requirements can be met by one of the following methods.

1) Create spearate material type for the asset materials.So that by number range itself u will be able to identify the Assets in vrious plants along with quantity and value.

2) You can make use of material group field in the material master.Maintain the materail group as fixed asset for those material.U can create copy of std report MB52 and bring the material group field in that report thus u will come to know the stock and value of the asset in several plants and at different storage location.

3) You can make use as split valuation.Materials can be matained as an asset material or non asset material.Again in MB52 or MMBE u will get the details.

[PollyGan]

Hi Sebastian,

In MMBE, and put the cursor at storage location, and use menu->environment->equipment/serial number,

then you will be able to check the serial number link to the material/plant storage location.

Thanks and regards,

Polly