Ledger123.com

SQL-Ledger Training, Support, Custom Development and Hosting

by on

Import customer price list

  1. Format your customer price list according to the sample CSV data below.

    partnumber,customernumber,pricegroup,pricebreak,sellprice,validfrom,validto,curr
    B001,AE001,PG1,10,11,03-01-2008,,GBP
    B002,BP011,,20,12,,03-01-2009,GBP
    M004,CP002,,15,20,03-01-2008,03-05-2008,GBP
    D08,CP002,test,25,25,,,GBP

  2. Click ‘Data Import–Parts Customers’, specify the file with the ‘Browse’ button and click ‘Import Parts Customers’ button.

  3. Following page will be displayed. Here you can un-check the rows which you do not want to import. Rows with invalid customer number or partnumber will not have the checkbox.