Results 1 to 6 of 6

Thread: Customer Age Analysis

  1. #1
    New Member
    Join Date
    Aug 2020
    Location
    Umhlanga
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Customer Age Analysis

    Hi all

    I just updated Pastel Express from V17 to V19
    My "view customer balances" report brings up all accounts with NIL balances, even though I have NOT ticked the "print nil balances". Most of the customer accounts haven't even had transactions in them for the last 3 years.

    Anyone know how I can get rid of the Nil balances on the report ( should be about 3 pages, but now is 30 Pages)

    Thanks so much

    Debbie

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Try running the report with Print Zero Items ticked, then re-run without it ticked. If might not be updating your default files when running the report.
    If you change your Customer Sequence from code to Description, does it now exclude the nils?
    Try running it by code from AAA001 to DDD001 as an example - do you still get nil balance accounts? If not, keep adding to the End range till it shows nil balances again, so you can isolate the customer causing the issue.
    Open the demo company and see if it does the same thing - if so, it might be a build / release issue, not a database issue.

  3. #3
    New Member
    Join Date
    Aug 2020
    Location
    Umhlanga
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Kevin. Thanks so much for your response. I have tried ALL of the above, and same thing !! Still shows all nil balances.
    I managed to get hold of Pastel support, and he had the same problem, so he has escalated it, and will let me know. Very frustrating I must admit

  4. #4
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    In Xpress, go into help - about - it will give you a build number, eg 19.1.4. I will test on that build and let you know if I get the same error.

  5. #5
    New Member
    Join Date
    Aug 2020
    Location
    Umhlanga
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Kevin

    My build number is 19.3.1

    I really appreciate your help, as I am yet to hear from Sage about it

    Many thanks

    Debbie

  6. #6
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    I have loaded the same version - it is doing the same thing my side. Data that printed correctly in V18 is now showing all zero balance accounts in V19.3.1 You are going to have to wait for Sage to fix the error and do a build update / patch. It isn't a database issue on your data.

Similar Threads

  1. [Question] Fixing cust. age analysis - Customer balance needs to be zero'd out
    By michellepace in forum Accounting Forum
    Replies: 4
    Last Post: 16-Sep-19, 08:01 AM
  2. [Question] Customer Age Analysis Report - Payment Terms Option - Pastel Partner V18
    By Nakwila in forum Accounting Forum
    Replies: 2
    Last Post: 20-Feb-19, 03:16 PM
  3. Variance betweern Customer Age Analysis and Control Account
    By nadiakarriem in forum Accounting Forum
    Replies: 1
    Last Post: 19-Nov-18, 02:24 PM
  4. Negative amounts on Customer age analysis
    By CuriousEL in forum Accounting Forum
    Replies: 6
    Last Post: 28-Sep-16, 07:44 AM
  5. [Question] Customer Age Analysis
    By car trader in forum Accounting Forum
    Replies: 3
    Last Post: 03-May-16, 07:49 AM

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
  •