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)

Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

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 19,698 Most Valuable Professional on at

Like (0)

Report

Hi,

May one of the lines have different exchange rate?

Was this reply helpful? Yes No
marypeace 524 on at

Like (0)

Report

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,672 Super User 2025 Season 2 on at

Like (0)

Report

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

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,672 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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