SAP Knowledge Base Article - Public

2065739 - Selection on G/L Account Not Working In Financial Reports

Symptom

You run a standard financial report such as Accounts Receivable Reconciliation or Accounts Payable Reconciliation. You want to run a selection on a certain G/L Account and find that whatever value you select will not affect the report result. Regardless of the selection you will always get all G/L Accounts in the report.

Reproducing the Issue

  1. Go to the General Ledger work centre, Reports view
  2. Find and Open either of the two above reports
  3. Make sure to include G/L Account as a variable in the selection area
  4. Select any G/L account and run the report

Cause

G/L Account is a compounded field. It is compounded with Chart of Accounts. So it won't work if you put it as a selection parameter directly.

Resolution

We can suggest two solutions.

Solution 1:
If you want to put G/L Account as selection parameter then it has to be added as hierarchy: To do so hit the Add Fields button in the report. Then expand the Dimension: Accounting. For item G/L Account check all three boxes (Display in Report, Display in Selection Area and Display as Hierarchy). You will then have two selection variables G/L Account ( Hierarchy ) and G/L Account. In productive use you then need to select a value first from G/L Account ( Hierarchy ) and afterwards from G/L Account.


Solution 2:
You can use Edit Filter instead of the selection: After you produced a report switch to the Edit Filter tab and select the desired accounts from the value help for G/L Account. For this solution you do not need the hierarchy as in solution 1.


Please note that these solutions might not work with direct / manual data entry (i.e. you should always use the value help for selection).

Keywords

KBA , accounts receivable reconciliation , accounts payable reconciliation , compounded characteristic , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions