All Main and subledger balance transfer

[harishvee]

Hi Team,

We are using ECC classic G/L.

We have one scenario, where in our system Venezuela company code is inactive since 2019 due to currency change and they are not maintaining any transaction after 2019, but they are maintaining transactions for this company code outside SAP, now they are planning to activate this company code in SAP for that I have some doubts.

Step 1

1. Balances carryforward is not done from 2019 and subsequent years. They want all these balances to make it zero in Special period 13.

2. Upload balances from third party system to current fiscal year.

Please let us know what steps need to take from our side. These all things need to do by our team only without any SAP Support. Let us know all the steps to be performed in all modules.

[harishvee]

Please assist me.

[ElizaEchavarria]

Hello Veera,

It's not a simple procedure.

For making the balance 0 for 2019 you can use a specific account, like a "migration account", but in this case you are going to do the opposite, and you need to know all the different postings you have in 2019. So you can have a procedure to solve them all.

I will try to tell you the most common postings for finance area:

AP/AR Open items. Clear all open items like if you have paid them/they have been paid, but against the "migration account" (F-53/F-28)

Assets. Sell them all or do a retirement (ABAON/ABAVN). This will post to a specific P&L account, and consider to cancel them in the step for P&L accounts.

GL accounts. Post a document with the balance of each GL account against the "migration account" FB50

P&L accounts. Post a document with the balance of each P&L account against the "migration account" and select a cost center/profit center for doing this posting. FB50

Bank accounts. If you are using bank statements, customize a new posting rule similar to a bank fee, but use the "migration account", so you can post an outgoing payment with the balance of each bank account. (FF67) If you are not using bank statements, just follow the process like a GL account.

Because all the balances are going to be posted to the "migration account", then at the end the "migration account" should be 0.

Additionally of these steps in Finance, you will need to review the logistics modules, like for example how to close purchase orders, sales orders, etc.

Now for uploading balances from your third party system, post a document for each account against the migration account (or you can create an abap program to help you for doing this)

AP/AR Open items. Post invoices/credit memos against migration account FB60/FB70

GL accounts and Bank accounts. Post a document with the balance of each GL account against migration account FB50

P&L accounts. Post a document with the balance of each P&L account against migration account and select a cost center/profit center for doing this posting. FB50

Bank accounts. If you are going to use bank statements, in your first bank statement you can set the current balance.Because all the balances are going to be posted to the migration account, then at the end the migration account should be 0.
Additionally of these steps in Finance, you will need to review the logistics modules, if you need to create purchase orders in process, sales orders, how to upload inventory, etc.

I'm sure there are more things to consider but this could be a good start.

https://blogs.sap.com/2019/05/29/cutover-tips-focusing-on-finance-scope/ <-and this is a good blog to read about it.

Regards.