Symptom
You find the value of <Net Amount in Company Currency> on report Monitoring Invoices is different from the value of <Credit Amount Company Currency> on report Accounts Payable - Line Items are different. You would like to why the differences and how these two values are determined.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Supplier Invoicing Work Center.
- Go to Report - List View.
- Open report Monitoring Invoices.
- Enable the key figure Net Amount in Company Currency, and enter invoice XYZ (XYZ represents the supplier invoice ID).
- Display Currency - Conversion Date as Today.
- You find the value here is A (A represents the value of Net Amount in Company Currency).
- Go to Payables Work Center.
- Go to Report - List View.
- Open report Accounts Payable - Line Items.
- Enter Source Document ID XYZ, and Display Currency - Conversion Date as Today.
- Check the value of Credit Amount Company Currency, it is B (B represents the value of Credit Amount Company Currency).
You would like to know why A is different from B.
Cause
You have manually determianed the expected exchange rate on invoice XYZ.
You can open the invoice and navigate to Exchange Rates Sub tab under General tab, to verify the rate you manually determianed.
B is calcualted from this exchange rate you manually determianed.
Regarding how A is calculated, Please refer to KBA 3331031 for more details.
Resolution
This is the current system design of report displaying.
See Also
KBA 3331031 - How the value of field Net Amount in Company Currency on report Monitoring Invoices is generated
Keywords
Monitoring Invoices, Accounts Payable - Line Items, Net Amount in Company Currency, Credit Amount Company Currency, Exchange Rate , KBA , SRD-SRM-SI , Supplier Invoicing , How To