Page History

...

Area

Description

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.
Enter the Max VAT Amount for allow system prompt the message if the GS invoice total amount is exceed.

Import Program navigation menu

Import Program

Import Program Setup

Excel Template Storage

Store the excel template for VAT Invoice Draft

Customer Ship-To Address

New field "PuA" - Fill in the PuA number for the Customer Ship-To address for the sales price mapping

Customer

New field "External System Code" - fill in the External System Code for showing in VAT Invoice

Item Card

Vendor No. - fill in the Vendor No. for Prince Import mapping

Description 2 - fill in the Item Description 2 for showing the item "Chinese Name" in VAT invoice.

Vendor Card

The new field “Order Import (Mill)” is included in the GS Import file. Enter “Mill” in the Vendor Card for the mapping information

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:

#	Field	Description
1	Source Type	Source Type import from the field C1 in excel file
2	Self Pick	Self Pick import from the field C3
3	Customer No	Customer No. import from the field C2
4	Starting Date	Starting Date import from the field C4
5	Ending Date	Ending Date import from the field C5
6	First Row Id End Row Id	Indicate from which row the price import data should start and end. In this example, the system will begin reading the data from Row 13 for the item price information until Row 250
7	Item No	Indicate which column the item number import data should be read
8	PuA No. Start Row Id	Indicate from which row the PuA No, import data should start. In this example, the system will begin reading the data from Row 13 for the item price information
9	PuA No. Start Col. Id PuA No. End Col. Id	Indicate from which column the PuA No, import data should start. In this example, the system will begin reading the data from column F for the item price information

Order Import Setup

Follow the steps below for setup the Order import

1) Create Order Import Template

1.1 Select "Order Import"

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

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

2) "Import Setup" for the Order Import Template

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