Accounting Changes for Kanban Warehouses

Accounting with Kanban Warehouses

Transfers of materials between different warehouses have been a feature of Cyrious Control since version 4.0. In most respects, Production warehouses act like any other warehouse. In one key area, however, the accounting of inventory in Production warehouse differs from other stockroom warehouses.

On the balance sheet, all inventory in Production warehouses are tracked in a separate system inventory account called (by default) Production warehouse inventory. When inventory is moved into a Production warehouse, the value of that inventory is automatically transferred from the corresponding inventory asset account into the Production warehouse inventory asset account

In the following example, assume 2 rolls of material are released to the Production warehouse. Each roll has a cost of $325 in inventory. The corresponding entry in Control would look like this:

~ Account~ Warehouse~ Qty Billed~ Debit~ Credit
Paper InventoryMain- 2 rolls $ 650.00
Production warehouse inventoryProduction Floor+ 2 rolls$ 650.00

Warehouse Usage Guidelines
The guidelines for Stockrooms, Kanban warehouses, Warehouse Groups, and Standard warehouses are:

TopicStockroom RuleKanban RuleWarehouse Group RuleStandard Warehouse Rule
Module RequirementsInventory, ProFITSInventory, ProFITSInventory, ProFITSInventory
Reserving Inventory (Orders)Not Allowed. Orders may not use a stockroom as their production warehouse.Allowed.Allowed. Uses Default Production Warehouse.Allowed.
Ordering Inventoried Part (Bills, POs)AllowedNot Allowed. Bills and POs may not use a Kanban warehouse as the receiving warehouse.Allowed. Uses Default Stockroom Warehouse.Allowed.
Ordering Non-Inventoried Item (Bills, POs)Not Allowed. All Non-Inventory items are associated with a reservation from an order.Allowed if matches order’s the warehouse.Allowed if the default production warehouse matches the order’s warehouse.Allowed if matches the order’s warehouse.
Receiving Items (RDs)Allowed for Inventoried Parts.Allowed for non-Inventoried Item on an order if it matches the order’s warehouseAllowed for non-Inventoried Item on an order if it matches the order’s warehouseAllowed.
Recommended Stocking LevelsSupportedSupported, often zeroNot supportedSupported.
Inventory Quantities TrackedBilled
Not Billed
On-Hand
On-Order
Expected
Billed
Not Billed
On-Hand
Reserved
Available
On-Order
Expected
Sum(Billed)
Sum(Not Billed)
Sum(On-Hand)
Sum(Reserved)
Sum(Available)
Sum(On-Order)
Sum(Expected)
Billed
Not Billed
On-Hand
Reserved
Available
On-Order
Expected
Accounting for Inventory on the Balance SheetThe value of each inventory item is tracked in the GL Account associated with the part.The value of all inventory items is combined into a single GL Account “Kanban Warehouse”.Not applicable.The value of each inventory item is tracked in the GL Account associated with the part.
Accounting for in-process inventory on the Balance Sheet (no change)The value of consumed materials is tracked in a single GL Account “Cost of WIP & Built” while the order is being produced.The value of consumed materials is tracked in a single GL Account “Cost of WIP & Built” while the order is being produced.Not applicable.The value of consumed materials is tracked in a single GL Account “Cost of WIP & Built” while the order is being produced.
Expensing Inventory on the Income Statement (no change)The expense account associated with the part is used for inventory expensing.The expense account associated with the part is used for inventory expensing.Not applicable.The expense account associated with the part is used for inventory expensing.

Warehouse Inventory
For any given inventory item, the following inventory counts are tracked:

LevelDescriptionStandard Warehouse WarehouseGroupStockroomKanbanWarehouse
Billed Inventory that is in inventory and accounted for in the general ledger.??*??
Received Inventory that has been received but is not billed and whose value is not included in the general ledger.??*?
On-Hand On Hand Billed + Received
This represents the count of what is physically present.
??*?
Reserved Inventory that is reserved for pending orders.??* ?
Available Available On-Hand – Reserved
Inventory that is available for future orders.
??* ?
On-Order Inventory that has been ordered on a Purchase Order.??*??
Expected Expected Available + On-Order
The quantity of inventory that is expected when all pending orders are received.
??*??

Inventory Levels with Warehouse Groups

Reserved and On Order Inventory Quantities

Production Setup
The warehouse setup screen is located under the file menu under Production | Production Setup along with the following items:

When the applicable modules are not enabled, their corresponding setup is not displayed.
Production General Options Screen
The set-up screen for general production options is located under the Production | Production Setup menu.
productionsetupscreen.jpg
General options found on the setup screen include:
Warehouse Setup (only if Inventory module present)
[ x ] Enabled Warehouses
[ x ] Enabled Warehouses to have different part lists. (Caution – increases the setup!)
Stockroom Transfer Screen (only if Inventory and ProFITS module present)
[ x ] Allow the Transfer amount to use decimal (non-integer) values
[ x ] Enable barcode scanning of materials
[ x ] Require materials to be barcode scanned before creating Transfer Documents
Order Options
[ x ] Enable Built Status between WIP and Sale
[ x ] Show Order-Level Stations
[ x ] Require Order-Level Stations
[ x ] Track Changes to Order-Level Stations as activities
Default Order-Level Station : [ (none) \/ ]
[ x ] Require Line Item Station
[ x ] Track changes to Line Items as Activities
[ x ] Show the Proof Date
( ) Do not default the Proof Date
( x ) Default Proof Date to [ 1 ] Days from order create
( ) Default Proof Date to number of days for new order
[ x ] Show the Due Date
[ x ] Require Due Date for Orders
[ x ] Require Due Date for Estimates
[ x ] Require Due Date for Service Tickets
[ x ] Automatically Calculate Due Date
[ x ] Allow Due Dates in Orders before Today
Warn the user when:
( ) The due date is before the proof date.
( ) The proof date is before the due date.
( ) Neither.
Warehouse Setup Screen
The warehouse setup screen is located under the Production | Production Setup menu option.
productionwarehousesetupscreen.jpg
Warehouse setup requires the following information, some of which is only applicable to certain warehouse types.

FieldDescriptionEnabled When
Warehouse Name The name of the warehouse. All warehouse names must be unique.
Is Active Indicates whether this warehouse is currently active. Inactive warehouses will not show up in lists the user selects from.
Warehouse Type This type of warehouse. Valid choices are Standard, Kanban, Stockroom, or Group.
Top Level Division Warehouses are always Group. If ProFITS is not enabled, only Standard warehouses are allowed for other warehouses.
Only enabled if ProFITS module is enabled.
Warehouse Group The group this warehouse is contained within. Warehouse may only be reconfigured within their existing division. The top level warehouse group corresponding to theOnly enabled if ProFITS module enabled.
GL Account For Kanban Inventories only, this option selects the GL Asset Account that is used for accruing the inventory value. For all other types, this option is disabled and should show nothing. The selection list is limited to Asset Accounts.Only enabled if ProFITS module enabled and Warehouse Type is Kanban
Default Production Floor Warehouse For warehouse groups, the default production floor warehouse is Kanban or Standard sub-warehouse that is used by default when orders specify the warehouse group as the production location. Parts are reserved against the Production Floor Warehouse.Only enabled for Warehouse Groups
Include New Parts By Default The default case for warehouses can be set up to include all new parts or to not include new parts.