Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

StepDescription
1

Search "Order Import" and then select the related link or select the link from menu page

2

Select the "Price Order Import Template" then click "Import from Excel" action buttonImage Removed


3

Select the excel file for import the priceImage RemovedOrder


4

Once the price list Order 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.

 Image Removed


5

User Setup - the user who need to import the order must setup in User Setup table.

5


Error Handling

Info
titleValidation

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:

Image Removed




#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"

Image Removed


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.