Error on Infolog when accessing open transactions

Asked By 10 points N/A Posted on -

Hello all.

This is an Infolog ( problem.  I am facing this error message when trying to access open transactions:


Infolog(1) One or more critical STOP errors have occurred.Use the error messages below to guide you or call your administrator Message(01:21:11 pm) Cannot create a record in Balance(CustVendTmpOpenTransBalances).Currency:,0,00.The record alrea….
Hope any of you can help me. Thanks.

Answered By 25 points N/A #95210

Error on Infolog when accessing open transactions


Dear Whopperman

According to the error message you received "CustVendTmpOpenTransBalances, the error already exist" in infolog, I think that it's unlikely to have duplicate records in that table " CustVendTmpOpenTransBalances". A workaround for this problem is to modify the add method in the class " CustVendOpenTransBalancesManager " and add this if statement around the whole code block:

if (tmpBalances.TransOpenRecId)


It seems that the system was trying to add a record to the table with TransOpenId = 0 which break the unique index rule on the table and so you got the "already exist" error message.

Hope this may help you.

Best of luck

Login/Register to Answer

Related Questions