cancel
Showing results for 
Search instead for 
Did you mean: 

Upload Asset Balances?

Former Member
0 Kudos

Dear All,

I uploaded 1000 Assets through LSMW from Tr code AS91. Now, for Asset Balance Upload We can use 2 Tr codes OAMK and OASV.

Can anybody explain the process to upload Asset balances (Acquisition value & Accumulated Depreciation) with entries and GL Accounts and

Impact of TB,

Thanks

Anil

Accepted Solutions (1)

Accepted Solutions (1)

Marssel700
Active Contributor
0 Kudos

Anil,

Fixed Assets have to be posted in 2 stages:

1 - Master records values - LSMW

2 - GL Account balances - OAMK and FB01, or OASV.

Use OAMK only tor accounting adjusts. It unlocks reconciliation account from AO90 to be posted.

In tis case the best choice is OASV. You have to post Acquisition and Acumulated depreciation accounts (Check AO90) and post against Migration transitory account (EG 999999).

Take a look in below sample. The Expenses account were done in P&L migration then assume only Acquisition and Cumulative depreciation:

Best Regards

Former Member
0 Kudos

Hi Marssel,

As per your screen shots given.

I have 5 Assets

1. Land

2. Plant & Machinery

3. Furniture & Fixtures

4. Building

5. AUC

Dr Acquisition Value for all 5 assets, for all Dr shall I create 5 new GLs say in your case L215100 so on.

Comming to Cr Accumulated values for all 5 assets shall I create 5 new GLs.

As mani told

1. Acquisition Posting :-  Single entry enough for all assets.

    

    Fixed asset GL account............Dr

       To Initial Balance account ..................Cr

2. Accumulated depreciation posting :- Single entry enough for all assets.

 

   Initial balance account............Dr

     To Accumulated balance account.........Cr

Please clarify..........on the same

Former Member
0 Kudos

Hi Anil,

Yes 5 Different Fixed Asset GL Accounts would be required to be created as it would depend upon your Account Determination ID against the Asset Class.

Acquisition:

a)

Land A/c. (A1000) Dr.

To,

Asset Offsetting (Z9999) Cr.

b)

Plant & M/c.  (A1100) Dr.

To,

Asset Offsetting Cr.

And yes for Acc. Depreciation also 5 Different GL Accounts needs to be created.

Regards,

Jaymin R. Bhatt

suma_mani
Active Contributor
0 Kudos

Hi Anil,

If have you created separate GL accounts based above one 1 to 5 ,you have to enter entry as follows.

Land....................Dr

Plant & Machinery...Dr

Furniture & Fixtures...Dr

Building................Dr

AUC.........Dr

    To Initial balance upload account...........Cr

Initial balance upload account..........Dr

  

        Accumulated Land....................Cr

       Accumulated Plant & Machinery...Cr

       Accumulated Furniture & Fixtures...Cr

       Accumulated Building................Cr

Better to create separate GL accounts against Asset classes,so that you can easily reconcile with using of ABST2 report.

Regards

Mani




Former Member
0 Kudos

Hi Mani,

Yes, 1 have created separate GL accounts for all the assets (APC & Separte GLs for Acc Dep). In that case i can go head with

Land....................Dr

Plant & Machinery...Dr

Furniture & Fixtures...Dr

Building................Dr

AUC.........Dr

    To Initial balance upload account...........Cr

Initial balance upload account..........Dr

        Accumulated Land....................Cr

       Accumulated Plant & Machinery...Cr

       Accumulated Furniture & Fixtures...Cr

       Accumulated Building................Cr


Marssel700
Active Contributor
0 Kudos

Anil,

once you have 5 assets classes I recommend you create 5 accounts for Aqcuisitions and 5 for Cumulative depreciation. Check with your accountant before do that. Check also your AO90 in order to verify if you already have it.

Best Regards

suma_mani
Active Contributor
0 Kudos

Yes Anil.

it is better idea go like this. Make sure account determination once again as suggested by Mr. Marssel.

Regards

Mani Kumar

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi all,

I have small doubt in asset upload

Eg: asset Purchased on 01.04.2005         - Rs 10000

      Some asset added on 01.08.2009      -  Rs. 50000

For Example Acc.Dep  - Rs 2000 till now

here how we upload asset additions

Thanks

Former Member
0 Kudos

Hi Anil,

Please read below wiki link: It explains the Asset Legacy steps.

http://wiki.sdn.sap.com/wiki/display/profile/Asset+-+Legacy+Migration+Guidelines

Regards,

Jaymin R. Bhatt

srinivasa_maruvada
Active Contributor
0 Kudos

It appears you have already created Legacy Asset Master data

Now got ot As92 and select Asset take over values and enter legacy asset values

To post in  GL account, go to OAMK and change the control of reconciliation account to "BLANK"

Post GL balances and go to OAMK and restore control of reconciliation account to " ASSETS"

Check the legacy asset value and GL account are balanced

Thanks

Srinivas ,

Former Member
0 Kudos

Hi Srinivasa,

In Tr Code OAMK, I changed the reconciliation account and kept Blank, After that what I have to do, How to post Asset balances in Tr code OASV. And what are the GL Accounts I have to take and entries.

suma_mani
Active Contributor
0 Kudos

Hi Anil,

At last your General ledger balances and Asset sub ledgers must be tally. You always upload legacy balances which is previous year through AS91. In AS91 it self you have to update actual acquisition value and either depreciation or accumulated depreciation & also do mentioned entries through OASV.

1. Acquisition Posting :-  Single entry enough for all assets.

     

    Fixed asset GL account............Dr

       To Initial Balance account ..................Cr

2. Accumulated depreciation posting :- Single entry enough for all assets.

  

   Initial balance account............Dr

     To Accumulated balance account.........Cr

Regards

Mani Kumar