This article explains about the issues of missing data in Basware accrual reports and solution/workaround to these issues.
We identified two scenarios where data is missing in Accrual reports:
Scenario 1: Coding rows exist.
Still data is missing when there is a coding difference at the time of accrual report generation.
This behaviour is as per design.
Solution: Enable the checkbox “Apply coding for invoices with coding difference” when generating the accrual report.
Handling of partly coded invoices
For example:
1. Invoice with two coding rows but have coding difference. By default in Accrual report: Partly coded invoices are shown as a single line without coding details.
Invoice with two coding rows but have coding difference:
Default Accrual report:
Generated Report:
Solution: Enable the checkbox “Apply coding for invoices with coding difference” when generating the accrual report.
Generated report after solution:
Scenario 2: No coding rows are present
As per bug fix in 26.3.1 release: [AP-3014] In accrual reports coding fields show header data when invoice has no coding row - Jira
Problem: When the user requested an accrual report and an invoice contained no coding rows, the coding fields incorrectly displayed values taken from the invoice header.
After bug fix impact to the customer: The coding fields remain empty when an invoice has no coding rows. However, if invoice fields are configured for the coding rows, those values are populated in the export (for example fields starting with "InvoiceHeader." or "Invoice.").
But some customer expects data to be populated in Accrual report from the invoice header.
In the release notes, the reference for this issue is the Support System Id BWPB0048786.
Workaround:
Navigate to Configuration Tool → Entities and Screens → All Screens → Invoice List PRO → Search → Coding Rows, and map the required field (e.g., Invoice.GrossSum) so that the value is retrieved from the invoice header when coding rows are absent.
Configuration: Both GrossSum and Invoice.GrossSum
GrossSum field will have value from the coding rows, and Invoice.GrossSum field will have value from invoice header in Accrual report.
Similarly, if additional fields need to be populated in accrual reports from the invoice header when coding rows are absent, they can be configured in the same way as described above.
Example: Invoice with no coding rows
Accrual report: