Results 1 to 3 of 3

Thread: Pastel V17 Inventory Item Import Errors

  1. #1
    New Member
    Join Date
    Feb 2017
    Location
    Pretoria
    Posts
    3
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Pastel V17 Inventory Item Import Errors

    Hello Everybody


    I'm having trouble importing my inventory from a .csv file into Pastel Partner V17.
    Here are the steps I take when creating the import file:

    Using a pdf document that I received from Sage Support I create an Excel document with all the headings, exactly the same as in the document.
    I pay special attention to columns AB, AJ and AK to ensure the formatting of those columns display correctly (for example 2 displays as 002)
    I've created all the inventory categories for my products within Partner and I only have the two default inventory groups (Service items 001 and Inventory Items 002).
    Once I've filled in all the fields in the excel document I save it as a .csv.
    -I use the import/export option in Partner
    -Select inventory items, browse for the .csv file I created
    -Untick the Map fields box and click on process

    Then I get an error saying Line 1: Inventory group does not exist

    When choosing to import and mapping the fields manually Pastel automatically picks up all the mapping except for the Group column.
    If i map the group column manually and click on process I get a runtime error 70.

    I've spend lots of time on the phone with support but they just keep on telling me to make sure the formats are correct with Columns AB, AJ and AK.

    Any help would be greatly appreciated.

    Thanks
    Christiaan

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,509
    Thanks
    36
    Thanked 406 Times in 353 Posts
    Hi Christiaan,

    You mentioned that you included the headings for the columns - when you started the import, did you make sure that kept the option "Include Field Names" ticked?

    Also, make sure that none of your stock descriptions have double quotation marks in them (").

    If it still does not import, after checking the above points, please attach your CSV file and I will have a look at it.
    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. Thanks given for this post:

    Christiaan30888 (09-Feb-17)

  4. #3
    New Member
    Join Date
    Feb 2017
    Location
    Pretoria
    Posts
    3
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    Hi Christiaan,

    You mentioned that you included the headings for the columns - when you started the import, did you make sure that kept the option "Include Field Names" ticked?

    Also, make sure that none of your stock descriptions have double quotation marks in them (").

    If it still does not import, after checking the above points, please attach your CSV file and I will have a look at it.
    Hi Neville

    I played around with different options, removing spaces from the headings, different formatting, alignment etc. and I was finally able to get the stock imported.
    Unfortunately I have no idea what fixed the problem because the file that eventually imported seems to be exactly the same as the one that didn't want to import.

    Thank you for your reply
    Christiaan

Similar Threads

  1. [Question] Pastel Partner duplicate inventory item on sales order
    By David Irish in forum Accounting Forum
    Replies: 1
    Last Post: 29-Nov-16, 10:15 AM
  2. [Question] Pastel inventory import
    By Aldren in forum Accounting Forum
    Replies: 0
    Last Post: 28-May-16, 07:44 PM
  3. Pastel - Inventory Item Error
    By CyberStorm in forum Accounting Forum
    Replies: 6
    Last Post: 18-Aug-15, 08:07 AM
  4. Import csv on inventory count error pastel Evolution
    By uriel in forum Accounting Forum
    Replies: 0
    Last Post: 13-Jun-14, 12:28 PM
  5. Replies: 3
    Last Post: 24-Jun-11, 04:59 PM

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
  •