Share
Report
42Hi Team,
I have an issue with currency conversion in Business Central.
My sales order is in EUR, and our LCY is DKK.
The exchange rate is correct:
1 EUR ≈ 7.47 DKK
The sales order amount is 52,000 EUR, and the posted sales invoice also shows 52,000 EUR correctly.
However, in Customer Ledger Entries, I see:
Original Amount: 52,000 EUR
Amount (LCY): 7,800,000 DKK !!!
Amount (LCY): 7,800,000 DKK !!!
It should be approximately:
388,565.32 DKK
After investigation, I found:
- The field Currency Factor on the posted sales invoice is 0.0066 though it should normally be around 0.1338
- Other EUR orders have the correct Currency Factor on the same date
- The EUR exchange rate setup on the posting date is correct
- The Currency Factor field is not visible to users, so it was likely not changed manually
- Other EUR orders have the correct Currency Factor on the same date
- The EUR exchange rate setup on the posting date is correct
- The Currency Factor field is not visible to users, so it was likely not changed manually
Can someone please help me understand why and how the Currency Factor could become incorrect on one sales order/invoice?
Any input would be appreciated.
Thanks,
Zeb
Categories:
I have the same question (0)
All responses (
Answers (
