I have base currency of Pound Sterling.
Have done two payments against dollar customer Purchase Order.
Now when trying to post the Purchase Invoice against the Purchase Order, and then get advance payments two payments that match against the purchase invoice amount, I get the very similar error message:
Debit and Credit not equal for Payment Entry #ACC-PAY-2023-00017. Difference is 35.5635.
But I still get the error message Debit and Credit not equal for Payment Entry #ACC-PAY-2023-00017. Difference is -###.
when try to Submit the purchase invoice.
I have two dollar payments, and then on the Purchase Invoice, selected the Advance Payments. The Advance Payments total match the total advance amount in USD.
But the above error message appears when trying to post. I’m convinced that is because the base currency is in GBP and there is difference in the exchange rate between the payment entries & invoice entry
→ GBP amounts are not the same, but the dollar amounts are the same.
→ The difference should be posted to the exchange rate variance account.