Results 1 to 10 of 10

Thread: Pastel : Supplier Invoice Import

  1. #1
    New Member
    Join Date
    Dec 2020
    Location
    Cape Town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel : Supplier Invoice Import

    Hello everyone,

    I am trying to import a CSV into Pastel to do an invoice. I've modelled it according to an example that was exported from Pastel so I have the header and details fields. In spite of this, I'm still getting "first line must be a header" error.

    We tried changing the UTF encoding to something else other than UTF-8 but that gives a Runtime Error so I'm not sure if my CSV has the right encoding. It is generated from PHP dynamic coding that pulls the information from a database and then saved as CSV.

    Can anyone please help? I have attached the file.

    tfc-deliverynote-FLORA-UNITED-PROTEA-FARMS--PTY--LTD.2020-12-10.csv


    Regards,

    Karen

  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
    Hi Karen,

    I have looked at your CSV file and noticed the following:


    • Cell F1 does not have a period number. If your financial year is February, then the period number will be 9.
    • Cell I1 need to have a Y or an N in it to indicate where or not the invoice lines are VAT inclusive (Y) or VAT exclusive (N).
    • Cell T14 needs to have a value from 0 to 32, to reflect the customer's settlement terms.
    • Cell U1 needs to show the document expiry date.
    • Cell Y1 needs to show the exchange rate of 1 if the system has not been set up for multi-currency).
    • Column D in the Details lines must reflect the exclusive unit selling price.
    • Column E in the Details lines must reflect the inclusive unit selling price.
    • Column N in the Details lines must display as '001 not 1.
    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
    New Member
    Join Date
    Dec 2020
    Location
    Cape Town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville,

    Thank you so much for the feedback. I have made the changes you suggested and sent the CSV to my client. Unfortunately, he's still getting an error. Please see the amended CSV below, as well as the error my client receives. BTW, he is aware of the fact that my product codes do not match his.

    tfc-deliverynote-BUGLERS-POST-FARMS.2020-12-10 v2.csv

    Click image for larger version. 

Name:	IMG_1182.jpg 
Views:	207 
Size:	50.8 KB 
ID:	8039



    Regards,

    Karen

  4. #4
    New Member
    Join Date
    Dec 2020
    Location
    Cape Town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville,

    Any idea on the above?


    Regards,

    Karen

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

    Your header record is too short. After Exchange rate (your last field "1", you would normally still need Freight method, Ship/Deliver, Additional Costs and the email status. Try adding the below to the end of your header line and see if it will then import:
    ,"","","N"," "

    Your detail lines also need to change. As Neville mentioned, D E and N in the details. Storecode N should be your last value on detail lines, so after you make it "001" you need to remove the additional information on each line
    ,"","","","","","","","","","",""

    You will also need to match the product codes, else the import will fail.
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

  6. #6
    New Member
    Join Date
    Dec 2020
    Location
    Cape Town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Kevin,

    Thank you for your reply. We have matched up the product codes to eliminate that as an issue.

    We are however still getting the "first line must be a header" error.

    Here are the two files we've tried. Can you perhaps have a look and help?

    tfc-deliverynote-BUGLERS-POST-FARMS.2020-12-14.csv
    tfc-deliverynote-BUGLERS-POST-FARMS.2020-12-14 v2.csv


    Regards,

    Karen

  7. #7
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    You have something that has been added to the file that isn't recognised or visible, maybe when the PHP writes the file, like special characters or carriage returns, or something along those lines.
    Open the v2 file in notepad. Select all. Open new notepad. Paste and save. File imports into pastel perfectly with no changes. Without doing that, I also get the same error when trying to import the file, so I can only assume it is a hiden character somewhere in the file.
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

  8. #8
    New Member
    Join Date
    Dec 2020
    Location
    Cape Town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Kevin,

    Thank you for your help. I've managed to sort out the issue with the Header / Detail error but now I'm getting a new error: The Supplier Invoice Number cannot be blank.

    Here is my latest file:

    sample.csv

    Any ideas?


    Regards,

    Karen

  9. #9
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    That would be the Supplier invoice Number - column H / after date in the header section
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

  10. #10
    New Member
    Join Date
    Dec 2020
    Location
    Cape Town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Kevin,

    Thanks so much! This did the trick. The import is working now.



    Karen

Similar Threads

  1. Pastel Invoice Import / Export
    By ultramel1987 in forum Accounting Forum
    Replies: 0
    Last Post: 21-May-19, 08:45 AM
  2. [Question] Pastel Customer Invoice as a supplier
    By GerardS in forum Accounting Forum
    Replies: 0
    Last Post: 16-Jul-17, 02:14 PM
  3. [Question] Import invoice data into Pastel partner 14
    By Greigw in forum Accounting Forum
    Replies: 2
    Last Post: 27-Sep-16, 10:31 PM
  4. [Question] GRN into Pastel different to Supplier Invoice
    By AbigailM in forum Accounting Forum
    Replies: 1
    Last Post: 20-Oct-14, 07:35 PM
  5. How does Pastel link a Supplier Return to a Supplier Invoice?
    By Leigh Peiser in forum Accounting Forum
    Replies: 0
    Last Post: 27-May-14, 02:03 PM

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
  •