Results 1 to 8 of 8

Thread: Consolidating Customer Statements in Pastel Partner v14

  1. #1
    Junior Member
    Join Date
    Jun 2016
    Location
    Cape Town
    Posts
    13
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Consolidating Customer Statements in Pastel Partner v14

    Hi
    Is there a way to consolidate customer statements.
    I have a retail customer who requires invoices to be issued in the name of each store; each having a separate VAT number. So we've set up a separate customer account per store. However payments are made centrally so they want a single consolidated statement that reflects all invoices for all stores on one statement.
    Any ideas?
    Thanks

  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
    Pastel Partner caters for this situation.

    Open a customer account for the head-office, to where you will be sending the consolidated monthly statement.

    You will notice, at the bottom left of the customer record, under the Details tab, a button named "Additional Delivery/Contact Details".

    Click on this button and then add the necessary details for each store in the group.

    When you process an invoice, click on the Delivery Address field in the header section, and then click on the Zoom icon, from where you can select the specific store that needs to be invoiced.
    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)

  3. #3
    Junior Member
    Join Date
    Jun 2016
    Location
    Cape Town
    Posts
    13
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Neville
    Wouldn't this method mean that the Head Office invoice address and VAT number would still be on the invoice and not the individual store's? i.e. only the delivery address would change.

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Yes, it would.

    But that should not be a problem, as the stores surely don't have separate VAT numbers from the head-office, otherwise why would you be needing to send a consolidated statement to head-office anyway?
    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)

  5. #5
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    In QuickBooks we can use the Project functionality to overcome this challenge. I seem to recall hearing Pastel also has something similar?
    The trouble with opportunity is it normally comes dressed up as work.

  6. #6
    Junior Member
    Join Date
    Jun 2016
    Location
    Cape Town
    Posts
    13
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks for your input Gents. Strange as it may be, that is indeed the case Neville. Each store has it's own VAT number as it's a separate entity and supplier payments are consolidated and paid on their behalf by the Head Office.
    Dave, I'll look into the project functionality. Neville do you know anything about it and if so do you think that would be a solution?
    The other thing I was thinking was maybe setting up a specific template that would replicate the delivery address in the invoice address space with the store VAT number included as a delivery address field. What do you think of that?
    But then how would you link that template to the customer apart from specifically selecting it each time I print. Just concerned that if that is the only way it's prone to user error where the incorrect invoice details are sent to the store.

  7. #7
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    If each branch is a separate entity, with its own VAT number, then you have no option but to create a separate customer account for each branch, and one for the head-office.

    With regards to the consolidated statement, an Intelligence report could be created to extract such a statement.

    The Projects Tracker module is designed for profit/cost centre analysis, not for what you have in mind. In other words, it works for income statement accounts only, not for balance sheet or customer accounts.
    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)

  8. #8
    Junior Member
    Join Date
    Jun 2016
    Location
    Cape Town
    Posts
    13
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Neville. I'll see what I can do.

Similar Threads

  1. [Question] Pastel V14 Customer Statements issue
    By Lewissangare in forum Accounting Forum
    Replies: 1
    Last Post: 12-Jan-16, 09:55 AM
  2. Pastel Customer Statements Question
    By Zoidbug in forum Accounting Forum
    Replies: 2
    Last Post: 18-Aug-15, 08:05 AM
  3. Replies: 1
    Last Post: 20-Jul-15, 01:56 PM
  4. [Question] Pastel Partner - Runtime Error 9 when running customer statements
    By J7J in forum Accounting Forum
    Replies: 0
    Last Post: 15-Aug-11, 09:45 PM
  5. [Question] Help Re: Pastel Customer Statements & incorrect opening balances.
    By Vinruby in forum Accounting Forum
    Replies: 3
    Last Post: 03-Aug-11, 11:28 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
  •