Results 1 to 2 of 2

Thread: Pastel Partner 11 Multiple Account Setup

  1. #1
    Junior Member
    Join Date
    Jul 2012
    Location
    Durban
    Posts
    13
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Pastel Partner 11 Multiple Account Setup

    Hi

    Query 1
    I have 4 Main Customer accounts, each holding separate accounts on pastel version 11. Each account hold various stores with different delivery addresses. Now I need to consolidate these accounts into one main account.
    My problem
    1. Each account has 100 or more different delivery addresses, how can I consolidate without having to add each delivery address manually to save time?

    Query 2
    2. The customer account is set up as an open item so I can match payment to invoices, setting it as balance brought forward doesn’t allow this. I have several invoices for a month for the account. When they make payment its less rebate & advertising and settlement discount. After matching the payment amount and discount amount to the invoices im left with at least 5 unmatched invoices which off course add up to the rebate & advertising amount.
    My problem
    The rebate & advertising I make a credit note but this can only be matched to 1 invoice leaving the other 4 invoices unmatched. On my age analysis the unmatched amounts are still being reflected as outstanding as 30days/60days/90days. How do I get a clean accurate age analysis. I did have the account on bal brought forward and then to age analysis was showing the same.

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Quote Originally Posted by farhad View Post
    Query 1
    I have 4 Main Customer accounts, each holding separate accounts on pastel version 11. Each account hold various stores with different delivery addresses. Now I need to consolidate these accounts into one main account.
    My problem
    1. Each account has 100 or more different delivery addresses, how can I consolidate without having to add each delivery address manually to save time?
    This is quite a challenge! I could possibly use my DDF software to edit the additional delivery address data records to link to the new consolidated customer account, but I am concerned that the audit trail integrity of historical transactions will be compromised. If you are happy to send me a backup of your database, I can do a few trials and then advise you one way or another.

    Quote Originally Posted by farhad View Post
    Query 2
    2. The customer account is set up as an open item so I can match payment to invoices, setting it as balance brought forward doesn’t allow this. I have several invoices for a month for the account. When they make payment its less rebate & advertising and settlement discount. After matching the payment amount and discount amount to the invoices im left with at least 5 unmatched invoices which off course add up to the rebate & advertising amount.
    My problem
    The rebate & advertising I make a credit note but this can only be matched to 1 invoice leaving the other 4 invoices unmatched. On my age analysis the unmatched amounts are still being reflected as outstanding as 30days/60days/90days. How do I get a clean accurate age analysis. I did have the account on bal brought forward and then to age analysis was showing the same.
    The best way to tidy up this kind of problem is to go to Process...Match Open Item and assign the credits to the appropriate invoices there.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

Similar Threads

  1. [Question] Vat control account balance, pastel
    By Jackievdw in forum Accounting Forum
    Replies: 6
    Last Post: 19-Feb-14, 10:55 AM
  2. Pastel Xpress 11 setup on server
    By ronish in forum Accounting Forum
    Replies: 2
    Last Post: 29-Aug-12, 06:45 PM
  3. Replies: 2
    Last Post: 25-May-12, 09:02 AM
  4. Pastel - Multiple invoices at once?
    By mother in forum Accounting Forum
    Replies: 6
    Last Post: 18-Jul-11, 09:59 PM
  5. Replies: 2
    Last Post: 14-Apr-11, 11:22 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
  •