Share
Report
5Hi all,
I have some C# code that takes invoice data (headers, items and distributions) from a database, format the data into eConnect SOP transaction XML docs (SOP invoice header, line items and distributions), and send them over to eConnect. I found an issue when I started using foreign currency.
In some of the invoices created, the account distribution debits and credits are off by a cent in the functional currency (but those in the originating currency always add up). Here's an example:
CAD (Originating): Credits 145.45 + 144 + 153.68 + 146.4 + 145.48 (735.01 total) = 735.01 Debit
USD (Functional): Credits 138.89 + 137.5 + 146.75 + 139.8 + 138.92 (701.86 total) = 701.85 Debit
Exchange rate = 1.0472458
If I create this invoice in GP manually or if I open this invoice in Edit mode, GP will automatically add an "Exchange Rate (Gains)/Losses" distribution item for me, but I don't open the invoice in GP, that penny isn't accounted for.
Is there anyway to tell eConnect to create that exchange rate gain/loss item for me?
Thanks.
Felix.
*This post is locked for comments
All responses (
Answers (
