Commerce Stock Movement

Examples of different stock movements that you will find in the system

This is an example based on the most complex customer using Vision Commerce.

 

Whse

Type

Notes

On VW

EDI

Rtns

Reserve

Whse Group

Whse

Type

Notes

On VW

EDI

Rtns

Reserve

Whse Group

A

Consignment Stocks

Sale or Return
This warehouse group contains multiple warehouses

N

N

N

N

One group
Multiple warehouses

B

Office

Items held in the customers office

N

N

N

N

1 Group
1 Warehouse

C

Retail Stocks

Shops run by the company
Retail outlets

N

N

N

N

1 Group
1 Warehouse

D

Remote Warehouses

Stocks held at remote warehouses not under the control of the VW system

N

N

N

N

1 Group
1 Warehouse

E

Trading Warehouse

Each account should be in its own warehouse group

Y

Y

Y

N

1 Group
1 Warehouse

F

Events

using customer reserves to store the stocks for events but keeping them all segregated

Y

Y

Y

Y

1 Group
1 Warehouse

G

Reserved

Stocks being held for customers within the VW warehouse. One warehouse group will hold all the stocks so the user must choose the underlying account to take the stock from when the order is sent.

Y

Y

Y

N

1 Group
Multiple Warehouses


Below is the movements between each and what happens:

From

To

VC Order Type

DNote

VC EDI Out

VW Process / Notes

VC EDI In

VC Receipt Process

Notes

A/B/C/D

A/B/C/D

Stock transfer Internal

No

No

Not Applicable.

No

Manual
As no rotations are required the VC SO Delivery Orders will auto receipt the stock.

 

A/B/C/D

E/G

Stock transfer Internal

No

PA

VW warehouse receipts the goods from the PA which the VC system generates.



GR

VC SO Delivery Orders despatches the stock and leaves the PA waiting rotation entry.
EDI file read in and will receipt stock providing the rotation numbers.

When receiving multiple lines VC showing multiplied qty received on the the PO but is landing the correct qty in Stock and movements - Ref: VC-2298.

A/B/C/D

F

Stock transfer Internal

No

No

VW warehouse receipts the goods from the PA which the VC system generates.

The reserve customers can not be sent with a transfer orders so they have to be entered manually.

GR

VC SO Delivery Orders despatches the stock and leaves the PA waiting rotation entry.
EDI file read in and will receipt stock providing the rotation numbers.

Currently there is no way to receipt the stocks back into this warehouse correctly without EDI because it required the customer reserve to be entered which is not on the PO receipt screen, so you have to do this manually after receiving the stocks.

The PO to the Warehouse does not contain the reserve code unless it is noted in the notes.

Best transfer to E then move to F.
 

E/F/G

A/B/C/D

Stock transfer Internal

VW

SO - P

VW will return a file with the pick confirmation, when this is processed it will automatically receipt the stock into the new location as no rotations are needed.
 

OPC

Auto receipt is done via the Order pick confirmation EDI file or the manual process.

A PO is created at the point of the allocation for the delivery part this is used to receipt but can only be seen after this had completed.

E
or
G

E
or
G

Manual

 

 

 

 

 

 

Not supported on VC.

This will have to be done manually using the stock adjustments in VC and manually on VW.

Will require a new type of internal transfer to be added to allow these.

E/G

F

Stock Sales Order (Type R)

VW
conditional

SO - T

PO

SO generates and sent provides an OPC.

OPC is processed which provides a PO however warehouse auto creates a PO for these.

OPC

GR

Inbound EDI will tie up with the PA using the receipt type of TRA and will look at the Details field 1 for the SO number to relate it to.

Type R are not sales orders but disbursement of stock orders into reserves.

VC you can not receipt this manually without additional process to add the reserve customer.

it is possible for the GR for the receipt to arrive before VC generates a PO, because the VW system creates a virtual one, this would require a matching if this happens, and is not currently available in this version of VC.

F/G

E

Stock Transfer Internal

VW
conditional

SO - P

PO

 This will generate an order to remove the stock and reland it manually. However the PO is only generated after the warehouse confirm the picking of the SO.

 

OPC

GR

GR is automated through the EDI facility.

 This type of movement is not currently supported by the system. It generates a movement which will not allow a quick transfer to take place.

A change is needed to make this possible.

it is possible for the GR for the receipt to arrive before VC generates a PO, because the VW system creates a virtual one, this would require a matching if this happens, and is not currently available in this version of VC.

F

F

Stock Sales Order (Type R)

VW
conditional

SO - T

PO

EDI sent to warehouse they receive the goods. We generate a PO  based on this, receipt the stock with the rotations and which reserve it was landed in.

OPC

GR

Inbound EDI will tie up with the PA using the receipt type of TRA and will look at the Details field 1 for the SO number to relate it to.

Type R are not sales orders but disbursement of stock orders into reserves.

VC you can not receipt this manually without additional process to add the reserve customer.

 it is possible for the GR for the receipt to arrive before VC generates a PO, because the VW system creates a virtual one, this would require a matching if this happens, and is not currently available in this version of VC.

E

G

Stock Sales Order (Type T)

 

 



Yes

SO - T

Transfer within the warehouse.

 

 

This is designed for sales and this is actually not a sale.


The SO needs to have values and those have to be taken from the stock cost manually and entered.

 

Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.