Results 1 to 3 of 3

Thread: Pastel excel template

  1. #1
    New Member
    Join Date
    Oct 2020
    Location
    South africa
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel excel template

    Hi,

    Im looking for an excel invoice template to import into Template.

    I exported the invoice from docs....converted from csv to excel....however, still gives me a message...No invoices processed.

    I am using the csv Import/Export file layout....(Header & trailer)...I still cant upload....


    Pls advise....

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Hi Lennie

    We need to know what version of Pastel you are running (Partner / Xpress, and the build) to start to assist with your file layout issues. When you export the invoices as .csv, before you open it in excel, open the file in notepad. You will get a better idea of the layout required, as well as which fields need "" separators, and which ones don't. You need to watch out for items dropped due to leading zero's when opened in excel, as well as date formats, which are often converted in excel.
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

  3. #3
    New Member
    Join Date
    Oct 2020
    Location
    Sandton
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Lennie,
    I just developed a program for my friend who is migrating his current POS to pastel partner.
    The program downloads invoice file (xls attachment) from outlook to a designated folder and then convert to CSV ready to be imported to pastel.
    If you are interested, PM me.
    Tomer.

Similar Threads

  1. [Question] Payroll excel template
    By Smileyzn in forum Accounting Forum
    Replies: 3
    Last Post: 25-May-20, 12:40 PM
  2. Pastel Invoice Template
    By Lewissangare in forum Accounting Forum
    Replies: 2
    Last Post: 23-May-19, 07:56 AM
  3. [Question] How to change Pastel Evolution Invoice template?
    By Johan Maritz in forum Accounting Forum
    Replies: 1
    Last Post: 27-Sep-18, 04:09 PM
  4. [Question] Looking for credit note csv template to import into Pastel
    By dazed in forum Accounting Forum
    Replies: 1
    Last Post: 15-Mar-17, 01:57 AM
  5. Making a quotation template in Pastel
    By Martinco in forum Accounting Forum
    Replies: 11
    Last Post: 17-Apr-12, 09:06 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
  •