Results 1 to 9 of 9

Thread: Partner12 - Age Analysis doesn't correspond to Statement

  1. #1
    Email problem
    Join Date
    May 2014
    Location
    South Africa
    Posts
    32
    Thanks
    2
    Thanked 1 Time in 1 Post

    Partner12 - Age Analysis doesn't correspond to Statement

    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 ?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	statement_APRIL2015.jpg 
Views:	530 
Size:	13.6 KB 
ID:	5564   Click image for larger version. 

Name:	ageAPRIL2015.jpg 
Views:	591 
Size:	26.0 KB 
ID:	5563  

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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?
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Email problem
    Join Date
    May 2014
    Location
    South Africa
    Posts
    32
    Thanks
    2
    Thanked 1 Time in 1 Post
    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.

  4. #4
    Email problem
    Join Date
    May 2014
    Location
    South Africa
    Posts
    32
    Thanks
    2
    Thanked 1 Time in 1 Post
    Forgot to mention, on the data integrity it reports this customer's open item is out of balance.

  5. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  6. #6
    New Member
    Join Date
    Aug 2014
    Location
    Nelspruit
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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)!

  7. #7
    Email problem
    Join Date
    May 2014
    Location
    South Africa
    Posts
    32
    Thanks
    2
    Thanked 1 Time in 1 Post
    Thanks Neville, I will keep you posted.

  8. #8
    New Member
    Join Date
    Mar 2017
    Location
    durban
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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

  9. #9
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

Similar Threads

  1. Matching payments on age analysis
    By gidalene@gmail.com in forum Accounting Forum
    Replies: 2
    Last Post: 17-Feb-15, 04:21 PM
  2. Replies: 0
    Last Post: 19-Jul-14, 12:27 PM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •