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
- Go to the General Ledger work centre, Reports view
- Find and Open either of the two above reports
- Make sure to include G/L Account as a variable in the selection area
- 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