I recently created a custom FI report similar to the Profit and Loss statement. When I was validating the results against standard SAP reports, I noticed several differences in amounts. The discrepencies were traced to FI documents that involved foreign currencies. I created another quick report to see how often the issue occurs. Because it involves millions of dollars and hundreds of line items, I must be missing something. I am trying to get a better understanding of the currency conversion process. It looks like the values in the database are incorrect.
Table BSEG stores the amounts in document currency and local company code currency. BKPF stores the exchange rate on the posting date. You can use transaction FB03 to display the line items, check the header data with the exchange rate, and check document and local currency values. When the exchange rate is applied to the document currency, it does NOT equal the local document currency.
Example-
Document currency EUR
Local currency USD
Exchange rate from BKPF 1.29045
Line item shows 50.00 EUR and 33.96 USD.
It should be 64.52 USD.
Some of the examples look like the first line is converted correctly, and then the system forces the document to balance by having the local currency equal to the difference. Because of the erroneous values, the actual GL account balances are wrong.
I took some screen snapshots of actual examples in FB03. You can view an MS Word document at www.gmavt.net/~nesvt/FI_CURR_ISSUE.DOC
Thank you in advance!
Norm
Message was edited by: Norman Salter
corrected link to document