No of visitors who read this post:
407
Category:
Business Management
Type:
Question
Author:
Whopperman
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.
- Login or Signup Now to post comments
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