Symptom
Unexpected/ wrong creditor business partner in Journal (FINGLAU03_Q0001) report.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the List subview in the Reports view.
- Search for Journal (FINGLAU03_Q0001) report and select it.
- Run the report.
- In the Row fields, bring in the row Creditor Business Partner in Journal Entry Item.
You see that for certain Journal Entry items, a Creditor Business Partner is displayed.
You expected no Creditor Business Partner or it is the wrong Creditor Business Partner.
Cause
The Creditor ID is pulled from the line items of the Journal entry.
If there is no Creditor ID displayed for the line item, it does not show any.
- Go to the General Ledger work center.
- Go to the List subview in the Reports view.
- Search for Journal (FINGLAU03_Q0001) report and select it.
- Run the report.
- In the Row fields, bring in the row Creditor Business Partner in Journal Entry Item.
- Select the Journal Entry ABC (ABC is the Journal Entry ID).
- All Items of except one Item is showing a Creditor Business Partner.
- Click the Go To Icon and select View Journal Entry.
- This opens the Journal Entry 100000000129.
- Navigate to the Line Items section in the Journal Entry tab.
- Click Start Personalization Mode.
- Navigate to the Line Items section in the Personalization window.
- Click to expand the same.
- Make the Fields Creditor ID and Creditor Name visible.
- Click Save.
- Click Stop Personalization View.
You can see that for every line item of this journal entry except for one, a Creditor ID is displayed.
This is why it is appearing in the Report.
Resolution
System is behaving as expected.
If the Journal Entry Item does not contain any Creditor Business Partner, the field is left empty.
Use the Business Partner field instead. The Business Partner Field will show no results.
- Go to the General Ledger work center.
- Go to the List subview in the Reports view.
- Search for Journal (FINGLAU03_Q0001) report and select it.
- Run the report.
- In the row fields, bring in the row Business Partner.
Keywords
creditor business partner; journal report; Buchungsbeleg Bericht; FINGLAU03_Q0001 , KBA , AP-ACC-GL-ANA , Analytics , Problem