Results 1 to 3 of 3

Thread: Customer Age Analysis Report - Payment Terms Option - Pastel Partner V18

  1. #1
    Full Member
    Join Date
    Jul 2016
    Location
    namibia
    Posts
    54
    Thanks
    0
    Thanked 1 Time in 1 Post

    Customer Age Analysis Report - Payment Terms Option - Pastel Partner V18

    Good Day Team,

    Herewith seeking your wisdom - Pastel Partner V18. I have inherited customer balances from a company. I do not know where I've gone wrong with the setup of the new company. I have successfully imported the customer balances of 2018 into the new company 2019 however when I pull the customer age analysis the parameter/field to select ''Payment Terms" in the new company is greyed-out and is set on default reading Ėvery customer sorted by payment terms" instead of allowing me to select Every Customer Aged Monthly. So there is now a difference on the total customer aging 2018 vs aging beginning 2019 in the new company.


    Another oversight/ error Ive also made is that I did not consider the aging and rather took on the total outstanding balances at year-end 2018 into 2019 and If I pull the age-analysis in 2019, it shows ageing on 30 days rather than perhaps +120 days!

    Pastel gurus, please assist!

    Thank you.

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,673
    Thanks
    44
    Thanked 442 Times in 388 Posts
    Quote Originally Posted by Nakwila View Post
    I have successfully imported the customer balances of 2018 into the new company 2019 however when I pull the customer age analysis the parameter/field to select ''Payment Terms" in the new company is greyed-out and is set on default reading Ėvery customer sorted by payment terms" instead of allowing me to select Every Customer Aged Monthly.
    The option "Every customer sorted by payment terms" is only available if you have one or more customer accounts set up as Day Based customers, as opposed to Month Based customers.

    Quote Originally Posted by Nakwila View Post
    Another oversight/ error Ive also made is that I did not consider the aging and rather took on the total outstanding balances at year-end 2018 into 2019 and If I pull the age-analysis in 2019, it shows ageing on 30 days rather than perhaps +120 days!
    If you want to take on the correct ageing balances, you need to capture each aged amount as a separate line item in the journal, with the relevant period number and a unique reference for each aged line item.
    Neville Bailey - Sage Pastel Accounting Consultant
    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
    Full Member
    Join Date
    Jul 2016
    Location
    namibia
    Posts
    54
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thank you Neville for the insight...appreciated! Ive just run the customer detailed ledgers and am happy to find the total balancing to the customer control account in the TB. When I request the age-analysis the option to select payment term remain greyed. Where in settings can I change or was it suppose to be done at project creation? I still believe the aging is because of the payment term selection. in the old project 2018 the option to select the project term is available!

Similar Threads

  1. Pastel Partner V14 Entry Not in Vat Report
    By Sherill in forum Accounting Forum
    Replies: 1
    Last Post: 09-Jun-17, 10:23 AM
  2. [Question] Pastel Partner 11 Report issues
    By Carolinedj in forum Accounting Forum
    Replies: 10
    Last Post: 07-Nov-16, 09:44 AM
  3. [Question] General Journals - why don't I have the option to credit an customer?
    By Proppie in forum Accounting Forum
    Replies: 2
    Last Post: 23-Jun-16, 09:43 AM
  4. Replies: 1
    Last Post: 20-Jul-15, 01:56 PM
  5. [Question] Bill of Material report Pastel Partner 11
    By DaniePosthumus in forum Accounting Forum
    Replies: 3
    Last Post: 20-Jun-14, 01:53 PM

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
  •