SAP Exchange Rate Calculation Issue-Document currency to amount in LC

[Former Member]

Hi Experts,

I  am facing issue in exchange rate scenario .Amount in document currency is not matching up with amount in Local currency .There is amount discrepancy by fraction of decimals . This is probably because of rounding .

Scenario details are as below.

1. Sales Order created dated 27.07.2015.
2. Document currency is in USD for Sales Order. Company Code default currency is MYR.
3. Exchange rate as on 27.07.2015 is 1 USD= 3.60 MYR.
4. Delivery was created with reference to sales order on 27.7.2015, followed by invoice .
5. I noticed SAP is not calculating Tax correctly.
6. Amount in Local currency also does not match when evaluating conversion from USD to MYR in FB03 .
7. I  have attached the calculation in Excel .

Appriciate everone's time .

Regards,

Santosh

[Lakshmipathi]

KOMV-KKURS is the field for local currency at Pricing condition level which will be determined based on pricing date.  So check what is your pricing date.

G. Lakshmipathi

[Former Member]

Hello Lakshmipathi,

Thank you for your input but pricing rate , billing date and exchange rate all are in same date . Price difference is very small (0.01 Cent)  but still if a company raising so many invoices in a month will leads to big difference in reconciliation .

Regards

Santosh

[Lakshmipathi]

Obviously you will have.  From FI side, there is a provision to post such differences to a separate G/L Account and you can discuss with your FI team.

G. Lakshmipathi

[Lakshmipathi]

You can also have a look at the following notes:-

• Note 183250 - Price differences on sales order item/project stock
• Note 204212 - Posting price differences to sales document item

G. Lakshmipathi

[Former Member]

Hi Experts

Looking forward for some inputs .

Regards,