Results 1 to 5 of 5

Thread: Sales journal import error-pastel express v18

  1. #1
    New Member
    Join Date
    May 2019
    Location
    Pretoria
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sales journal import error-pastel express v18

    Hi,
    When importing a .csv file into pastel(as a sales journal) I keep getting the following error message:
    Line 1: Account blank or not found.
    I actually did a sales journal(just one line) in pastel first and then exported it and converted it to csv to get the correct template(a great suggestion I found on this site). So, when I import this back to pastel it works....but, as soon as I amend anything to the file I get the above error message. Even if I copy the exact same line already in the csv file, I get this error message.
    Please help?

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Hi
    If you upload your modified csv file, maybe I can assist.

  3. #3
    New Member
    Join Date
    May 2019
    Location
    Pretoria
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sales Journal CSV File

    Apologies, please see file attached now
    Attached Files Attached Files

  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    I've had a quick look at the file and I see that, in column D (Account Number) you have 31.

    Is that the correct customer code, or are there leading zeroes in the code, e.g. 0031?

    If so, you need to insert the leading zeroes in the CSV file, by typing '0031 or '031 depending on the number of leading zeroes there are, and then save the file. Whenever you open a CSV file in Excel, it drops any leading zeroes.
    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)

  5. #5
    New Member
    Join Date
    May 2019
    Location
    Pretoria
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you so much!!! That was it! It works perfectly now...

Similar Threads

  1. [Question] Pervasive Error 161 - Pastel Express 14
    By Kare@kchaccounting.co.za in forum Accounting Forum
    Replies: 1
    Last Post: 04-Feb-19, 12:08 PM
  2. Pastel Express - cant email error
    By Admin4YOU in forum Accounting Forum
    Replies: 0
    Last Post: 15-May-17, 01:55 PM
  3. Pastel Express V11.2.1 Backup Error 507
    By Sanni D in forum Business Finance Forum
    Replies: 0
    Last Post: 17-Feb-16, 12:42 PM
  4. [Question] Run-time error 13 Type mismatch Pastel Express 12
    By newbie101 in forum Accounting Forum
    Replies: 2
    Last Post: 14-Sep-15, 08:37 AM
  5. [Question] Pastel Sales Journal
    By Dientjie in forum Accounting Forum
    Replies: 5
    Last Post: 17-Jun-15, 01:27 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
  •