Symptom
Invoice Price field in Monitoring Invoices report displays value different from Supplier Invoice Item Price.
Environment
SAP Business ByDesign
Reproducing the Issue
To check the item net/unit price in Supplier Invoice
- Go to the Supplier Invoicing work center.
- Go to Invoices and Credit Memos view.
- Search with Supplier Invoice ID ABC (ABC refers to Supplier Invoice ID).
- Select Edit button.
- Select Items tab.
- Item net/unit price is maintained as PQR (PQR refers to Item Price. E.g.: 36315).
To check the Invoice field in Monitoring Invoices report
- Go to Business Analytics work center.
- Go to Design Reports view.
- Search and open the Monitoring Invoices report.
- Under Selection tab, Maintain the selection as Supplier Invoice ABC.
Invoice Price displayed in the report differs from the Supplier Invoice’s item price.
Cause
The report’s “Invoice Price” is calculated per cost distribution line item with highly granular quantities, rounding effects cause values to differ from the invoice item’s unit price.
Invoice Price = Cost Distribution Net Amount / Cost Distribution Quantity.
For Example,
Supplier Invoice ABC contains 1 line item with two Cost Distribution line items 1.1 and 1.2
Item Price - 36,315 VND Item Quantity = 6186.771747211 units
Cost Distribution 1.1 Quantity = 0.000382899 units Net Amount = 0.000382899 x 36315 = 13.90 -> rounded to 14 VND
Cost Distribution 1.2 Quantity = 6,186.771364312 units Net Amount =6,186.771364312 x 36315 = 224,672,602.09 -> rounded to 224,672,602 VND
Invoice Price = Cost Distribution Net Amount / Cost Distribution Quantity. So,
Invoice Price of Cost Distribution 1.1 => 14 / 0.000382899 ≈ 36,563 VND
Invoice Price of Cost Distribution 1.2 => 224,672,602 / 6186.771364312 ≈ 36,315 VND
In the report, Invoice Price for the Supplier Invoice will be calculated as the average of both the cost distribution = 36,439 VND.
Note : currency rounding depends on the currency being used. For example, the Vietnamese Dong (VND) does not use decimal values, so no decimal rounding is applied.
Resolution
In Monitoring Invoice Report under views section, add the field “Cost Distribution Item ID” to the Rows and run the report. Now the “Invoice Price” will display per cost distribution line and align with the calculated values for each distribution.
This is the expected system behavior.
Keywords
Monitoring Invoices Report; Invoice Price Discrepancy; Supplier Invoicing; Cost Distribution; Unit Price Variance; Net Amount Rounding; , KBA , SRD-SRM-SI , Supplier Invoicing , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem
SAP Knowledge Base Article - Public