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

Compare with Current View Page History

« Previous Version 3 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

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

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
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
7Item 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





  • No labels