You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

The customization aims to eliminate the data entry effort for Price Management, Ordering Process and Shipment Process.   

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

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. 

Import Program navigation menu

Import Program 

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" 

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

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

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

2.2 Fill-in the Import setup page

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

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.





  • No labels