Results 1 to 6 of 6

Thread: Age Analysis and supplier detail ledger not adding up

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    New Member
    Join Date
    Feb 2016
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Age Analysis and supplier detail ledger not adding up

    Hi Guys,
    I am new to pastel (partner v14) and have an issue with my age analysis for suppliers, it still shows some 60 days + items but when I go into match open item it shows zero.
    Also on my detail ledger it shows zero, any advise on what I am doing wrong?

    The whole point was for me to pull a report on which suppliers needs to be paid on a weekly basis.

  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
    It sounds as though there might be some data corruption in the Open Item table.

    If you go to File...Data Integrity and run the report without changing any of the default options, does it report any errors?
    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
    New Member
    Join Date
    Feb 2016
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wink

    Quote Originally Posted by Neville Bailey View Post
    It sounds as though there might be some data corruption in the Open Item table.

    If you go to File...Data Integrity and run the report without changing any of the default options, does it report any errors?
    I did try that but there is no errors...
    It is not a big issue however looks terrible when I pull an age analysis and i shows items I know for a fact is paid.

  4. #4
    Full Member
    Join Date
    Oct 2014
    Location
    Cape Town, Muizenberg
    Posts
    28
    Thanks
    2
    Thanked 1 Time in 1 Post
    Make sure you running the Age analysis in the correct period. For instance if you pay your creditors in February but run a January Ageing the suppliers you paid will still reflect as outstanding.

  5. #5
    Full Member Jane123's Avatar
    Join Date
    Aug 2015
    Location
    port Elizabeth
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts
    I get this often....no errors show up when you run a data integrity.... grrrr! You will need to contact Pastel to run a data fix as it is a corruption issue. Good luck!

  6. #6
    New Member
    Join Date
    Feb 2016
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Guys, I will give Pastel a call!

Similar Threads

  1. Age Analysis vs Detailed Ledger
    By Valkiri in forum Accounting Forum
    Replies: 2
    Last Post: 26-Nov-15, 01:44 PM
  2. How does Pastel link a Supplier Return to a Supplier Invoice?
    By Leigh Peiser in forum Accounting Forum
    Replies: 0
    Last Post: 27-May-14, 02:03 PM
  3. [Question] Importing Sales Order detail into Pastel Partner
    By J7J in forum Accounting Forum
    Replies: 5
    Last Post: 19-Feb-14, 11:49 AM
  4. Debtors Ledger and General Ledger
    By Simimano in forum Accounting Forum
    Replies: 1
    Last Post: 15-Apr-13, 03:24 PM
  5. [Question] Adding Lessor as a supplier
    By jackie.white in forum Accounting Forum
    Replies: 2
    Last Post: 22-Jun-12, 01: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
  •