web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Shipment/Invoice f...
Microsoft Dynamics GP (Archived)

Shipment/Invoice fully paid automatically

(0) ShareShare
ReportReport
Posted on by Community Member

There’s 1 Shipment/Invoice in foreign currency and a payment is in functional currency. Payment is part payment.
When i apply the part payment to this foreign currency Shipment/Invoice, a round off JV is passed, debiting payables account and crediting Foreign exchange Gain(loss) account. There by the Shipment/Invoice is becomming fully paid. Can you please gv me a suggestion to avoid automatically passing this JV. I understand that if there is any exchange rate difference this JV will be created automatically with exchange difference amount. But, as the payment is partly the whole remaining invoice amount is passed as JV

Thanks in Advance
Akbar

*This post is locked for comments

I have the same question (0)
  • Dencio Profile Picture
    Dencio 2,172 on at

    Hi Akbar,

    When you partially applied a payment recorded/posted in functional currency to a multicurrerncy transactions, the entire forex gain/loss will be recognized, when almost 90% for the invoice functional amount has been paid (our peers may provide the exact rule).  I understand that this may not be the outcome you are expecting but the work around on this is to void the original payment and record the equivalent amount in the originating currency of the invoice, in this manner when you post and applied this payment, partial forex gain/loss entry will be recognized proportionate to the payment.

    Hope this helps,

    Cheers,

    Dencio

  • Community Member Profile Picture
    Community Member on at

    Hi Dencio,

    Thanks a lot.

    Today i created some test invoices in foreign currency and create functional currency part payments and applied, its working fine.

    Then i tracked for previous invoices so there are some invoice on which i can successfully apply the part payment and rest of the amount will go in due (current trx amount).  When i was going around web i found a blog answer that if there is any exchange difference of invoice and on apply date, then it will happen but, i checked the exchange rate both are same.

    So, as today i have created some test invoices/payments which was working fine. But some previous invoices/payments for partpayment its going forex gain/loss entry.

    Thanks & Regards

    Akbar

     

     

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at

    Akbar,

             If invioce and payment both are in foreign currency with differnet exchange rates(invoice exchange rate 1.5 and payment exchange rate is 1.3),  then forex gain/loss will be occur.

    If I am not wrong, any one of the transaction is functional, Rounding error may be occur but gain/loss will not occur.

    Regards

    Jeganeedhi

     

  • Community Member Profile Picture
    Community Member on at

    Hi Jeganeedhi,

    Yes u r right, the distribution type is ROUND. Lets c 1 example :

    Functional Currency : AED

    Foreign Currency : USD

    1 USD = 3.675

    Invoice Amount : USD 10,000 = (AED 36,750)

    Payment made : AED 14,700 = (USD 4,000)

    Invoice created in USD and payment creaded in AED

    When i apply, the system will automatically create a JV of amount AED 22,050 (one of the distribution type is PAY and another 1 is ROUND) and invoice go and sit in history with zero current transaction amount.

    Exchange rate at the time of invoice and payment is same.  

    So, this JV should not be raised automatically.  For some invoices its working fine means it will not create JV though invoice is in USD and payment is in AED and payment is part payment.

    Thanks & Regards

    Akbar 

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans