2496112 - G/L Line Items Report - France - Statutory Report Opening Balances of Acounts Displayed Incorrectly

SAP Knowledge Base Article - Public

2496112 - G/L Line Items Report - France - Statutory Report Opening Balances of Acounts Displayed Incorrectly

Symptom

You have executed the G/L Line Items Report -France for a specific accounting period and a specific range from G/L account ABC to G/L Account DEF.
In the Results list you notice that the Opening Balance of certain G/L accounts is not correct. You expect the same value as displayed in the Trial Balance report, according to the closing balance of the previous accounting period.

Reproducing the Issue

  1. In the General Ledger workcenter navigate to the Periodic Tasks - Statutory Reports view.
  2. Press on the G/L Line Items Report - France report link to open the report.
  3. In step 1- Selection maintain all mandatory information.
  4. To maintain a G/L Account range enter values into the G/L Account From/To fields.
  5. Press Next to navigate to step 2- View Results.
  6. In the Accounts by Period table you notice that the opening balance of certain G/L Accounts is not the same as displayed in the Trial Balance report for the same accounting period.

Cause

When a G/L Account range is maintained, i.e. when values are maintained in the G/L Account From/To fields the run is not able to identify the range correctly and inconsistencies, such as the incorrect G/L account opening balances can occur.

It is planned to correct this current system behaviour with the nect SAP ByDesign version 1708.

Resolution

Until this issue has been permanently fixed it is possible to display the G/L account balances correctly by not maintaining a G/L account range in the Selection step:

  1. In the General Ledger workcenter navigate to the Periodic Tasks - Statutory Reports view.
  2. Press on the G/L Line Items Report - France report link to open the report.
  3. In step 1- Selection maintain all mandatory information.
  4. This time keep the G/L Account From/ To fields empty.
  5. Press Next to navigate to step 2- View Results.
  6. In the Accounts by Period table all G/L Accountopening balances appear correctly as per the Trial Balance report.  

Keywords

KBA , AP-CI , Customer Invoice Processing , How To

Product

SAP BUSINESS BYDESIGN 1705