Skip to main content
Answer

External voucher upload - receive error ORA-20110: ExtCheck.VOU_NOT_BAL: Voucher is not balanced in accounting currency

  • February 18, 2025
  • 2 replies
  • 230 views

Forum|alt.badge.img+3

Hi,

 

I am trying a external voucher upload and i receive below error when i try to upload 

ORA-20110: ExtCheck.VOU_NOT_BAL: Voucher 12/02/2025 is not balanced in accounting currency

 

My template and file as below

 

 

Highly appreciate your response.

Thank you.

Best answer by Furkan Zengin

Hello ​@Imalka 

A regular voucher includes at least 1 debit and 1 credit transaction. In your file, there is only debit row. If you want the system not to validate the balance and post difference automatically then you need to change Voucher Differences setting on External Voucher Basic Data window.

 

Here is the help description for the field

 

Voucher Differences
This field indicates whether voucher differences are allowed or not.

If Allowed is selected, external transactions need not balance when a voucher is generated to the hold table. The Create Voucher function creates a posting of the difference in accordance with the posting type AP9, Difference Account External Vouchers in posting control. 

If Not Allowed is selected, external transactions must balance, and the transactions that do not balance are marked with an error code.
 

 

 

2 replies

Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • Answer
  • February 18, 2025

Hello ​@Imalka 

A regular voucher includes at least 1 debit and 1 credit transaction. In your file, there is only debit row. If you want the system not to validate the balance and post difference automatically then you need to change Voucher Differences setting on External Voucher Basic Data window.

 

Here is the help description for the field

 

Voucher Differences
This field indicates whether voucher differences are allowed or not.

If Allowed is selected, external transactions need not balance when a voucher is generated to the hold table. The Create Voucher function creates a posting of the difference in accordance with the posting type AP9, Difference Account External Vouchers in posting control. 

If Not Allowed is selected, external transactions must balance, and the transactions that do not balance are marked with an error code.
 

 

 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • February 20, 2025

Hi ​@Furkan Zengin ,

Thank you for the response. I will test with the full journal so it will balance.

/Imalka