SAP Knowledge Base Article - Public

1757313 - In the Invoice Volume Report the Net Value of the Invoice for a Specific Item Does not Match the Amount Posted in the GL Account

Symptom

In the Invoice Volume Report the net value of the invoice for a specific item does not match the amount posted in the GL account.

Reproducing the Issue

  1. Go to Customer Invoicing work center.
  2. Go to Reports view -> List subview.
  3. Open the report Invoice Volume.
  4. Select the required parameters and execute the report.
  5. In the report the Net Value of credit memo ABC is XXX.YY (ABC represents the ID of the credit memo and XXX.YY represents the net value of the credit memo). 
  6. Now go to the General Ledger work center.
  7. Go to Reports view -> List subview.
  8. Open the report G/L Accounts - Line Items.
  9. Select the required parameters and execute the report.
  10. The Credit Amount Company Currency i.e. the posted amount of credit memo ABC is XXX.YX (ABC represents the ID of the credit memo and XXX.YX represents the posted value of the credit memo). 

Cause

The exchange rate was changed from XX to YY after posting of the credit memo. The reports uses the rate YY because this is currently maintained in the system.

Follow the steps below to check the exchange rate.

  1. Go to the General Ledger work center.
  2. Edit exchange rates.
  3. Select View Exchange Rate History.

Secondly, the report Invoice volume derives the company currency for display from the username. The company to which he/she is assigned, the
report shows that particular currency. Hence the net value can differ depending upon currency & the exchange rate for the currency displayed in the report.

Resolution

This is the expected behavior of the SAP Business ByDesign.

Keywords

KBA , AP-CI-CI-ANA , Analytics , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0