You’re offline. This is a read only version of the page.
Hi All,
Greetings,
I am new to AX .I have been resolving a bug while settling open transactions for customers.
(Error:Cannot create a record in Balance (CustVendTmpOpenTransBalances). Amount: 0,00.
The record already exists.)
After a lot of search online , I came to know that deleting orphaned records in SpecTrans Table is the solution for most of the cases so as in my case.But I have few queries regarding this. Here are they:
1) The data source for the settle open transactions form is the CustTransOpen Table and though SpecTransTable is being orphaned it has nothing to do with this form (correct me if i am wrong), Then why is this error related to SpecTransTable.
2) Is it Safe to delete these records in SpecTrans Table.
Please kindly give me your thoughts
*This post is locked for comments
I have the same question (0)
The table SpecTrans is a table that's shows all transaction that are marked for settlement. It is very important to you check if there is no marking made via for example a bank or payment journal. If you delete this record you delete the marking.
It is safe to delete if you keep above in your mind.
If this answers your question please verify answer.
Share
Report
All responses (
Answers (
556
