Voucher batch posting error - CA ledger type out of balance

James Monroe

Active Member
Greetings,

We are on E1 9.0, tools 9.1.4.7.

Today we have a voucher that will not post and is giving an error of 'CA ledger type for 3/1/2018, document 6182174 is out of balance by -9398.90'. This appears to be trying to do something with foreign currency since CA is the foreign currency ledger type.

However, we do not use foreign currency currently. The voucher is set to USD with our base currency is also USD. The voucher has 1 pay item and 219 Gl lines but all are for companies where USD is the currency.

So nothing in this transaction should be doing anything with a foreign currency. Multi currency is turned on, but only used in the distant past, and no current companies are anything other than USD. The vendor has an address book currency of USD and everything we can see says USD for this transaction.

Any ideas where to look would be appreciated.
 

ajit_nadgouda

Active Member
Greetings,

We are on E1 9.0, tools 9.1.4.7.

Today we have a voucher that will not post and is giving an error of 'CA ledger type for 3/1/2018, document 6182174 is out of balance by -9398.90'. This appears to be trying to do something with foreign currency since CA is the foreign currency ledger type.

However, we do not use foreign currency currently. The voucher is set to USD with our base currency is also USD. The voucher has 1 pay item and 219 Gl lines but all are for companies where USD is the currency.

So nothing in this transaction should be doing anything with a foreign currency. Multi currency is turned on, but only used in the distant past, and no current companies are anything other than USD. The vendor has an address book currency of USD and everything we can see says USD for this transaction.

Any ideas where to look would be appreciated.
Please check the GL Distribution. There could be a BU of a company whose base currency might be foreign (other than USD).
 

gina13tiger

Active Member
Is this error message coming when you try to post the batch or when you try to exit and save the voucher? If it is during the posting process, are you also generating the R09801E report? This would show you the details of the batch and allow you the ability to identify the components of the voucher that are causing this out of balance.
 

James Monroe

Active Member
Thank Gina,

This occurs when you try to post the voucher batch. The batch status goes to 'E' and the only thing on the R09801 report is the note that there is an out of balance in the CA ledger as I noted above. Is there an option to generate a R09801E report when you post? I haven't seen that.

I tried running the R09801E report independently for this batch, and it just shows the debit side from the GL distribution but nothing else.
 

James Monroe

Active Member
Gina, thanks. We are not getting a R09801E report when we try to post, even if the post fails. Is there some option to turn that on? I ran it by itself, but then its just looking at the detail that exists before posting, so its not really showing anything.
 

James Monroe

Active Member
This issue is now resolved. We had the user delete the voucher and reenter it, this time it posted without issue. It seems that on the original entry, something the user did put it in foreign currently mode. The value of the RPDMCD was set to '1' for that original voucher, even though we could find no other currency for any company involved other than USD.

Seems to be a one off occurrence. We will look into further if it occurs again.
 

gina13tiger

Active Member
The R09801E just natively auto generates in the situation of an out of balance condition on a batch posting. What we have found locally is that if the user running the post on the R09801 does not have security as well for R09801E, then the error report will not generate for out of balance batches as a result of the security. Once we added the additional security for this called program, the report generated.

Glad to hear you were able to figure things out.
 
Top