When you are connected to an EDI warehouse, this stock management reconciliation will be setup to operate on a daily basis.
How this works
An overnight, once a day, stock listing is obtained from the warehouse, this is then loaded into the Commerce system and a comparison is made line by line to compare the stock held in Commerce and the stocks held at the warehouse.
This is known as a book to book comparison
What does it require
It is important that stock receipts and orders despatched are completed prior to running of the stock reconciliation, where you have not receipted stock there can be an impact to orders leaving.
What does this produce
A report is provided at the end of the process, this is generally set to only show the exceptions, this is where the warehouse have a quantity which varies to the quantity you have on Vision Commerce.
How does this work
You can fully automate the processes from your warehouse in which case the automated process is the route to follow, but where this is not supported OR you need to perform a manual operation then the manual process is followed.
These are just outlines of the process which is explained in more details throughout the wiki
The Automated Process
An API is used to obtain information from your warehouse, this takes information at frequent intervals and processes what we call
Goods Received
Orders Processed
Where items are matched they can be processed and where they can not you follow the manual process to push them through.
These automations from the warehouse adjust the stock up and down, and example of the warehouse group form is shown below
During the early hours of the morning a stock snapshot is taken from the warehouse system, this snapshot shows what the warehouse believe is in stock at that time, if they have despatched anything you would have received it in the orders processed information.
The Manual Process
Would be to use the direct screens for the process
Goods Received uses the Purchase Order → Receipting tab
Orders Processed will all be found in the Deliver Orders form.
There may be times where you need to manually receipt a Purchase Order or manually deliver a Sales Order.
If you do need to do so, make sure you accurately include the following information:
Rotation numbers used by the Warehouse (if you haven't got the file to check you will need to get the details from the Warehouse).
Quantities are correct.
If you are in any doubt about whether you should be processing these manually or are not sure about the details, please contact the Vision Support Team first, by raising a ticket in the Ontech Customer Support Portal. (https://visionsoftware.atlassian.net/servicedesk/customer/portal/1/user/login?)
See the Receipting Purchase Orders page for more details on the manual Receipting process.
What Checks should you make
This process of checking has been made redundant with the advent of the exceptions report, if the system is unable to receipt stocks OR despatch stocks you will receive an exception report.
If you get an exception report you will find that your stock reconciliation will also have this same issue.
Where you do get an exception
Goods Received Exceptions
The report will indicate any orders that could not be processed automatically by Vision Commerce. Normally for the following reasons:
Differences within the file from your original Purchase Order.
This could be changes made to your Purchase Order in Commerce after the file was submitted.
The Warehouse made changes that were not made on your Purchase Order in Commerce.
The Purchase Order has already been receipted manually within Vision Commerce.
This sometimes happens when a Purchase Order needs to be receipted urgently so that a Sales Order can be raised.
Providing the Purchase Order was receipted correctly (matches with the Warehouse file) then there is nothing further to do.
Returns: To correct this (depending on the circumstances) you would raise a credit against original goods, then raise a new Purchase Order or Ajust the stocks.
If goods have been re-landed you may need to use Rotation Maintenance (see the Rotation Maintenance page for more details).
If the Purchase Order Number in the file does not exactly match a Purchase Order Number in Vision Commerce the Purchase Order will not be updated.
Orders Processed
The report will indicate orders which cannot be automatically confirmed delivered by Vision Commerce. Normally for the following reasons:
Difference on the file from your original Sales Order.
This could be changes made to your Sales Order after the file was submitted.
The Warehouse made changes that are not made on your Sales Order in Commerce.
The Sales Order was already marked as delivered manually in Commerce.
This sometimes happens when a Sales Order needs to be marked as delivered urgently so a Sales Invoice can be raised.
Providing the Sales was marked delivered correctly (matches with the Warehouse file) then there is nothing further to do.
The rotations entered on the original Sales Order do not match those used by the Warehouse (and therefore appear on the file).
To correct this issue you may need to adjust the details of the stocks within the Rotation Maintenance screen (see the Rotation Maintenance page for more details).
If the Sales Order number in the file does not exactly match a Sales Order number in Vision Commerce the Sales Order will not be updated.
Stock Reconciliation - Common Issues
The following is a list of common issues you might encounter and what may have caused it:
Stock Level Discrepancy
You and the warehouse have different stock levels, depending on whether you have more or you have less than the warehouse will depend on how you investigate this.
If you have more stock then an order has not been confirmed delivered.
The warehouse have made an adjustment to stock, such as a stock loss.
Have you made an adjustment?
Was it correct?
Timing issues sometimes cause this to be a problem.
Finally compare stock movements with the warehouse.
If you have less stock.
You have confirmed a delivery when the warehouse have not dispatched it.
This is quite dangerous as the warehouse could use different rotations and then you would have to perform adjustments.
You have made an adjustment which the warehouse have not.
Check the original receipt quantity if it agrees then check the stock movements with the warehouse.
Rotation Not Found at Warehouse
You have a rotation on VC which the warehouse do not have.
You landed stock before the warehouse receipted it on their system.
Check the receipt date of the stock.
The stock has exhausted and you have not confirmed all deliveries or there was a stock loss.
Check and compare the stock movements.
Unknown Product Code
The warehouse have a product code that you do not have.
Check the product at the warehouse.
Investigate why the stock managed to arrive and you had no product code setup as no code means no purchase order.
Unknown Rotation Number
The warehouse have a rotation number that you do not have.
Usually means stock has landed and not received on system.
Very common for re-landing and Returns to be missed on receipting.
It is Very Important as this stock is Duty Paid and it will be used on the first available orders.