Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Difference of ' Balance ' and 'Amount in transaction currency ' in vendor transactions

Posted on by 10

Hi all,

On checking the vendor transactions of a vendor (using two currencies), we found a difference in the amounts showing in AMOUNT IN TRANSACTION CURRENCY and BALANCE. 

Exported version of the vendor transaction is as follows. 

pastedimage1677143207496v2.png

What may be the reason for the difference? 

Thanks in advance

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,835 Super User on at
    RE: Difference of ' Balance ' and 'Amount in transaction currency ' in vendor transactions

    Hi Gopika,

    You showed a screenshot of an Excel sheet. Are all transactions on this sheet? Have you chekced the transactions in the application itself?

  • Gopika Profile Picture
    Gopika 10 on at
    RE: Difference of ' Balance ' and 'Amount in transaction currency ' in vendor transactions

    Hi Andre,

    Thanks for the response, but my doubt is regarding the difference in the total of AMOUNT IN TRANSACTION CURRENCY and BALANCE.

    The total of Amount in transaction currency is -326710.17 and the total of Balance is -30614.09. There is a difference of -20565.08. So I'm having a doubt like whether this is correct or wrong.

    Thanks & Regards,

    Gopika

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,835 Super User on at
    RE: Difference of ' Balance ' and 'Amount in transaction currency ' in vendor transactions

    Hi Gopika,

    The balance indicates the open amount for the transaction. If the balance is zero, the invoice is settled with another payment transaction.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/blogs/?blogid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.