Inventory Update Logic - PO Receiving

 

 Type

Qty Res.        

Tot Res.   

Allocated

On Order

Notes

Warehouse

No change

No change

Increases by amt allocated to orders during receiving

Decreases by qty received.

 

Vendor ship

N/A – not received

N/A – not received

N/A – not received

N/A – not received

See section on invoicing.

Special Order

Increase by qty received

Increase by qty received

Increase by qty received

No change.  Quantity, was not added to on order amt when purchase order placed.

On hand, reserved and allocated are increased to keep inventory from being allocated to non-special order so lines.

Kitted item

No change

No change

Top and component items can both increase if all components available after purchase receipt

Component quantities are decreased by qty received.

Top-level part is not purchased.  Components are purchased based on need (orders for kits item is included in plus other orders for component)

Non-stock

N/A  - not purchased or received

N/A  - not purchased or received

N/A  - not purchased or received

N/A  - not purchased or received

Non-stock items are always available and never purchased.

Vendor ship – Non-stock (Item is set up as non-stock and vendor ship flag in sales order line is set to Y).

N/A  - not purchased or received

N/A  - not purchased or received

N/A  - not purchased or received

N/A  - not purchased or received

Vendor ship flag used only to determine which lines item will be invoiced with (vendor ship or normal).  Otherwise behaves just as non-stock does.

More:

Inventory Update Logic - Order Completion/Invoicing