Solved

Recognize invoice with Exchange difference

+9

How to conciliate a Supplier Payment in EUR, with a Supplier Invoice in GBP?

There is a Manual invoice in GBP, and the payment in advanced was perfomed in EUR. There is a small difference in Exchange rate.

Which are the alternative for the offset in this cases?

Best answer by Narmada

Hi,

You can use below alternative as Supplier offset window is support only if invoice and payment is in same currency.

Create mixed payment & select ‘NET AP/AR’ Cash Account (Currency would be accounting currency for this cash account)
Select the transaction type as ‘Enter Supplier Payment’ and select the relevant invoice. then add another line and select the advance payment.
Invoice & payment amount will shown in accounting currency based on currency rate defined in currency rate type.
You can add new line to post exchange difference (Remaining Amount in Mixed Payment window) by selecting transaction type as ‘Direct Cash Payment’
Then approve the transaction.

Hope this step will support to resolve your query.

Best Regards

Narmada

This topic has been closed for replies.

+13

Hi,

You can use below alternative as Supplier offset window is support only if invoice and payment is in same currency.

Create mixed payment & select ‘NET AP/AR’ Cash Account (Currency would be accounting currency for this cash account)
Select the transaction type as ‘Enter Supplier Payment’ and select the relevant invoice. then add another line and select the advance payment.
Invoice & payment amount will shown in accounting currency based on currency rate defined in currency rate type.
You can add new line to post exchange difference (Remaining Amount in Mixed Payment window) by selecting transaction type as ‘Direct Cash Payment’
Then approve the transaction.

Hope this step will support to resolve your query.

Best Regards

Narmada

+8

Could you check the following options please?

add a payment tolerance to the supplier and reapply the payment. The posting should take care of the currency gain/loss.
create manual payment: offset and include two open items you present here in this offset. Currency difference will be managed automatically. Since this is 2 different currencies you can try using the Mixed Payment window for this option.

Best Regards,

Ruwanjala

+9

Thanks,

https://www.linkedin.com/in/alberto-ifs-finance-consultant/

Sign up