Transaction Activity¶
The following rules apply to transactions:
- Transaction lines are written to an activity file.
- Each line references single values of product/variety, lot control, unit identifier, and locator entries.
- Quantities are signed (+/-) to indicate the effect of the transaction on inventory.
- Available = On-Hand + Reserve: Adding On-hand and Reserve transaction quantities for a product, lot, unit, or location gives all available.
- Selecting only transactions with condition G(ood) and adding On-hand and Reserve will give shippable available products, lots, locations, or units.
Posting Status Codes¶
- Posting Document Status Codes work in conjunction with Reserved and On-hand quantities to manage Unit, Lot, and Product availability at the main database level.
- Reserved and Allocated shipments, and also Expected and In-transit receipts all have Reserved quantity.
- A transaction line cannot be changed from Reserved to Allocated, or from Expected to In-transit, without adding validated Unit and Lot information when it is required.
- A transaction line may have either Reserved or On-hand quantity; not both. When an expected unit is received or an allocated unit is shipped, the status changes to 3 and the quantity moves from Reserved to On-hand.
- All lines included on a document must change to a higher status level (e.g., moving from status 2 to 3) before the overall document status can change to the higher status.
Table: Summary of status codes by document type.
| – Document Type –> | |||||
|---|---|---|---|---|---|
| STATUS | 2 Ship Order | 3 Receiving | 4 Shipment | 5 Adjustment | 6 Financial |
| -1 | Deleted | Deleted | Deleted | Deleted | Deleted |
| 0 | Data Error | Unposted | Unposted | Unposted | Unposted |
| 1 | Reserved | Expected | Reserved | Reserved | N/A |
| 2 | To Process | In Transit | Allocated | Held/Alloc | Entered |
| 3 | Processed | On-Hand | Shipped | OnHand/Ship | Verified |
| 4 | Charged | Charged | Charged | Charged | Charged |
| 5 | Invoiced | Invoiced | Invoiced | Invoiced | Invoiced |
| 6 | Archived | Archived | Archived | Archived | Archived |
Warning
Transactions are posted by line. However, all the lines of an entire document must be posted before the status of the document can change to indicate the document is posted.
Posting Quantity Example¶
Following is an example set of transaction lines illustrating the effect of Inbound/Outbound (+/-), use of Reserve and On-hand, and Condition. In this example, transaction lines were selected and then sorted by PRODUCT by VARIETY by CONTROL by UNITIDENTIFIER by TYPE by STATUS by POSTDATE.
| TP | SS | POSTDATE | PRODUCT | VAR | CONTROL | UNIT ID | C | UOM | ONHAND | RESERVED | COUNTPER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| – An expected (SS=1) Receipt may be reserved (SS=1) by a Shipment. | ||||||||||||
| RE | 1 | 20150615TZ | PPPP | CA | 54 | 54 | ||||||
| SH | 1 | 20150615TZ | PPPP | CA | -54 | 54 | ||||||
| – An in-bound (SS=2) Receipt must have control numbers and unit identifiers. | ||||||||||||
| RE | 2 | 20150615TZ | PPPP | CCCC | 23456 | CA | 54 | 54 | ||||
| – An on-hand (SS=3) Receipt may be allocated (SS=2) to a Shipment in process. | ||||||||||||
| RE | 3 | 20150615TZ | PPPP | CCCC | 34567 | G | CA | 54 | 54 | |||
| SH | 2 | 20150615TZ | PPPP | CCCC | 34567 | G | CA | -54 | 54 | |||
| – Mixed units will have multiple package records which must be withdrawn by package. | ||||||||||||
| RE | 3 | 20150615TZ | PPPP | CCCC | 45678 | G | CA | 46 | 54 | |||
| RE | 3 | 20150615TZ | PPPP | CCCC | 45678 | D | CA | 8 | 54 | |||
| SH | 3 | 20150615TZ | PPPP | CCCC | 45678 | G | CA | -46 | 54 | |||
| SH | 3 | 20150615TZ | PPPP | CCCC | 45678 | D | CA | -8 | 54 | |||
Note
- TP column shows Document Type Codes entries RE(ceipt), SH(ipment), or AW(djustment). Actual values are “3”, “4”, and “5”.
- SS column contains posting Document Status Codes.
- C column shows product Unit Condition Codes.
- Inner quantity posting is omitted from the above example for clarity.
- Signed quantities: in-bound positive, outbound negative.
- On-Hand + Reserve = Available.
- Status 1 – For Expected/Reserved status, Control Numbers and Unit Identifiers are optional and may be omitted.
- Status 2 – In-Transit/Allocated requires Control entries when tracked by lot (C)ontrol, and both Control numbers and Unit IDs when tracked by (U)nit.