<< Click to Display Table of Contents >>

Stock Movement

This documentation will show how stock moves in Custom Vantage Office.  This includes the In Stock, Committed, Available, Allocated, Back Order and On Order.

 

INVENTORY

Inventory Adjustment

a.) Posting an Inventory Adjustment with positive Quantity Difference

 

 

Effect

In Stock

Increased by the qty in the Qty Difference field

Committed

No change

Available

Increased by the qty in the Qty Difference field

Allocated

No change

Back Order

No change

On Order

No change

 

b.) Posting an Inventory Adjustment with negative Quantity Difference

 

Effect

In Stock

Decreased by the qty in the Qty Difference field

Committed

No change

Available

Decreased by the qty in the Qty Difference field

Allocated

No change

Back Order

No change

On Order

No change

 

Inventory Transfer

a.) Posting an Inventory Transfer (Warehouse From stock)

 

Effect

In Stock

Decreased by the transferred qty

Committed

No change

Available

Decreased by the transferred qty

Allocated

No change

Back Order

No change

On Order

No change

 

b.) Posting an Inventory Transfer (Warehouse To stock)

 

Effect

In Stock

Increased by the transferred qty

Committed

No change

Available

Increased by the transferred qty

Allocated

No change

Back Order

No change

On Order

No change

 

Inventory Build Assembly

a.) Assembly Item – positive build assembly. Post build assembly.

 

Effect

In Stock

Increased by the qty entered in Build Qty field

Committed

No change

Available

Increased by the qty entered in Build Qty field

Allocated

No change

Back Order

No change

On Order

No change

 

b.) Assembly Item – negative build assembly. Post build assembly.

 

Effect

In Stock

Decreased by the qty entered in Build Qty field

Committed

No change

Available

Decreased by the qty entered in Build Qty field

Allocated

No change

Back Order

No change

On Order

No change

 

c.) Component Item – positive build assembly. Post build assembly.

 

Effect

In Stock

Decreased by the qty equal to the build qty X qty to be 1 set

Committed

No change

Available

Decreased by the qty equal to the build qty X qty to be 1 set

Allocated

No change

Back Order

No change

On Order

No change

 

d.) Component Item – negative build assembly.  Post build assembly.

 

Effect

In Stock

Increased by the qty equal to the build qty X qty to be 1 set

Committed

No change

Available

Increased by the qty equal to the build qty X qty to be 1 set

Allocated

No change

Back Order

No change

On Order

No change

 

PURCHASING

Purchase Order

a.) Quantity is entered in Ordered field and the form is Saved.

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

No change

On Order

Increased by the qty entered in Ordered field

 

Purchase Receipt

a.) Receive items in Full.

 

Effect

In Stock

Increased by the qty received

Committed

No change

Available

Increase by the qty received

Allocated

No change

Back Order

No change

On Order

Decreased by the qty received

 

b.) Receive items partially.

 

Effect

In Stock

Increase by the qty received

Committed

No change

Available

Increase by the qty received

Allocated

No change

Back Order

No change

On Order

Decrease by the qty received

 

Return to Vendor

a.) Return an item in Return to Vendor.

 

Effect

In Stock

Decrease by the qty returned

Committed

No change

Available

Decreased by the qty returned

Allocated

No change

Back Order

No change

On Order

No change

 

SALES

Sales Quote

a.) New Sales Quote

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

No change

On Order

No change

 

b.) Process Quote to Order

 

Effect

In Stock

No change

Committed

Increased by the Ordered qty

Available

No change

Allocated

No change

Back Order

No change

On Order

No change

 

c.) Process Quote to Invoice

 

Effect

In Stock

No change

Committed

Increased by the Ordered qty

Available

No change

Allocated

No change

Back Order

No change

On Order

No change

 

d.) Process Quote to Purchase Order

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

No change

On Order

Increased by the Ordered qty

 

d.) Process Order to Purchase Order [Drop Ship]

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

No change

On Order

Increased by the Ordered qty

 

Sales Order

 

Bullet PointEnable Allocated = YES

a.) New Sales Order:  Enter a quantity in Ordered field and Save the form.

 

Effect

In Stock

No change

Committed

Increased by the qty entered in Ordered field

Available

No change

Allocated

No change

Back Order

No change

On Order

No change

 

b.) New Sales Order:  Enter a quantity in Allocate field and Save the form.

 

Effect

In Stock

No change

Committed

No change

Available

Decreased by the qty entered in Allocate field

Allocated

Increased by the qty entered in Allocate field

Back Order

No change

On Order

No change

 

c.) Process Order to Purchase Order

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

No change

On Order

Increased by the qty entered in Allocate field in Order form

 

d.) Process Order to Purchase Order [Drop Ship]

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

No change

On Order

Increased by the qty entered in Allocate field in Order form

 

Bullet PointEnable Allocated = NO

a.) New Sales:  Enter a quantity in Ordered field and Save the form.

 

Effect

In Stock

No change

Committed

Increased by the qty entered in Ordered field

Available

Decreased by the qty entered in Ordered field

Back Order

No change

On Order

No change

 

b.) Process Order to Purchase Order.

 

Effect

In Stock

No change

Committed

No change

Available

No change

Back Order

No change

On Order

Increased by the qty entered in Ordered field of the Order form

 

c.) Process Order to Purchase Order [Drop Ship].

 

Effect

In Stock

