3567778 - G/L Accounts Line Item Report - Offset Customer/ Supplier ID is displayed as #

• In the G/L Accounts - Line Items report, the "Offset Customer / Supplier ID" field does not display the Business Partner ID for all Journal Entries.
• Instead of the Business Partner ID, a "#" value is displayed for many entries.

SAP Business ByDesign

1. Go to the Business Analytics work center.
2. Go to Design Reports View.
3. Search and Open the G/L Accounts - Line Items report.
4. Enter the relevant details for Company, Set of Books, Accounting Period/Year, G/L Account, and Display Currency - Conversion Date.
5. Add the Offset Customer / Supplier ID field to the view and apply the changes.
6. Observe that the Offset Customer / Supplier ID field displays "#" for many Journal Entries instead of the Business Partner ID.

The Offset Customer / Supplier ID is not determined by the system for all Journal Entry items. 

Follow the below in the G/L Accounts - Line Items report to display the Business Partner ID,

When looking for Supplier Invoices:

• If a Supplier invoice is obtained from a Purchase order, then the respective Offset Customer / Supplier ID field displays the Business Partner ID in the Report.
• If a Supplier invoice is derived directly (without Purchase Orders), then add the field - Creditor Business Partner (Journal Entry Item) to view the Business Partner ID in the report.

For all other scenarios:

• Use the Field - Business Partner (Journal Entry Item) to display the Business Partner ID in the report.

G/L Accounts, Line Items Report, Business Partner Details, Offset Customer / Supplier ID, Journal Entry, Business Partner ID, Creditor Business Partner, Business Analytics, #. , KBA , SRD-FIN-ANA , Analytics Content , Problem