Hi ,
For uploading you need to create 5 GL masters
You can create one account grp Uplaod accounts.
Tax Catergory 😘
Line Item Display : Yes
Open Item Display : Yes
Sort: 0001(Gl), 012(Vend),031(Cust)018(Asst) etc
FSG: g001
Under that grp you need to create all 5 accounts . All are balancesheet Accounts
GL Balance Upload Ac
Customer Balance Upload Ac
Vendor Master Uplaod Ac
Asset Master Upload Ac
Material Upload Ac
You should take the trail balance of the company and chose all gl accounts with balances
use LSMW uplaod GL balance upload f-02
Example : Salareis Acc - 5000 Dr Balance
Then entery will be
Salaries Ac----
Dr 5000
To GL Uplaod Ac 5000
Example : Rent Ac-2000 Cr Balance Ac
Then the GL entry will be
GL upload Ac----
DR 2000
TO Rent Ac 2000
Example for Vendor upload Account
Vendor Cr Balnce- 5000 and client want ot upload line item wise
ex line items are: 1000,2000,3000
Vendor Upload Ac----
Dr 50000
To Vendor Ac 1000
To Vendor Ac 2000
To Vendor Ac 3000
Same with the case of Customer,
For material initial upload use T-code MB1C and movement type will be 561
For Asset upload you give AS91 T-code
After upload block all the 5 gl masters which you have created for upload
dont show this Gl in Financial statement versions.
Hope this will help you.
Best Regards
Ashish Jain
Pls reward points if this is helpful to you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.