No change

Committed

No change

Available

No change

Back Order

No change

On Order

Increased by the qty entered in Ordered field of the Order form

 

 

Back Order

 

Bullet PointEnable Allocated = YES

a.) Open the Back Order, enter a quantity in Allocate field (equal to Ordered qty) and Save the form.

 

Effect

In Stock

No change

Committed

No change

Available

Decreased by the qty entered in Allocate field

Allocated

Increase by the qty entered in Allocate field

Back Order

No change

On Order

No change

 

b.) Process Back Order to Invoice.

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

Decreased by the Back Ordered qty

On Order

No change

 

c.) Process the Back Order to Invoice. Post the invoice with back ordered items fully shipped.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

No change

Allocated

Decreased by the qty entered in Allocate field of the Back Order

Back Order

No change

On Order

No change

 

Bullet PointEnable allocated = NO

a.) Process Back Order to Invoice.

 

Effect

In Stock

No change

Committed

No change

Available

No change

Back Order

No change

On Order

Decreased by the Back Ordered qty

 

b.) Process Back Order to Invoice. Post the invoice with back ordered items fully shipped.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

No change

Back Order

No change

On Order

No change

 

Sales Invoice

Bullet PointEnable Allocated = YES

a.) Process Sales Order to Invoice, then Post the invoice with items partially shipped.  For unshipped items, Back Order is created.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

Increased by the unshipped/back ordered qty

 

Allocated

Decreased by the qty entered in Allocate field of the Order transaction

Back Order

Increased by the unshipped qty

On Order

No change

 

b.) Process Sales Order to Invoice, then Post the invoice with items partially shipped.  For unshipped items, Purchase Order is created. (Note that Invoice will not be posted.)

 

Effect

In Stock

No change

Committed

No change

Available

No change

 

Allocated

No change

Back Order

No change

On Order

Increased by the unshipped qty

 

c.) Process Sales Order to Invoice, then Post the invoice with items fully shipped.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

No change

 

Allocated

Decreased by the qty entered in Allocate field of the Order transaction

Back Order

No Change

On Order

No change

 

d.) New Sales Invoice: Enter Ordered Qty and then Save the Invoice.

 

Effect

In Stock

No change

Committed

Increased by the qty entered in Ordered field

Available

No change

Allocated

No change

Back Order

No change

On Order

No change

 

e.) New Sales Invoice: Post the Invoice with items fully shipped.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

Decreased by the qty entered in Shipped field

Allocated

No change

Back Order

No change

On Order

No change

 

e.) New Sales Invoice: Post the Invoice with items partially shipped.  For unshipped items, Back Order is created.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

Decreased by the qty entered in Shipped field

Allocated

No change

Back Order

Increased by the unshipped/back ordered qty

On Order

No change

 

f.) New Sales Invoice: Post the Invoice with items partially shipped.  For unshipped items, Purchase Order is created. (Note that Invoice will not be posted.)

 

Effect

In Stock

No change

Committed

No change

Available

No change

Allocated

No change

Back Order

No change

On Order

Increased by the unshipped qty

 

Bullet PointEnable allocated = NO

a.) Process Sales Order to Invoice, then Post the invoice with items partially shipped.  For unshipped items, Back Order is created.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

No Change

Back Order

Increased by the unshipped qty

On Order

No Change

 

b.) Process Sales Order to Invoice, then Post the invoice with items partially shipped.  For unshipped items, Purchase Order is created. (Note that Invoice will not be posted.)

 

Effect

In Stock

No Change

Committed

No Change

Available

No Change

Back Order

No Change

On Order

Increased by the unshipped qty

 

c.) Process Sales Order to Invoice, then Post the invoice with items fully shipped.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

No Change

Back Order

No Change

On Order

No Change

 

d.) New Sales Invoice: Enter Ordered qty and then Save the Invoice.

 

Effect

In Stock

No change

Committed

Increased by the qty entered in Shipped field

Available

Decreased by the qty entered in Shipped field

Back Order

No Change

On Order

No Change

 

e.) New Sales Invoice: Post the Invoice with items fully shipped.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

No Change

Back Order

No Change

On Order

No Change

 

f.)  New Sales Invoice: Post the Invoice with items partially shipped.  For unshipped items, Back Order is created.

 

Effect

In Stock

Decreased by the qty entered in Shipped field

Committed

Decreased by the qty entered in Shipped field

Available

No Change

Back Order

Increased by the unshipped/back ordered qty

On Order

No Change

 

g.) New Sales Invoice: Post the Invoice with items partially shipped.  For unshipped items, Purchase Order is created.

 

Effect

In Stock

No Change

Committed

No Change

Available

No Change

Back Order

No Change

On Order

Increased by the unshipped qty

 

RMA

 

Effect

In Stock

No Change

Committed

No change

Available

No Change

Allocated

No change

Back Order

No change

On Order

No change

 

Credit Memo

Bullet PointEnable Allocated = YES

Posting a Credit Memo

 

Effect

In Stock

Increased by the qty returned

Committed

No change

Available

Increased by the qty returned

Allocated

No change

Back Order

No change

On Order

No change

 

Bullet PointEnable Allocated = YES

a.) Posting a Credit Memo

 

Effect

In Stock

Increased by the qty returned

Committed

No change

Available

Increased by the qty returned

Allocated

No change

Back Order

No change

On Order

No change