| Table of Contents |
|---|
...
Functional Area | Transaction Type | Transaction Used for | Change Event | Effect on On Hand Balance |
Sales Order | Sales Order | Selling product to customers | Status changed to "Shipped" or Approved" If the "Include Shipped & Approved Sales Orders in On Hand balances" Inventory Preference is set to "Yes" | Decrease |
Status changed to "Ready to Post" If the "Include Shipped & Approved Sales Orders in On Hand balances" Inventory Preference is set to "No" | Decrease | |||
Sales Return | Recording a Return of product from a customer | Status changed to "Ready to Post" | Increase | |
Price Adjustment | Making changes to Invoices that only impact price, not product balances | This transaction does not change On Hand Balances | None | |
Quick Sale | Recording non-inventory sales to customers | This transaction does not integrate with Inventory | None | |
Inventory | Adjustment (negative qty) | Correcting product balances | Status changed to "Ready to Post" | Decrease |
Adjustment (positive qty) | Increase | |||
Production - Output (positive qty) Used to create inventory | Recording the results of production | Increase | ||
Production - Output (negative qty) Used to reverse Production | Decrease | |||
Production - Input (positive qty) Product issued to Production | Recording what was consumed in production | Decrease | ||
Production - Input (negative qty) Return Product that had been issued to Production | Increase | |||
Receipt (positive qty) | Recording what was received from a purchase | Increase | ||
Receipt (negative qty) | Decrease | |||
Inventory: Transfer (From) (Transfer Sent) | Recording product movement from one facility to another | Decrease | ||
Inventory: Transfer (To) (Transfer Receipt) | Increase | |||
Lot placed "On Hold" | Assigning a Hold Code(s) to a Lot | This event does not change On Hand Balances | None | |
Lot removed from "Hold" | Removing a Hold Code(s) to a Lot | None | ||
Fisherman Accounting | Fisherman Sale | Selling product to a fisherman | This transaction does not integrate with Inventory | None |
Tender Resale | This transaction does not integrate with Inventory | None |
...
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Inventory Balance Examples
The Available balance is calculated by using the following formula:
Available = On Hand - On Hold - Committed - Allocated
...
Transaction Type
...
Impact on Available Balance
...
Updating Event
...
Sales Order
...
Decrease
...
Allocated quantity is saved
...
Sales Order Return
...
Increase
...
Allocated quantity is saved
...
Price Adjustment
...
Does not effect inventory
...
SO Quick Sales
...
Does not effect Inventory
...
FA Fisherman Sale
...
Does not effect Inventory
...
Inventory Adjustment (negative)
...
Decrease
...
Allocated quantity is saved
...
Inventory Adjustment (positive)
...
Increase
...
Allocated quantity is saved
...
Inventory Production
...
Increase
...
Allocated quantity is saved
...
Inventory Receipt
...
Increase
...
Allocated quantity is saved
...
Inventory Transfer (From)
...
Decrease
...
Allocated quantity is saved
...
Inventory Transfer (To)
...
Increase
...
Allocated quantity is saved
...
Hold - Lot Placed On Hold
...
Decrease
...
Lot Placed on hold
...
Hold - Lot Removed From Hold
...
Increase
...
Lot Removed from hold
Inventory Balance Examples
...
Item Code
...
Event
...
On Hand
...
On Hold
...
Committed
...
Allocated
...
Available
...
Item ABC
...
Enter production for 100 cases, not yet posted and production batch not yet known
...
0
...
0
...
-100
...
0
...
100
...
Update the unposted production entry with the production batch number
...
0
...
0
...
0
...
-100
...
100
...
Post the production entry
...
100
...
0
...
0
...
0
...
100
...
Add a quality check hold code to the inventory lot
...
100
...
100
...
0
...
0
...
0
...
Quality check hold code removed from the inventory lot
...
100
...
0
...
0
...
0
...
100
...
Item is added to a sales order for 25 cases ordered, no allocations are complete
...
100
...
0
...
25
...
0
...
75
...
Sales order is updated to reflect an actual allocation of 22 cases
...
100
...
0
...
3
...
22
...
75
...
Sales order is marked as Shipped
...
100
...
0
...
3
...
22
...
75
...
Sales order is marked as Ready To Post
...
78
...
0
...
0
...
0
...
Lot Tracked Item in a Warehouse Lot tracked Site
The table below shows the running balance totals for each balance type at the Inventory Lot level
Event | On Hand | On Hold | Committed (-) | Committed (+) | Allocated (-) | Allocated (+) | Available |
Begin the month with 500 cases of Item ABC, in Site CCS It is all from Production Batch 0525 and is located in Warehouse Lot ABC. It is all assigned the Owner of Main and none of it is on Hold. | 500 | 500 | |||||
Entered a Production Output Transaction for 100 more cases that are all going into the same lot. The transaction is not yet posted. | 500 | 100 | 600 | ||||
Record a positive Receipt transaction for 50 more cases, all going into the same lot. The transaction is not yet posted. | 500 | 150 | 650 | ||||
Record a negative Adjustment transaction because 10 cases were destroyed by a forklift. The transaction is not yet posted. | 500 | 10 | 640 | ||||
Post the three transactions | 640 | 640 | |||||
Enter a transfer to send 200 cases to another Site. The transaction is not yet posted. | 640 | 200 | 440 | ||||
Allocate 40 case to Sales Order 58415. The transaction is not yet posted. | 640 | 240 | 400 | ||||
Post the Sales Order | 600 | 200 | 400 | ||||
Post the Transfer | 400 | 400 | |||||
Put the Lot on Hold | 400 | 400 | 0 |