Cyrious Control uses average cost methodology of accounting for inventory. Inventory in Cyrious Control is implemented through parts. Each part can be enabled for inventory tracking (though typically this only makes sense for material parts). For each part, the following three equations determine the current inventory levels:

Each of these components should be understood in order to properly use the inventory feature in Control.

Inventory Level Available Available Inventory is the amount of inventory available for new orders, which is the amount on-hand less any amount reserved for orders in WIP.
Inventory Level Reserved by Orders The inventory Reserved by Orders is tracked automatically in Control, and records the amount of inventory that is currently reserved by orders in WIP. This quantity is automatically adjusted (based on store options) as an order is worked on.
Inventory Level On Hand On-Hand Inventory refers to the total amount of material currently in inventory.
Inventory Level On Order On-Order Inventory is the amount of the item on order. This number can be manually adjusted, or automatically increased through the use of purchase orders.
Inventory Level Expected Expected Inventory refers to the amount expected is the amount available plus the amount on order.

One final distinction is necessary. On-Hand Inventory is subdivided into two different buckets:

Inventory Level Billed Inventory Billed is on-hand inventory that has been fully accounted for in the accounting system (GL).
Inventory Level Received Only (not billed) Inventory Received Only is a special category of inventory that has been received into inventory (normally via a receiving document), but the bill for this inventory has not yet been posted.


All inventory items must be parts. Parts are the basic object used for tracking inventory in Control. To enable inventory tracking for a specific part, check the “Track Inventory” checkbox at the top of the part. You will notice that a new Inventory tab appears for the part. On the inventory tab, the various inventory levels (described previously) are shown, along with various other stocking information (like reorder levels and reorder points).
When you are first creating a part, you may enter the initial inventory levels. The GL entries made for the initial entry of parts are:

Account Quantity Debit Credit Notes
Inventory Account+ Qty BilledUnit Cost * Qty Billed The inventory account is also specified on the Inventory tab in Parts setup.
Inventory Adjustment Unit Cost * Qty BilledThis is a System Account and cannot be changed.

After the part has been saved, if you wish to manually enter or adjust the inventory levels, you must click on the “Adjust Inventory” button on the Inventory tab for that part (when the part is not being edited) and enter the current inventory levels. In this case, the GL entries made will be:

Account Quantity Debit Credit
Inventory AccountNew Qty Billed – Original Qty BilledUnit Cost * (New Qty Billed – Original Qty Billed)
Inventory Adjustment Unit Cost * (New Qty Billed – Original Qty Billed)

As you would expect, manually adjusting the average cost of a part will also reduce the inventory valuation of a part and must be accounted for. In this case, the GL entries made will be:

Account Quantity Debit Credit
Inventory Account0Qty Billed * (New Unit Cost– Original Unit Cost)
Inventory Adjustment Qty Billed * (New Unit Cost– Original Unit Cost)

Disabling Inventory will result in the inventory being adjusted to zero, and the corresponding GL entries made. Further, all Received Only and On-Order Inventory will be set to zero.


Adjusting inventory levels can be done in several ways. One method, mentioned in the last section is to open the part and adjust the inventory manually. This method works for the adjustment of one or a few parts, but is not very efficient when setting initial inventory levels en masse or adjusting inventory levels after a periodic inventory. During these times, you will want to take advantage of the “Adjust Part Inventory” utility (from the main menu, under Vendors).
The Adjust Part Inventory utility displays all your parts with inventory tracking enabled and allows you to enter the following values:
* Adjusted Billed
* Adjusted Received Only
* Adjusted On-Order
When you save your changes, Control adjusts the part inventory levels and the inventory valuation in GL. The GL entries made will be:

Account Quantity Debit Credit
Inventory Account # 1New Qty Billed – Original Qty BilledUnit Cost * (New Qty Billed – Original Qty Billed)
Inventory Account # 2New Qty Billed – Original Qty BilledUnit Cost * (New Qty Billed – Original Qty Billed)
. . .. . .. . .
Inventory Account # xNew Qty Billed – Original Qty BilledUnit Cost * (New Qty Billed – Original Qty Billed)
Inventory Adjustment Net Changes in Inventory Valuation

