Versions Compared

Old Version 2

changes.mady.by.user Vicky Lau

Saved on

compared with

New Version 3

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

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



Item Card

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


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

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 Modified

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

Image Modified

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

Image Modified

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 Modified

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 Modified

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
6

First Row Id

End Row Id

Indicate from which row the
Price
price import data should start
from which Row
and end.
 
In this
case
example, the system will
start to read
begin reading the data from Row 13 for the item price information until Row 250
7
End 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.
Item NoIndicate which column the item number import data should be read
8PuA No. Start Row IdIndicate 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

Image Modified