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.
We found out that the error is due to our customization.
Thank you for all your help.
I'm sorry for the disturbance :)
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.
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.
Hi Alireza,
Yes, we already click the Refresh button, and we even refresh the browser.
Thanks.
Hi marypeace,
I mean refresh button on right corner of the screen:
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.
Hi,
May one of the lines have different exchange rate?
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?
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156