Results 1 to 7 of 7

Thread: Pastel Xpress V12 - Large Batch of Invoices

  1. #1
    Full Member
    Join Date
    Feb 2013
    Location
    Gauteng
    Posts
    29
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Pastel Xpress V12 - Large Batch of Invoices

    Good Day

    I have a situation where I need to invoice a particular client per "item" (ie one invoice per item) - which is approximately 150 to 200 invoices per month.

    Is there perhaps a way that I can make this process easier - either with a template of sorts to where I can just enter different quantities and pricing for each invoice, or perhaps a way I can make the invoices in rows in excel and just import the excel csv into pastel invoice batch?

    Any advise in this regard would be most appreciated

    thank you

  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
    Only Pastel Partner (not Xpress) has the recurring invoice facility.

    However, you could construct a CSV file (which you can edit in Excel) and then import it into a tax invoice batch.

    I suggest that you manually capture two or three such invoices in Pastel and then export the batch as a CSV file (insert the four characters .csv at the end of the file name), and then open the CSV file with Excel. You will then have an idea as to the layout of the CSV file, and then you can populate it with the remaining invoices and import it back into Pastel (first delete the test invoices from the CSV file, otherwise you will duplicate them).

    You will notice that, in the CSV file, there is a Header line for each invoice, followed by one or more Detail lines, depending on the number of lines per invoice.
    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. Thanks given for this post:

    Newretailer (15-Aug-14)

  4. #3
    New Member
    Join Date
    Mar 2016
    Location
    Durban
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    Only Pastel Partner (not Xpress) has the recurring invoice facility.

    However, you could construct a CSV file (which you can edit in Excel) and then import it into a tax invoice batch.

    I suggest that you manually capture two or three such invoices in Pastel and then export the batch as a CSV file (insert the four characters .csv at the end of the file name), and then open the CSV file with Excel. You will then have an idea as to the layout of the CSV file, and then you can populate it with the remaining invoices and import it back into Pastel (first delete the test invoices from the CSV file, otherwise you will duplicate them).

    You will notice that, in the CSV file, there is a Header line for each invoice, followed by one or more Detail lines, depending on the number of lines per invoice.
    May I ask, how do you export invoices in CSV format in Pastel Xpress V12? I can't find a 'export invoices' option in the import/export file menu. I know one needs to add .csv when choosing the save location, if I could just find the correct option to export invoices...

  5. #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
    Quote Originally Posted by freestanler View Post
    May I ask, how do you export invoices in CSV format in Pastel Xpress V12? I can't find a 'export invoices' option in the import/export file menu. I know one needs to add .csv when choosing the save location, if I could just find the correct option to export invoices...
    While you in the Document screen, click on the Batch button at the bottom and you will see an Export and Import option there.
    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)

  6. Thanks given for this post:

    freestanler (02-Mar-16)

  7. #5
    New Member
    Join Date
    Mar 2016
    Location
    Durban
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    While you in the Document screen, click on the Batch button at the bottom and you will see an Export and Import option there.
    Thanks for the quick reply!

    I am very ignorant when it comes to Pastel, I am quite the noob. Your advice let's me export that one invoice, unless I am missing something...is there a way to select a date range of invoices (or even all the invoices ever, in the programme) and export that to CSV?

  8. #6
    New Member
    Join Date
    Mar 2016
    Location
    Durban
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    For invoices already created and updated

  9. #7
    New Member
    Join Date
    Mar 2016
    Location
    Durban
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I found how to do it , with help from Pastel Call centre. Go to PCC, create a new database based on the current Pastel database, expand the table of this new database, and go to header info, and export.

    I hope I relayed that correctly, I'm in a hurry

Similar Threads

  1. [Question] Pastel Xpress V11 CSV file layout to import Invoices
    By Braam in forum Accounting Forum
    Replies: 1
    Last Post: 06-Jun-16, 08:41 AM
  2. [Question] How to View Batched Invoices on Pastel Xpress
    By fuzegraphics in forum Accounting Forum
    Replies: 5
    Last Post: 28-Jul-14, 12:19 PM
  3. PASTEL V12 - SALES INVOICES DELETING FROM BATCH
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 18-Sep-13, 10:25 AM
  4. [Question] How to resolve duplicate invoices that have been updated Pastel Xpress
    By fuzegraphics in forum Accounting Forum
    Replies: 3
    Last Post: 12-Dec-12, 10:04 AM
  5. [Question] Recurring Invoices Pastel Xpress?
    By fuzegraphics in forum Accounting Forum
    Replies: 3
    Last Post: 22-Nov-12, 07:29 AM

Tags for this Thread

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
  •