Results 1 to 5 of 5

Thread: Importing Inventory Pastel Xpress V17

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    New Member
    Join Date
    Mar 2018
    Location
    Johannesburg
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Red face Importing Inventory Pastel Xpress V17

    Good Afternoon,

    I've been desperately trying to import inventory in Pastel Xpress V17.

    Here is what I've done so far, so not to mess anyone around.

    1. I.m now suck with an error code: Line 1: Group code does not exist? This is the only error as I have worked through all the others.
    2. I did export from Pastel as my example sheet
    3. It was exported in .csv format
    4. I'v also removed all blank spaces, so that has corrected that error
    5. Took out all " and any funny little characters that may cause problems
    6.Pastel V17 does not like the standard .xls layout that pastel has provided, it tells me that the layout is incorrect.

    Other than this, the only error i'm getting is with line 1: Group code does not exist.
    So I'm at my wits end as I've checked everything

    Just to also say thank you to Neville for providing a CB layout.csv this works perfectly. So i know a .csv layout does work, maybe I have done something wrong, on my spreadsheet?


    If anyone has a little advice thank you in advance

    Kind Regards

  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
    Make sure that you include the leading zeroes in the group code, as a CSV file will drop the leading zeroes when you open it in Excel.

    In other words, if the group code in Pastel is 001 then you must make sure that it reflects as '001 in the CSV file, not as 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
    Mar 2018
    Location
    Johannesburg
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville,
    Thanks for coming back to me. I've done that several times it makes no difference; keeps giving me the same error. Played around with the format, it still does not want to allow the first line? It's the same error one the users had on this forum, he managed to fix it but can't tell us how? So sorry this terrible query keeps coming up with Pastel and .csv format.

    I'll keep trying until something happens????

  4. #4
    New Member
    Join Date
    Dec 2022
    Location
    Patensie
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good day

    I have been struggling with this error and literally tried everything. Pastel is not able to help me.

    @Bernproud what did you

  5. #5
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    If you are prepared to upload the file, someone can probably point you in right direction.
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

Similar Threads

  1. [Question] Importing General Ledger Journal into Pastel Xpress V 12
    By Stevie Mac in forum Accounting Forum
    Replies: 18
    Last Post: 02-Mar-20, 07:24 AM
  2. [Question] Importing Inventory Master files into Pastel Partner
    By David Irish in forum Accounting Forum
    Replies: 2
    Last Post: 16-Aug-17, 05:00 PM
  3. [Question] importing inventory items into pastel
    By StenetteFarrell in forum Accounting Forum
    Replies: 11
    Last Post: 10-Nov-15, 07:04 AM
  4. [Question] Inventory Setup in Pastel Patner V12 - User fields - Importing stock list
    By newbie101 in forum Accounting Forum
    Replies: 1
    Last Post: 31-Jul-14, 01:03 PM
  5. [Question] Exporting and Importing Inventory Master File in Pastel
    By HermanS in forum Accounting Forum
    Replies: 6
    Last Post: 26-Feb-14, 09:12 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
  •