Pastel posts two sets of transactions for each entry - one set updates the Ledger Transactions data table (which is where the detailed ledger reports and Skynamo get their information) and the other set updates the Open Item data table (which is where the statements get their information).
The age analysis also gets its information from the Open Item table, but if the balance on the Open Item table differs from the balance on the Ledger Transactions table, then the system creates an entry on the age analysis to force it to agree with the detailed ledger balance.
It seems that the Open Item table has become corrupt and has missing transactions, which is why you should see that your detailed ledger agrees with the age analysis but not with the statement.
Is it possible to perform a Data Integrity report to identify if there has been any data corruption?
Please sign in to leave a comment.