Versions Compared

Old Version 1

changes.mady.by.user Vicky Lau

Saved on

compared with

New Version 2

changes.mady.by.user Vicky Lau

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Import Program developed for allow user to import the Item Price, Sales Order and the Group Shipment information from the excel file.

Table of Contents

AreaDescription
Sales & Receivable Setup

Check Box "Use Order Import" and "Use Price List".

  • Check the check box if the company need to use the import function. 

Image Modified

Import Program navigation menu

Import Program 

Image Modified

Import Program Setup 
Excel Template Storage

Vendor Card

Item Card
Price Import Setup

Follow the steps below for setup the price import

1) Create the Price List Import Template

1.1 Select "Price List Import" 

Image Added

1.2 Click on the "No. drop down button, the page for "Price List Import Setup List" to be prompted

Image Added

1.3 Click "New" then enter the no. for the Price List Import Setup and then click "OK"

Image Added

2) "Import Setup" for the Price List Import Template

2.1 select the Price List import template in No. field then click "Import Setup" action button

Image Added

2.2 Fill-in the Import setup page

The setup page mainly for configure the data and the file mapping in the excel file.

Image Added

Example:

#FieldDescription
1Source TypeSource Type import from the field C1 in excel file
2Self PickSelf Pick import from the field C3
3Customer NoCustomer No. import from the field C2
4Starting DateStarting Date import from the field C4
5Ending DateEnding Date import from the field C5
6First Row IdIndicate the Price import data start from which Row.  In this case example, system will start to read the data from Row 13 for the item price information
7End Row IdSince system will skip the row if the item no is "blank" in the list.  Therefore, it needs to setup for the allow system which Row is end for reading the item price informaton.

Image Added