One of our client requirement is that, we have one non leading ledger(1L), our fiscal year is july to june. Now there requirement is that we wnt live at july 2010, now they doesn't want the data in the system from july2010 to june2011 which is a one full fiscal year, instead they will give a TB which we have to upload as opening balance for july2011. Now my query is that
1. Is that possible to delete/hide the entry between july2010 to june2011 if so please explain.
2. How can we upload the TB as opening balance for july2011.
Q1 Non-leading ledgers are alreday posted, so I think it may not possible.
Q2. TB - Upload:
Record a LSMW for F-02. If you are not familiar to LSMW, ask your abaper to create BDC for transaction F-02
Maintain data in excel file according to the format of LSMW/BDC.
Upload it into system.
You have to create 4 GL upload clearing accounts.
1. GL Upload clearing
2. Vendors pload clearing
3. Customers upload clearing
4. Assets upload clearing
After uploading the balances you can a pass an adjustment entry for these clearing accotns. Any way total balance for uploading clearing accounts should be zero.
Note check this link for your ref.