Error on Infolog when accessing open transactions

This is an Infolog (http://www.infologsolutions.com/) problem. I am facing this error message when trying to access open transactions:

Error:

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.

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)

tmpBalances.insert();

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.

Techyv is one of the leading solution providers covering different aspects of Computers and Information Technology. We have a hardworking team of professionals in different areas that can provide you with guaranteed solutions to a blend of your problems. We have a dedicated and devoted team of professional writers with multi-dimensional experience of several years. As a result, we produce quality content on a variety of subjects.