Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Invoice journal voucher balance is not correct

(0) ShareShare
ReportReport
Posted on by 520

Hi,

I'm recording transactions in AP invoice journal under AP>>Invoices>>Invoice journal.

My accounting currency is USD and my reporting currency is in PHP.

In the first record the voucher balance is correct.

But when you add additional transaction, the voucher balance is not correct as shown in the screenshot highlighted in red. The debit and credit amount in the journal is the same which is 50,000.  But the accounting currency in USD show unbalanced entry.

pastedimage1683544230869v1.png

Voucher total for APV*2 will be corrected once you re-select the currency.

Why do we have to re-select the currency in order to have correct voucher total?

Pls help.

Thanks.

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Invoice journal voucher balance is not correct

    We found out that the error is due to our customization.

    Thank you for all your help.

    I'm sorry for the disturbance :)

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Invoice journal voucher balance is not correct

    Hi Billur,

    We are not overriding the exchange rate, so the system should use the default exchange rate both for debit and credit side.

    Thanks.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: Invoice journal voucher balance is not correct

    Hi marypeace,

    As you mentioned the workaround is to re-choose currency so the balance will updated.

    Do you have the same issue if you create the journal via Excel add-inn or Data management framework?

    You can add exchange rate field to the journal line to find it this different than accounting currency exchange rate values based on voucher date. If it does, please create a support case to Microsoft to get better assistance.

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Invoice journal voucher balance is not correct

    Hi Alireza,

    Yes, we already click the Refresh button, and we even refresh the browser.

    Thanks.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: Invoice journal voucher balance is not correct

    Hi marypeace,

    I mean refresh button on right corner of the screen:

    pastedimage1683553969243v1.png

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Invoice journal voucher balance is not correct

    Hi Alireza,

    Is there an Update button in AP invoice journal?

    There is a Validate button and when you click Validate, the system will throw an error that transaction is not balanced.

    Thanks.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,615 Most Valuable Professional on at
    RE: Invoice journal voucher balance is not correct

    Hi,

    May one of the lines have different exchange rate?

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: Invoice journal voucher balance is not correct

    Hi marypeace,

    Do you get the same result when you have debit and credit in one journal line?

    How about when you click on "Update" button? Does the Balance field get updated?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans