Error on Infolog when accessing open transactions

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.

• Status: Open
• Question Views: 3137
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Business Management

Answered By tibor.tokie 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)

       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

About tibor.tokie

Questions
1

Answers
157

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 03/01/2012
• Question Category: Business Management