Results 1 to 5 of 5

Thread: Pastel Partner recurring invoice dates

  1. #1
    New Member
    Join Date
    Sep 2019
    Location
    gauteng
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Partner recurring invoice dates

    Is there a way in Pastel Partner V18 to have a dynamic date line for recurring invoices, i.e. a line where the date changes as one copies the recurring invoice into a new period. What I need is for the invoice line to say "Garden Service for the month of ....." and this then automatically updates the month in a new period.

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,588
    Thanks
    41
    Thanked 420 Times in 366 Posts
    I'm not aware that it is possible to do that.

    The closest option is to insert the "Date (System)" data field into the document with Forms Designer, but that will render today's date, e.g. 11/09/2019, not the month.
    Neville Bailey - Pastel Accounting Consultant
    neville@accountingsoftwaresupport.co.za
    www.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
    Aug 2018
    Location
    Johannesburg
    Posts
    98
    Thanks
    0
    Thanked 24 Times in 21 Posts
    Hi Danny

    There are some possible workarounds. There is the "make one for all" invoice option. This allows you to create an invoice with the information you need on it as the first invoice in a batch. You then select Batch - Make one for all. You can choose to do this by customer category. If you tick the checkbox to "update selling prices" the system will update the price accordingly. There are multiple ways to get the price changed. I will try explain a few options below, depending on how you invoice.

    Create a customer category called "Recurring Services" (RS). Edit the customer accounts this applies to and put them in that category. Create the invoice with the line item description "Fees for August" (must be 1st invoice in batch). Batch - make one for all - select the category RS. You will now have invoices for all the customers. Repeat next month with description "Fees for September" on the first invoice. You can also create an additional user in Pastel, then jump to that user when processing recurring batches/make one for all invoicing, so we don't have to worry about other open invoices in your standard batches. You can also set the "Customer Reference" on the first invoice to "FEES FOR AUGUST", and this will repeat throughout the batch.

    If you have a fixed fee per client, this is easy. If this varies per customer, you need to make some additional changes. Create an inventory item as a service item, for Garden Services. In partner you have up to 10 pricelists. Set the selling price for each price list for that item. Edit the customers, and on their terms tab, change them to the relevant pricelist. When you "Make One For all", select update selling prices, and their price will change according to their pricelist.

    If you have even more price variations, you can go into Edit ... Customer ... Customer Prices. Create/Edit a customer price list, with volumetric discounts. Choose the Garden Services Item, then add each customer, with a qty of 1, and their specific price. Set the Expiry date to a date far in the future. As long as this price is lower than the selling price on the first invoice in the MOFA batch, when you MOFA and update selling prices, their individual price will reflect on the invoice.

  4. Thanks given for this post:

    Neville Bailey (12-Sep-19)

  5. #4
    New Member
    Join Date
    Sep 2019
    Location
    gauteng
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks Kevin

    Quote Originally Posted by Kevin Smith View Post
    Hi Danny

    There are some possible workarounds. There is the "make one for all" invoice option. This allows you to create an invoice with the information you need on it as the first invoice in a batch. You then select Batch - Make one for all. You can choose to do this by customer category. If you tick the checkbox to "update selling prices" the system will update the price accordingly. There are multiple ways to get the price changed. I will try explain a few options below, depending on how you invoice.

    Create a customer category called "Recurring Services" (RS). Edit the customer accounts this applies to and put them in that category. Create the invoice with the line item description "Fees for August" (must be 1st invoice in batch). Batch - make one for all - select the category RS. You will now have invoices for all the customers. Repeat next month with description "Fees for September" on the first invoice. You can also create an additional user in Pastel, then jump to that user when processing recurring batches/make one for all invoicing, so we don't have to worry about other open invoices in your standard batches. You can also set the "Customer Reference" on the first invoice to "FEES FOR AUGUST", and this will repeat throughout the batch.

    If you have a fixed fee per client, this is easy. If this varies per customer, you need to make some additional changes. Create an inventory item as a service item, for Garden Services. In partner you have up to 10 pricelists. Set the selling price for each price list for that item. Edit the customers, and on their terms tab, change them to the relevant pricelist. When you "Make One For all", select update selling prices, and their price will change according to their pricelist.

    If you have even more price variations, you can go into Edit ... Customer ... Customer Prices. Create/Edit a customer price list, with volumetric discounts. Choose the Garden Services Item, then add each customer, with a qty of 1, and their specific price. Set the Expiry date to a date far in the future. As long as this price is lower than the selling price on the first invoice in the MOFA batch, when you MOFA and update selling prices, their individual price will reflect on the invoice.
    Thanks very much Kevin

    Our invoices literally vary invoice by invoice so although your suggestion will work, it will be a big task for me initially.

    I think I kinda figured this out which will work for me.This is to export the recurring batch to Excel, then Find & Replace all the "month" descriptions I want to change and import the batch again. Really quick.

    My only hassle I now encountered was that Pastel does not like its own document date format it exports, so before I import again I have to reformat each date cell with dd/mm/yyyy. Find and replace does not work with this but maybe my Excel knowledge is not that advanced as I think this should work. I will persevere!

  6. #5
    Full Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    98
    Thanks
    0
    Thanked 24 Times in 21 Posts
    If all you want to change is the date on the exported batch, export the file and open it using notepad, rather than excel. You still have the find and replace function, but the date formats won't change.

Similar Threads

  1. [Question] Pastel Partner Invoice
    By JohanR in forum Accounting Forum
    Replies: 3
    Last Post: 30-May-19, 08:16 AM
  2. [Question] Cancelling Recurring invoices - Pastel Partner
    By CinsJ in forum Accounting Forum
    Replies: 0
    Last Post: 01-Sep-16, 04:31 PM
  3. Recurring invoices in pastel partner
    By Mari in forum Accounting Forum
    Replies: 1
    Last Post: 16-Apr-15, 09:07 AM
  4. [Question] Recurring Invoice total has disappeared
    By JLC in forum Accounting Forum
    Replies: 1
    Last Post: 28-Oct-13, 12:38 PM
  5. Replies: 3
    Last Post: 08-Mar-13, 08:19 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
  •