| Table of Contents |
|---|
Step-by-
...
Step Guide for Import Price
| Info | ||
|---|---|---|
| ||
The following setup must be completed before import the excel file for setup the Purchase Price and Sales Price. Please see the document Release Note - CNA CINA - Import Program - Setup for details. 1) Sales & Receivable Setup 2) Customer Ship-to Address - PuA 3) Item Card - Vendor No. 4) Price Import Setup |
| Step | Description |
|---|---|
| 1 | Search "Price List Import" and then select the related link or select the link from menu page
|
| 2 | Select the "Price Import Template" then click "Import from Excel" action button
|
| 3 | Select the excel file for import the price
|
| 4 | Once the price list is imported, the No. of Lines Imported and No. of Success Imports to be populated by system automatically. The number of Failed Lines to be shows on the field "No. of Failed Imports". User can click the button next to field to preview the error and fix accordingly. |
| 5 |
Error Handling
| Info | ||
|---|---|---|
| ||
1) The price valid start date and end date must the first day and last day for the month respectively. Error message to be prompted if the start date is not the first day of the month or last date is not the end day of the month. To resolve the issue, change the date in excel file and then import again. Example:
|
| # | Description |
|---|---|
| 1 | Failed Imports User can see the number of failed imports in the price import page To review the error, click the action button it next to the field "No. of Failed Imports"
|
| 2 | The list of import fail item to be shows in the list. User can find what problem caused the import file in Error Column. After fix the issue (for example, add the item master or fill in the Vendor No into the item or enter PuA No. into Ship-to Address if missing), the click Re-Process to process the import file again. |
