Results 1 to 3 of 3

Thread: Inventory Journal Import

  1. #1
    New Member
    Join Date
    May 2019
    Location
    KZN
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Inventory Journal Import

    Good day

    I am trying to import an inventory journal on pastel to recognise my stock on hand quantities. With my first few attempts I received specific errors per line, which I have all corrected.
    After this I saved the file in csv. format..... Now when trying to import the journal, I receive the following message:

    Line 0: Undetectable error (Type mismatch)

    When closing this error I also further receive a Runtime error.
    I am currently using Pastel v18.

    Attached is the csv. file that I need to import. stock on hand import.csv
    Any advice?

  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
    Delete a few columns to the right from column H onwards, as well as delete a few rows down from row 255 onwards.

    Even though they appear empty, there might be some invisible characters in them.

    Then save the file and try again.
    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
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    A few possible things to check:

    Inventory codes can't contain blank spaces - line 1 10-15.appoll - has 2 spaces after it, before the comma - you need to delete the spaces. (Line 94 as well).
    Inventory Journal imports have a 20 character description - use the left command in excel to take the first 20 characters, then paste the values back over your description before you save as csv again.
    Items with no cost - I think they should be reflected as 0, not -
    Ensure your system is setup to allow negative quantities as you are taking -ve's in on the journal

Similar Threads

  1. [Question] Inventory Journal - Pastel
    By Trushil92 in forum Accounting Forum
    Replies: 2
    Last Post: 01-Aug-18, 07:59 PM
  2. [Question] Importing Inventory Journal errors
    By wilsnachjh in forum Accounting Forum
    Replies: 1
    Last Post: 01-Mar-18, 08:54 PM
  3. [Question] Pastel Inventory Journal
    By RianaGreeff in forum Accounting Forum
    Replies: 1
    Last Post: 21-Oct-16, 06:03 AM
  4. [Question] Pastel inventory import
    By Aldren in forum Accounting Forum
    Replies: 0
    Last Post: 28-May-16, 07:44 PM
  5. [Question] Inventory journal entry on Pastel
    By Jackievdw in forum Accounting Forum
    Replies: 5
    Last Post: 19-Jul-13, 09:07 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
  •