on 08-11-2013 11:11 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.