:code-column:
=================================
Double-Entry Inventory Management
=================================
A double-entry inventory has no stock input, output (disparition of products)
or transformation. Instead, all operations are stock moves between locations
(possibly virtual).
.. h:div:: doc-aside chart-of-locations
.. placeholder
Operations
==========
Stock moves represent the transit of goods and materials between locations.
.. rst-class:: alternatives doc-aside
Production Order
Consume:
| 2 Wheels: Stock → Production
| 1 Bike Frame: Stock → Production
Produce:
1 Bicycle: Production → Stock
Configuration:
| Stock: the location the Manufacturing Order is initiated from
| Production: on the product form, field "Production Location"
Drop-shipping
1 Bicycle: Supplier → Customer
Configurarion:
| Supplier: on the product form
| Customer: on the sale order itself
Client Delivery
Pick
1 Bicycle: Stock → Packing Zone
Pack
1 Bicycle: Packing Zone → Output
Shipping
1 Bicycle: Output → Customer
Configuration:
| on the pick+pack+ship route for the warehouse
Inter-Warehouse transfer
Transfer:
| 1 Bicycle: Warehouse 1 → Transit
| 1 Bicycle: Transit → Warehouse 2
Configuration:
| Warehouse 2: the location the transfer is initiated from
| Warehouse 1: on the transit route
Broken Product (scrapped)
1 Bicycle: Warehouse → Scrap
Configuration:
Scrap: Scrap Location when creating the scrapping
Inventory
Missing products in inventory
1 Bicycle: Warehouse → Inventory Loss
Extra products in inventory
1 Bicycle: Inventory Loss → Warehouse
Configuration:
Inventory Loss: "Inventory Location" field on the product
Reception
| 1 Bicycle: Supplier → Input
| 1 Bicycle: Input → Stock
Configuration:
| Supplier: purchase order supplier
| Input: "destination" field on the purchase order
Analysis
========
Inventory analysis can use products count or products value (= number of
products * product cost).
For each inventory location, multiple data points can be analysed:
.. raw:: html
- inventory valuation
-
value creation (difference between the value of manufactured products
and the cost of raw materials used during manufacturing) (negative)
- value of lost/stolen products
- value of scrapped products
- value of products delivered to clients over a period
- value of products received from suppliers over a period (negative)
- value of products in transit between locations
.. h:div:: doc-aside analysis-table
.. raw:: html
Location | Value |
Physical Locations | $1,000 |
Warehouse 1 | $600 |
Warehouse 2 | $400 |
Partner Locations | - $1,500 |
Customers | $2,000 |
Suppliers | - $3,500 |
Virtual Locations | $500 |
Transit Location | $600 |
Initial Inventory | $0 |
Inventory Loss | $350 |
Scrapped | $550 |
Manufacturing | - $1,000 |
Procurements & Procurement Rules
================================
A procurement is a request for a specific quantity of products to a specific
location. They can be created manually or automatically triggered by:
.. rst-class:: alternatives doc-aside
New sale orders
Effect
A procurement is created at the customer location for every product
ordered by the customer (you have to deliver the customer)
Configuration
Procurement Location: on the customer, field "Customer Location" (property)
Minimum Stock Rules
Effect
A procurement is created at the rule's location.
Configuration
Procurement location: on the rule, field "Location"
Procurement rules
Effect
A new procurement is created on the rule's source location
*Procurement rules* describe how procurements on specific locations should be
fulfilled e.g.:
* where the product should come from (source location)
* whether the procurement is :abbr:`MTO (Made To Order)` or :abbr:`MTS (Made
To Stock)`
.. h:div:: doc-aside
.. todo:: needs schema thing from FP
Routes
======
Procurement rules are grouped in routes. Routes define paths the product must
follow. Routes may be applicable or not, depending on the products, sales
order lines, warehouse,...
To fulfill a procurement, the system will search for rules belonging to routes
that are defined in (by order of priority):
.. rst-class:: alternatives doc-aside
Warehouses
Warehouse Route Example: Pick → Pack → Ship
Picking List:
Pick Zone → Pack Zone
Pack List:
Pack Zone → Gate A
Delivery Order:
Gate A → Customer
Routes that describe how you organize your warehouse should be defined on the warehouse.
A Product
Product Route Example: Quality Control
Reception:
Supplier → Input
Confirmation:
Input → Quality Control
Storage:
Quality Control → Stock
Product Category
Product Category Route Example: cross-dock
Reception:
Supplier → Input
Cross-Docks:
Input → Output
Delivery:
Output → Customer
Sale Order Line
Sale Order Line Example: Drop-shipping
Order:
Supplier → Customer
Push Rules
==========
Push rules trigger when products enter a specific location. They automatically
move the product to a new location. Whether a push rule can be used depends on
applicable routes.
.. rst-class:: alternatives doc-aside
Quality Control
* Product lands in Input
* Push 1: Input → Quality Control
* Push 2: Quality Control → Stock
Warehouse Transit
* Product lands in Transit
* Push: Transit → Warehouse 2
Procurement Groups
==================
Routes and rules define inventory moves. For every rule, a document type is
provided:
* Picking
* Packing
* Delivery Order
* Purchase Order
* ...
Moves are grouped within the same document type if their procurement group and
locations are the same.
A sale order creates a procurement group so that pickings and delivery orders
of the same order are grouped. But you can define specific groups on
reordering rules too. (e.g. to group purchases of specific products together)