Asked By
whopperman
10 points
N/A
Posted on - 02/28/2012
Hello all.
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.
Hope this may help you.
Best of luck
