Finance | Project Operations, Human Resources, ...

Invoice journal voucher balance is not correct

(0) Share

Report

Posted on by marypeace

524

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.

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.

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Alireza Eshaghzadeh 14,853 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,825 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

May one of the lines have different exchange rate?

Was this reply helpful? Yes No
marypeace 524 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,853 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi marypeace,

I mean refresh button on right corner of the screen:

Was this reply helpful? Yes No
marypeace 524 on at

Like (0)

Report
Copy link

Link copied!

Hi Alireza,

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

Thanks.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,853 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
marypeace 524 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
marypeace 524 on at

Like (1)

Report
Copy link

Link copied!

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

Thank you for all your help.

I'm sorry for the disturbance :)

Was this reply helpful? Yes No