We have two invoices coming from a supplier, that we have made a single payment for. The two invoices are in INR and payment is in GBP. We trying to match those but it’s failing, and the system doesn’t allow you to match a single payment to multiple invoices in currency as it’s not able to deal with the currency exchange issue. How should I link the payments together for that?
Hello @Thomas_Radosh
The easiest way to deal with this is with a merchant account (dummy bank account in the foreign currency).
- Tag the payment as a transfer to the new account
- Pay off the two invoices (Open invoice and log payment) using this new account
The balance will net off to zero
is there a plan to add currency matching when applying to multiple payments? it’s working fine on 1-to-1 relation but looks like 1-to-many could use that as well
Hello @Thomas_Radosh
Not at present as we don’t tend to get many queries on it.
Please feel free to raise a feature request in the forum, that way other users can vote on it and we can monitor the interest.
If you know the total GBP and INR amounts then you should be able to go to the supplier’s control panel and add a new “prepayment” for the INR total, paid from the GBP account (this will create a new GBP transaction on the bank account so you’d then have to delete any untagged duplicate that came from a bank feed).
This will create a credit balance on that supplier’s account in INR, from which you should then be able to log payment → apply from credit on each of the unpaid purchases in turn.
This topic was automatically closed after 7 days. New replies are no longer allowed.