Results 1 to 3 of 3

Thread: Importing Inventory Pastel Xpress V17

  1. #1
    New Member
    Join Date
    Mar 2018
    Location
    Johannesburg
    Posts
    3
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,495
    Thanks
    35
    Thanked 405 Times in 352 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions
    View Neville Bailey Photography

    "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
    3
    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????

Similar Threads

  1. [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
  2. [Question] importing inventory items into pastel
    By StenetteFarrell in forum Accounting Forum
    Replies: 11
    Last Post: 10-Nov-15, 07:04 AM
  3. [Question] Importing General Ledger Journal into Pastel Xpress V 12
    By Stevie Mac in forum Accounting Forum
    Replies: 16
    Last Post: 26-Aug-14, 11:42 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
  •