...
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 Entries into this table will come from two places, either direct from the customer through the EDI hub using XML or they will come from VCIS via new product entry.
| Tip |
|---|
Vision EDI is an additional module available for WMS Vision CIS is the Customer portal available on the internal which is an additional module for WMS |
This screen shows a list of new products which have NOT been added to the main customer product table.
| Info |
|---|
Customers can send duplicates, if this is identifed then the ‘Already Exists’ will have a tick in the |
...
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
...
box |
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 itit will complete the new product record with the details that have been provided already, you just need to check verify add any missing details and then submit.
| Tip |
|---|
See the Create Product wiki page for details of the product maintenance fields and how to use that form. |
Excel Import
You can import into the system using CSV or Excel, the fields needed for the import are the same fields which are shown on the form, it is a very basic import but can save alot of time when importing products into the system and there is no need for an EDI XML file to be created.
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.
It represents a percentage adjustment to the line case calculation for transport charging
...
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
This feature requires a license to enable it to be used.
| Expand | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
Excel Import 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.
|
| Tip |
|---|
Details of the fields and their contents can be found on the Create Product wiki page |