Skip to main content
Solved

Recognize invoice with Exchange difference

C
Hero (Partner)
Forum|alt.badge.img+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.

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

Hope this step will support to resolve your query.

 

Best Regards

Narmada

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

3 replies

N
Hero (Employee)
Forum|alt.badge.img+13
  • Narmada
  • Hero (Employee)
  • 150 replies
  • Answer
  • May 11, 2021

Hi,

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

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

Hope this step will support to resolve your query.

 

Best Regards

Narmada

Dhananga Jayatilake
MadushaDissanayake
S
8 people like this
  • Dhananga Jayatilake
    Dhananga Jayatilake
  • MadushaDissanayake
    MadushaDissanayake
  • S
    Sugandi Nadeeshika
  • R
    Ruwanjala Jayawardena
  • dhlelk
    dhlelk
  • N
    Narmada
  • S
    Shehan Wickramaratne
  • Asela Munasinghe
    Asela Munasinghe
R
Hero (Employee)
Forum|alt.badge.img+8

Hi @ConAlberM,

 

Could you check the following options please?

  1. add a payment tolerance to the supplier and reapply the payment.  The posting should take care of the currency gain/loss.
  2.  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

MadushaDissanayake
S
Shehan Almeida
6 people like this
  • MadushaDissanayake
    MadushaDissanayake
  • S
    Sugandi Nadeeshika
  • Shehan Almeida
    Shehan Almeida
  • C
    ConAlberM
  • S
    Shehan Wickramaratne
  • Rashmi Ruth
    Rashmi Ruth
C
Hero (Partner)
Forum|alt.badge.img+9
  • ConAlberM
  • Author
  • Hero (Partner)
  • 29 replies
  • May 11, 2021

Thanks,

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings