Barcodes are required for a series of system record types
Job Orders
Fulfilments
Purchase Orders
Delivery Receipt / Cross Reference Records
SKU's
Storage Locations
Print on Demand Labels (Job Ref / Store Order Ref / SKU & QTY and Delivery Ref)
Asset Inventory [IT, tooling etc] (this may be separate for accounting)
Barcode Related Functions
Object | Action |
View |
Place |
Move |
Queue |
Job |
Returns
the Job Record and current Location(s) |
Requires
location; and records location against job record |
Requires
location; and records new location against job record |
N/A |
Fulfilment |
Returns
the Job Record and current Location(s) |
Requires
location; and records that location against Fulfilment |
Requires
location; and records new location against fulfilment record |
N/A |
PO |
Returns
the Job Record and current Location(s) |
Requires
location; and records that location against PO record |
Requires
location; and records new location against PO record |
N/A |
SKU |
Returns
the SKU and Current Details per Location |
Requires
a SKU, and a location, and requires a qty |
Requires
a SKU; and then provides a list of existing locations for the
SKU |
Allows
the user to scan multiple SKU's |
Location |
Returns
the contents of the Location |
N/A |
Returns
a listing of the Contents of the location |
N/A |
Full tracking for SKU should be built in
To define, but would look something like
Date |
Movement Type |
QTY |
User |
Associated Order |
Order Type |
Associated PO |
From |
To |
01-Dec-2023 |
Produced |
10 |
ipad 1 |
123345/1 |
Job |
|
Auto 1 |
Wa1-A1 |
02-Dec-2023 |
Picked |
5 |
ipad 1 |
30000/1 |
Fulfilment |
|
Wa1-A1 |
Despatch ready to sent |
03-Dec-2023 |
Book In |
15 |
goods i 5 |
|
|
897565 |
Goods In temp |
Wa1-A1 |
04-Dec-2023 |
Unpick |
5 |
|
30000/1 |
Fulfilment |
|
Despatch ready to sent |
WA2-7B2 |
04-Dec-2023 |
Stock set |
26 |
manager 3 |
|
|
|
WA2-7B2 |
WA2-7B2 |
Produced: requires a corresponding Order ID (credit)
Booked In: requires a corresponding PO ID (credit)
Picked requires a corresponding Order ID (job or fulfilment) (debit)
Unpick: requires a corresponding Order ID (job or fulfilment) (credit)
Stock Set: (overwrites the QTY)
All movements woud list both [moved] from and to locations
Product Definition
Product Type (lowrer level, eg caps) - add Type description field
This would allow Type to be a much smaller set of values - with sku specific variations being defined via the type description
Existing Type
Type |
Cap - American |
Cap - Trucker |
Cap - Spiderman |
3 Type values
becomes
Type |
Type Description |
Cap | American |
Trucker | |
Spiderman |
One type value