Results 1 to 2 of 2

Thread: Importing supplier invoices on csv

  1. #1
    New Member
    Join Date
    Nov 2018
    Location
    randburg
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Importing supplier invoices on csv

    im having a problem on importing supplier invoices on sage 18.The csv file is bouncing shows errors as follows1.sales analyis code doesnt exist ,2.the item code you selected doesnt exist 3,the project code doesnt exist.
    Attached Files Attached Files

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,491
    Thanks
    35
    Thanked 405 Times in 352 Posts
    Quote Originally Posted by giftm View Post
    im having a problem on importing supplier invoices on sage 18.The csv file is bouncing shows errors as follows1.sales analyis code doesnt exist ,2.the item code you selected doesnt exist 3,the project code doesnt exist.
    There are a number of errors in your CSV file that I have noticed.

    Column D: Delete <space> and leave it blank instead.
    Column S: You have a sales code of 1. Is that the code in Pastel, or are there any leading zeroes, e.g. 001? If so, insert the required number of leading zeroes in front of the 1.
    Columns T onwards do not seem to have the correct data. Please refer to the attached required layout.
    Attached Files Attached Files
    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)

Similar Threads

  1. [Question] Invoices importing
    By connie347 in forum Accounting Forum
    Replies: 0
    Last Post: 21-Feb-18, 09:14 AM
  2. [Question] Processing of Supplier invoices directly to Customer invoices
    By Oeloff in forum Accounting Forum
    Replies: 3
    Last Post: 09-Nov-17, 03:06 PM
  3. [Question] Pastel Supplier Invoices Matching - Remove Credited Invoices
    By steffie250 in forum Accounting Forum
    Replies: 6
    Last Post: 10-Mar-15, 01:23 PM
  4. Pastel v14 importing invoices from ultra sales POS
    By Coolblue in forum Accounting Forum
    Replies: 0
    Last Post: 05-Feb-15, 09:35 PM
  5. [Question] Supplier Invoices and vat
    By Jforssman in forum Accounting Forum
    Replies: 7
    Last Post: 23-Nov-12, 08: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
  •