[Question] Partner12 - Age Analysis doesn't correspond to Statement

[kevvie]

Hi,

Hope someone can shed some light - for many of my customers, the age analysis and statements doesn't correspond, I have attached 2 screen shots to compare. The totals on the statement amounts are correct, however the age analysis went crazy. How do I correct the totals on the age analysis ?

[Neville Bailey]

If you run the customer detailed ledger reports, do they agree with the statements or the age analysis reports?

Have you run the Data Integrity report?

[kevvie]

Hi Neville,
The detailed ledger report's balances doesn't correspond to the statement, opening and closing balances. It seems that those balances reflects onto the age analysis.

[kevvie]

Forgot to mention, on the data integrity it reports this customer's open item is out of balance.

[Neville Bailey]

If you are using Open Item processing, Pastel posts two sets of transactions for each entry - one set updates the Ledger Transactions data table (which is where the detailed ledger reports 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.

I have the necessary database editing software to recreate the missing Open Item transactions.

If you would like me to assist you, please could you go to my website and fill in your details on my online form, so that I can open an account for you. I can then either fix the corruption remotely via TeamViewer, or you can send me a backup of your company database and I can fix it on my system.

[Arumanzi]

Hi there.

I've noticed a few of our Creditors (plus our Pastel) - that seem to have the same problem this year with our open items after doing a year-end! So the best way you say is to do a data integrity check? (Mine is stuck on 30% for the last 2 hours already)!

[kevvie]

Thanks Neville, I will keep you posted.

[carol nel]

creditors age analysis doesn't correspond to statement balances- how to fix and what causes this

Hi all,

Trying to fix a pastel supplier age analysis. the aging that appears on the suppliers statement does not correspond with the age analysis:

AS at the 28022017 closing balance is R12654023.15


The age analysis for March says that the 30 days amount is R12642689.77. Our cash book lady posted a payment on the 14.03.2017. This has reduced the 30day amount instead of current. Our suppliers in pastel are set up as balance b/f . We do not match payments to creditors invoices. Therefore this payment should have reduced the current and not the 30 days. How to fix please.

Kind regards


Carol

[Neville Bailey]

Go to Setup...Company Parameters and open the Formats tab.

In the "Age Balance Forward Journal Credits" section, make sure the option "In the Period They Were Processed In" is selected.