SKU Accounting

Standard Flow Movements

Area

Action

Transaction

Using

PO

Send

CR Expected

QTY Ordered

PO

Book in

CR  Qty Received

QTY Booked in

PO

Book in

DR Qty Expected

QTY Booked in

PO

Book in

CR Available

QTY Booked in

PO

Book in

CR Location Balance

QTY Booked in

PO

Retract Line

CR Cancelled

Qty Retracted

PO

Retract Line

DR Qty Expected

Qty Retracted

Note: For the PO object for a single SKU,  Qty Outstanding is calculated:
[Qty Ordered minus Qty Received minus Qty Cancelled]

Garment Sheet

Allocation

DR Available

QTY Allocated

Garment Sheet

Allocation

CR Allocated

QTY Allocated

Garment Sheet

Set Required

CR Expected

By QTY Required

Data Entry

Commit

CR Available

QTY successfully produced

Data Entry

Commit

DR Expected

sum of(QTY successfully produced, QTY Scrapped; QTY Discrepancy)

Data Entry

Commit

CR Location Balance

QTY successfully produced

Fulfilment (or Job from stock)

Allocation

CR Allocate

QTY Allocated

Fulfilment (or Job from stock)

Allocation

DR Available

QTY Allocated

Picking

Pick

DR Location Balance

QTY Picked

Picking

Pick

CR Picked

QTY Picked

Picking

Pick

DR Allocated

QTY Picked

 

 

Book in for SKU's that were not expected

i.e. the items are received unannounced so the Qty ordered never initiated a Qty Expected

Area

Action

Transaction

Using

PO

Book in

CR  Qty Received

QTY Booked in

PO

Book in

CR Available

QTY Booked in

PO

Book in

CR Location Balance

QTY Booked in

Note: For the PO object for a single SKU,  Qty Outstanding is calculated:
[Qty Ordered minus Qty Received minus Qty Cancelled]

 

Reversal  Movements

Area

Action

Transaction

Using

Picking

Unallocate

DR Allocated

QTY Unallocated

Picking

Unallocate

CR Available

QTY Unallocated

Picking

Unpick

DR Picked

QTY Unpicked

Picking

Unpick

CR Location

QTY Unpicked

 

Barcode / Stock Check SKU related Movements

Movement Type

Affects

Transaction

Using

Place

Location Balance

CR Location Balance

SKU and Qty  to Place

Place

Available Qty

CR Available

SKU and Qty to Place

Move

Source Location Balance

DR Source Location Balance

SKU; Source Location, SKU balance in source location

Place

Destination Location Balance

CR Destination Location Balance

SKU balance from source location

 

 

SKU Movement Validations

Movement Type

Constraint

Allocate

Max of (Available] plus [Expected])

Pick

Max of [To be Picked or Location Balance]
Where To be Picked = [Pick Requirement minus Picked]