Symptom
When executing the Cash - Open Items report and noticed that Offset Customer/Supplier field shows # and not showing the Payee Name.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Open Cash - Open Items report.
- Give the relevant selection for company and set of books.
- Execute the report.
- Filter the relevant document id and could see Offset Customer/Supplier ID is showing #.
Cause
The issue is happening as the Payment method is not maintained in the Supplier master data.
Resolution
- Go to the Payables work center.
- Select the view Suppliers.
- Search and find XYZ (XYZ represents the Supplier ID).
- Select View All.
- Select the tab Financial Data.
- Select the tab Payment Data.
- Click on Add Row tab and maintain the respective payment method.
Now, Cash - Open Items report will show the Payee details in the offset Customer/Supplier field.
Keywords
Cash - Open Items report, Payment method is #, offset Customer/Supplier field , KBA , SRD-FIN-MOP , Payment Management , Problem
Product
SAP Business ByDesign all versions