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 |
Validation
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
Example:
