SAP Knowledge Base Article - Public

3331203 - The value of amount on report Monitoring Invoices is different from the one on report Accounts Payable - Line Items

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

  1. Go to Supplier Invoicing Work Center.
  2. Go to Report - List View.
  3. Open report Monitoring Invoices.
  4. Enable the key figure Net Amount in Company Currency, and enter invoice XYZ (XYZ represents the supplier invoice ID). 
  5. Display Currency - Conversion Date as Today.
  6. You find the value here is A (A represents the value of Net Amount in Company Currency).
  1. Go to Payables Work Center.
  2. Go to Report - List View.
  3. Open report Accounts Payable - Line Items.
  4. Enter Source Document ID XYZ, and Display Currency - Conversion Date as Today.
  5. 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

Product

SAP Business ByDesign all versions