1947695 - Journal Entry External Reference ID Not Populating in the Journal Report

SAP Knowledge Base Article - Public

1947695 - Journal Entry External Reference ID Not Populating in the Journal Report

Symptom

The Journal Entry External Reference is not populating in the Journal report.

Reproducing the Issue

  1. Open the Journal report.
  2. Enter the desired values on the Selection Screen and select GO.
  3. Add some characteristics in order to fill the report with some data. For example, Journal Entry, Posting Date, G/L Account and Journal Entry Type.
  4. Make sure the characteristics Source Document External Reference and External Reference ID (Journal Entry) are also visible in the report. (Note: the External Reference ID can be added via the Add Field function).
  5. You notice that the Source Document External Reference and External Reference ID (Journal Entry) are shown as # (Not assigned) in the report.

Cause

The system behavior is as designed.

Resolution

The Journal report will display the External Reference values, for a Journal Entry, only if it is available from the Journal Entry document.

Usually the External Reference number is generated for Supplier or Customer Invoice Journal Entry Type so unless the Journal Entry matches these criteria the External Reference values will be shown as # (Not assigned) in the report.

The best way to check if the External Reference value is available on the Journal Entry is to navigate to the Journal Entry ID directly from the report.

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP BUSINESS BYDESIGN 1708