This screen is divided into two separate tabs:
EDI Imports
This is the screen that imports the final product into Vision WMS, the information in here comes from :
EDI inbound new files
VCIS new products
Excel Import screen following basic validation
Excel Import
This licensed feature allows you to take a simple excel, CSV file and load it into the system with very basic information in it, anything loaded through this will validate and put the record into the EDI Imports tab for final import and update.
...
EDI Imports
This screen is used to show a list of all Products for Customers that have been received via EDI Product Import files that are waiting to be imported into Vision Warehousing.
For ones that already exist in the system, they will have a tick in the first column.
You are able to update them by using the Update All selected
There will be a message to confirm that you wish to update only he “Already exists” products
If you click the Update all selected button on a product that does not already exist you will receive the message “No valid products selected for updating”
Once changes have been made they cannot be reversed
Clicking on a Product in the list will open up the Product Maintenance screen
More information on the Product page
Excel Import
This screen is used to allow you to take a simple excel, CSV file and load it into the system with very basic information in it.
Anything loaded through this will validate and put the record into the EDI Imports for final import and update.
| Info |
|---|
License Module This tab on the form requires a license in order to utilise the import functionality as the import components have to be licensed to allow you to use them. |
The import format for this tab is simply the same as the fields shown on the top of the form, if you insert those fields in the same order into an excel spreadsheet or a CSV file this will be able to import.
To load the file into the system, click on the icon on the top right of the tab
this will open up a new window and you need to select the import file from the location you saved it.
If you are using the paste then click on the paste in the icon on the top right
Once you have used the EXPORT feature, the product will be validated and inserted into the EDI tab and will not longer appear in this tab.
Once in the EDI tab, the products can be loaded into the system
| Import Notes |
|---|---|
Trans Adjt | The value is up to 2 decimal places. |
GrossWt | This should be the weight including the container/packaging for the unit |
NetWt | This should be the weight of the contents of the unit (excluding packaging) |
Charges | The Identifier comes from the ID on the charge which is used by the customer this can be seen in the customer charging records or the charge setup |