The quantity changes for Adjusted Received Only and Adjusted On-Order entries will be tracked, but no GL entries are adjusted.

Adjusting part costs can be done in several ways. One method is to edit the part and manually adjust the unit cost. This method works for a few pricing changes, but quickly becomes tiring when adjusting your costs en masse (such as when putting in your costs initially). During these times, you will want to take advantage of the “Adjust Part Cost” utility (from the main menu, under Vendors).
The Adjust Part Cost utility displays parts with costing enabled and allows you to adjust the cost from one screen. When you save your changes, Control adjusts the part costs. If inventory is enabled for the part (which is only permitted on Fixed Cost parts), the inventory valuation will be affected and the following GL entries made will be:

Account Quantity Debit Credit
Inventory Account # 10Qty Billed * (New Unit Cost– Original Unit Cost)
Inventory Account # 20Qty Billed * (New Unit Cost– Original Unit Cost)
. . .. . .. . .
Inventory Account # x0Qty Billed * (New Unit Cost– Original Unit Cost)
Inventory Adjustment Net Changes in Inventory Valuation


purchasingcycle.jpg
Control contains extensive purchase order capabilities and tracking. Purchase Orders use the following pre-defined statuses:
* Requested
* Approved
* Ordered
* Closed
In addition, each line item in a PO may have its own status. The line item statuses will automatically change when the PO status is changed if there has not been other activity on them. For example, if you have posted a receiving document against a PO, the lines of the PO may be set to Partially Received and will not change when you change the PO status.
When a PO is changed to Ordered, the On-Order Inventory level for inventory parts are automatically adjusted based on the PO.

When you receive inventory without a bill, you will create a receiving document (RD) to record this receipt. If the item is an inventoried part, you have the following options:

  1. Add to Received Only and reduce On-Order Inventory Levels. (Default when creating a new RD by cloning an existing PO.)
  2. Add to Received Only only. (Default when creating a new RD from scratch.)

Based on your selection for each line item, the appropriate action will be taken.
Since there is not a bill (and corresponding value), no GL entries are created by Receiving Documents. However, the On-Hand and Expected quantities will change based on the RD created above.

When you enter a bill that contains an inventoried part, Control will adjust the inventory levels and (optionally) the average cost. The options available are dependent upon the setup of the part, as is explained below.
If the inventories part has an inventory balance for either On-Order or Received Only, the following options are presented:

  1. First reduce Received Only, then On-Order. (Default when converting from a RD.)
  2. First reduce On-Order, then Received Only. (Default when converting from a PO.)

Based on the choice, the new inventory is first transferred from a status of either Received Only or On-Order, then from the other status (if balances remain). In all cases, the Billed Quantity will be increased by the quantity of the bill.
For a part with inventory enabled (and therefore a fixed average cost), posting a bill automatically adjusts the inventory level. Additionally, the following options are available to automatically adjust the current average cost:

  1. Adjust the average cost.
  2. Do not adjust the cost. (Note: Inventory is added at the current average cost.)
  3. Adjust the average cost for increases only.

The default for these options can be specified in Accounting Setup.


Option #1: Adjusting the average cost.


The new average cost is calculated as:

Where BilledCost is the total cost of that part in the bill. The associated GL entries would be:

Account Quantity Debit Credit
Inventory Account
Inventory Account0
Inventory Adjustment0
Accounts Payable

Option #2: Using current average cost.
The new average cost doesn't change, so we must adjust for the price of the part in the current bill when recording it.

Account Quantity Debit Credit
Inventory Account
Inventory Adjustment0
Accounts Payable

Option #3: Adjusting the average cost for increases only.

Under this method, the calculation of new average cost is determined. If this results in an increase in the average cost, Option #1 applies. If this results in a decrease in the average cost, the current cost is maintained and Option #2 applies.

  • For a part without inventory enabled but with a fixed cost, the following options are available when posting a bill: - Adjust the standard cost. - Do nothing. (default)
  • For a part with a variable cost, the only options available when posting a bill is:
  1. Do nothing. (default)
  • For custom parts, expenses, and other line item types__, no cost adjustment options apply.


You could leave a comment if you were logged in.