Migration of G/L balances

[Christopha]

Dear SAP experts,

I have a few short questions regarding the migration of G/L balances. We are going live on 01.07.2019 and the migration key date is set to 30.06.2019:

Is it correct to use the migration template "FI - G/L account balance and open/line item" for migration of the (balance sheet) G/L accounts balances for June? If not, which document do we have to use?

Is it correct to use "39916000 - Initial other G/L offset" as offsetting account (as some actual SAP documents say that this account is obsolete)?

Do we have to use the "30.06.2019" as document date within the template?

What has to be entered in the field for "Reference Document Number"?

Is there anything else that is important that I am missing?

I have already read some other blogs (https://blogs.sap.com/?p=126) but unfortunately I could not find the right answers.

I would be really glad if someone could shortly answer my questions, as we are really struggling with this at the moment.

Many thanks in advance!

Best regards

Christoph

[David_Byrne · Accepted solution]

• Is it correct to use the migration template "FI - G/L account balance and open/line item" for migration of the (balance sheet) G/L accounts balances for June? If not, which document do we have to use?

Yes this is the correct 1

• Is it correct to use "39916000 - Initial other G/L offset" as offsetting account (as some actual SAP documents say that this account is obsolete)?

No this has not changed and is outlined in the best practice test script from the below link

https://rapid.sap.com/bp/#/browse/scopeitemversions/BH5/S4CLD/1905/XX

• Do we have to use the "30.06.2019" as document date within the template?

No this is a project decision based on requirement some customers can update multiple periods in order to have the comparison history in the standard Plan/Actual Reports.

• What has to be entered in the field for "Reference Document Number"?

As outlined in the field the reference document number can contain data such as the number of the business partner for tracking but this can be decided based on the project requirement so could be populated with other data.

• Is there anything else that is important that I am missing?

It is hard to comment without the full details of your migration approach but in general SAP recommends that the migration process is tested fully before golive to make sure the templates are populated correctly and that the balances on the trial balance are aligned to the legacy solution after upload

[former_member132363]

Here are some SAP resources you may review based on your topic "balance sheet,g/l,g/l balances,g/l account,g/l accounts balances,line item"

Display Financial Statement

An application to display financial statements including all G/L accounts, not assigned accounts. It allows navigation to G/L account balances and line items as well as to customer ... Specific node of a balance sheet or profit and loss statement.

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F0708')/S8OP

2150990 - G/L Account Balances Migration Errors

You are migrating General Ledger Account Balances not successful due to numerous errors For gen. Ledger Purposes, At Least One Debit And Credit Line Required. Accnt Conversion: A/P Open Items In Chart Of Accounts XYZ Not Permitted For Posting Using ... Migration of a G/L Accnt with zero balance is not possible.

https://apps.support.sap.com/sap/support/knowledge/public/en/2150990

2158803 - Amounts Posted to Unexpected Accounts During G/L ...

After performing a migration of G/L Account balances via the migration tool, you notice that some of the balances have been posted to accounts which ... When verifying the results in report G/L Accounts - Line Items (FINGLAU02_Q0001), you ... balance sheet accounts as long as these have the correct G/L Account type.

https://apps.support.sap.com/sap/support/knowledge/public/en/2158803

[former_member132363]

Asset legacy data migration postings will have posting date as the legacy asset data transfer date set in the system which is 31.03.2018 in your case. This is a standard setting as closing asset balances as on that date are migrated.

[View Article](https://answers.sap.com/questions/13242702/view.html)

I hope this answered your question! If it did, please mark it as the 'Best Answer' so I can continue learning and answering questions in the community.