Importing supplier invoices on csv

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • giftm
    Email problem
    • Nov 2018
    • 1

    #1

    [Question] 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
  • Neville Bailey
    Diamond Member

    • Nov 2010
    • 2786

    #2
    Originally posted by giftm
    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
    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)

    Comment

    Working...