The Journal Entry External Reference is not populating in the Journal report.
Reproducing the Issue
- Open the Journal report.
- Enter the desired values on the Selection Screen and select GO.
- 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.
- 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).
- You notice that the Source Document External Reference and External Reference ID (Journal Entry) are shown as # (Not assigned) in the report.
The system behavior is as designed.
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.
KBA , SRD-FIN-GL , General Ledger , How To