...
Expand | ||||||
---|---|---|---|---|---|---|
| ||||||
Interfaces cover both the API interface which is used from the
and also the internal CSV output/loading of files and information which allow you to
File OptionsExport and Upload It is NOT designed to amend anything other than prices on price lists, so to add product or remove them from price lists you should still use the relevant functionality on Vision Commerce. This tab on the form deals with both Exports of Information and Imports and validation of the data. You can export
Make sure you remember Specify the directory where you send want the files to , use the browse button to set the location to somewhere you can remember, once the files are created, you can then edit the values on the file and then re-upload the file which will automatically update the data Note | be downloaded to.
When you upload the data you will be asked to provide a directory for the location have finished editing the files save them and go back to the system but this time use the UPLOAD button When you upload the data you will be asked to provide a directory for the location of the file, this will then load the data and you MUST validate whichever price lists should you loaded. Should there be no issues during the validation it will load the data and immediately the new pricing takes effect. Validation IssuesAnything which has failed validation will be shown in the VIEW/EDIT rejections page and from here you can double-click on the item, correct the issue and then resubmit it. API OptionsIf you go to the API options you will be able to see all the items which are coming into the system from either the website, Vision Insight, Vision Horizon. where the items have NOT been able to go directly into the main system. if you wish to look at the details of what has been happening then you should view the audit log which provides a complete breakdown of all the transactions being processed The other tabs for customers and orders are built in such a way that only items with issues are left showing here on the screen, when an order or customer can be processed automatically then this will be carried out and you will need to do nothing. The information shown on the tabs is the complete information we have been sent from the external application so you can see all the fields. If you want to complete the information you can simply enter the missing information or double-click the entry will provide you with a form for key information which is missing, if there are further details which you have not noticed are missing then these need to be filled in.
The API Maintenance tabs help you define what happens when items come in through the API menu. |
Expand | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||
The API maintenance form needs to be set up before you start accepting orders and customer records from either your website, Vision Horizon, Vision Insight. This allows fields that those applications can not fill to be filled by the system automatically upon receipt to allow the new records to go straight into the system, anything missing you will have to edit through the interface module. The general page is used for the general way that the interface runs, and whether you want to save items directly or whether you want to be able to stop everything in the interface for you to process manually. Assuming that you wish to post everything directly then you will only see those items which have issues in the interface.
Customer defaults are to help you automatically create customers when the customer arrives from the external application, the fields above are mostly self-explanatory and come from the customer setup, which means they are choices of existing fields, such as VAT Code, Currency, status, analysis fields. If your external application can not complete or send these fields then this is what we will use to be able to save the customer record. The Analysis field will need to be set up in the Analysis Code Maintenance please see link Maintenance Auto Fill LookupThere is a feature on the system which allows analysis fields to be automatically derived from other information the customer is requested to provide within their address and contact information. This is an optional feature that you need to set up before switching on. The feature will allow you to look up a new customer country, name, address, area, telephone, etc and from one of these fields, it will then base the analysis code on the contents of that field. e.g. Customer sends in a +44 telephone number so we read this and we automatically know they are based in the United Kingdom. Order Defaults tab allows you to specify any final order defaults which are needed for the incoming orders, if they are not specified on the inbound file then these are the defaults that we will be using for the order.
|
Expand | ||
---|---|---|
| ||
The web extract can be run manually or you can schedule this to run automatically one time per day. This will produce a number of files for your website which can either be downloaded locally to your own system or if you provided FTP details we can send them to your website. The options are simply which output(s) do you wish and where do you want them to go to. The time taken to process this is generally within 30 seconds. Automated SchedulingThis has to be set up by us on the system for you and is done at the time when the system is first implemented or the web CSV is first licensed. |
...
Expand | ||||
---|---|---|---|---|
| ||||
The finance check is designed for older versions of Sage 50 (non-cloud) accounts where the Sage provided interface will fail to post invoices if you are using the sage system in any exclusive way. e.g. editing a nominal, checking audit, etc. For over Account Software please check the following page Finance Integration Service & Accounts Posting Maintenance Invoices which need to be verified will appear in the bottom half of the screen You can only check a maximum of one week at a time and it will go to the finance package and check that all invoices have been posted and are present.
System Verification is where Vision Commerce looks at each Invoice in Vision Commerce and checks that it has been posted to Sage.
Manual verification is where you have done the check yourself and you are basically saying that everything is good between the dates shown. |