Formulas

If a company is engaged in production, formulas can be used to simplify the entry of production. A formula defines the composition of a specific finished product, specifying the raw materials (components) to be used and their quantities. Each formula is linked to one specific finished product – it is not possible to include multiple different finished products in a single formula.

Warehouse -> Formulas

When adding a formula, inventory is not checked, so the products included in the formula do not need to be in stock. Inventory is checked when adding a production.

Only warehouse items can be used when entering a formula. If a required item is not available, it must first be added under Warehouse -> Items.

We recommend creating a formula for one unit of  the finished product. When entering a production, the quantity of finished product can be adjusted, and the raw material quantities will be automatically recalculated. The formula can also be modified or deleted after it has been used in production.

General information panel

  1. Formula name – the name of the finished product for which the formula is created.
  2. Formula description – (optional) a more detailed explanation of the finished product or the formula.
  3. Target warehouse – the warehouse where the finished product will be received during production. This can also be specified when entering the production.
  4. Active – indicates whether the formula can be used in production.
Formula parts
Raw materials panel

  1. Item – the raw material item code used for the finished product. Ensure you select the item from the correct warehouse.
  2. Contents – the item description from the item card; it can be modified here if necessary.
  3. Unit – the item unit as defined on the item card.
  4. Quantity – the required quantity of raw material for the finished product specified in this formula.
  5. Delete (cross) – click to remove the corresponding raw material line.
  6. Add new line – adds a new raw material line to the formula.
Product panel

7. Item – the finished product item, preferably added in advance under Items.
8. Contents – the item description from the item card.
9. Unit – the item unit as defined on the item card.
10. Quantity – the quantity of the finished product.

Example
In the General information panel, enter the formula name and select the warehouse where the finished product will be recorded.

In the Raw materials panel, the components of the finished product (raw materials) are listed along with the quantities needed to produce one finished product.
The item cards should be created in advance under Warehouse -> Items.

In the Produce panel, select the finished product item and set the quantity to 1. The raw material quantities listed above are entered for one unit of the finished product.
When entering a production, simply adjust the quantity of the finished product, and the system will automatically recalculate the raw material quantities.

Save the formula. If it is correct, a green notification will appear in the page header.

Saving the formula does not affect warehouses or production, so no financial transaction is created for the formula.

If you have any additional questions, please write to us at support@simplbooks.ee

Was this article helpful?

Related Articles

Leave A Comment?