Results 1 to 7 of 7

Thread: Pastel Partner - How to invoice travel kms per customer?

  1. #1
    Junior Member cagenuts's Avatar
    Join Date
    Mar 2012
    Location
    Randburg
    Posts
    17
    Thanks
    3
    Thanked 3 Times in 3 Posts

    Pastel Partner - How to invoice travel kms per customer?

    I may not have made too much sense in the subject line but essentially I need to invoice my customers for travel.

    Is there a way to automatically add the kms when I invoice a call-out for example. At the moment we need to look at a table and this in turn leads to inconsistencies and mistakes.

    Should I rather just create inventory items per customer?

    Does Pastel have an option to automatically add the travel and call-out charges when I invoke say a labour charge or is everything a manual process?

    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
    If you have created Travel charges as a service inventory item, you will need to manually capture the number of kms to be charged, although you can set up a default rate per km.
    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 cagenuts's Avatar
    Join Date
    Mar 2012
    Location
    Randburg
    Posts
    17
    Thanks
    3
    Thanked 3 Times in 3 Posts
    Thanks Neville

    The rate is a fixed price but the actual distances vary of course. Is there a way to pull this figure from say a user-defined field in the customer account? Or even if it's not automatic, could that user-defined field (pre-populated with the customer specific distance) automatically be inserted into a line item? This would then have the effect of displaying the kms for the bookkeeper to punch into the quantity field.

    Am I making sense?

  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
    Unfortunately it isn't possible to do exactly what you are asking.

    However, there is a work-around, but there is a downside to it.

    If you use the Customer Prices option (Edit...Customers...Customer Prices), you could predefine the travel charge for each customer account, with a quantity of 1 and a unit price of whatever the the calculated value of the travel charge is for each customer. The downside is that the invoice will not display the number of kms charged, but only the total travel charge, but it will reduce the risk of human error when charging for travel.
    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
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,240
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Unfortunately it isn't possible to do exactly what you are asking.
    I know that this might sound a bit unorthodox, but would it not be possible to create the customer's name as an Inventory Item with the distance to their place of work as an entry. So you call up Mike and it "enters" Traveling 120km ? Just a thought ... I haven't tried it at all.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  6. #6
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,977
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Quote Originally Posted by Neville Bailey View Post
    If you use the Customer Prices option (Edit...Customers...Customer Prices), you could predefine the travel charge for each customer account, with a quantity of 1 and a unit price of whatever the the calculated value of the travel charge is for each customer. The downside is that the invoice will not display the number of kms charged, but only the total travel charge, but it will reduce the risk of human error when charging for travel.
    Thinking about that - If you're going to get out of the box like that, rather capture just the kilometers as the rate in the Customer specific pricing line item.

    Then use your per kilometer rate as the quantity when you invoice (I'm assuming you can go to decimal places in the quantity field in Pastel). This way when your rate per kilometer changes, you don't need to change scads of customer specific rates.

    If you can only use whole numbers for quantity there's still a solution, but explaining it isn't worth it if it's not an issue.
    The trouble with opportunity is it normally comes dressed up as work.

  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
    Now that's "out of the box" thinking Dave!

    Excellent suggestion!
    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] Pastel Invoice formats - Print vs PDF Email
    By surfgate in forum Accounting Forum
    Replies: 5
    Last Post: 21-Dec-12, 10:07 AM
  2. Computer generated tax invoice in Pastel
    By J7J in forum Accounting Forum
    Replies: 9
    Last Post: 18-Apr-12, 10:43 AM
  3. [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
  4. [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
  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
  •