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
    19
    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
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 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 - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    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
    Junior Member cagenuts's Avatar
    Join Date
    Mar 2012
    Location
    Randburg
    Posts
    19
    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
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 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 - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    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)

  5. #5
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Umkomaas
    Posts
    2,850
    Thanks
    249
    Thanked 371 Times in 327 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.
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

  6. #6
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 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.

  7. #7
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Now that's "out of the box" thinking Dave!

    Excellent suggestion!
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    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)

Similar Threads

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