Unit quantity on a goods item

Unit quantity is the field on the goods item's form, in Stock Management - Stocks - open the goods item, right next to the MU field. It tells you how much one unit of the goods you buy contains: a 0.7 L bottle of rum has MU = L and Unit quantity = 0.7, while a beer you sell by the piece has MU = PC and Unit quantity = 1. Below the two fields, Ebriza spells out in plain words what you have configured, as “I buy Jim Beam by 0.7 L”. This article is written using goods as the example. On a raw material, some fields behave differently — see the last section — but the rule about changing the UOM and unit quantity of an item that has stock movements, as explained in the Frequently Asked Questions, is identical for every item type.

Warning: Any mistake in this field will result in incorrect stock! Read the details below carefully.

You have 2 options here, depending on how you want your stock to be displayed. If you want to see exactly how many pieces you have in stock, then you most likely sell 1:1 - for example, a tracksuit, a device, or a beer, which means selling by the piece. In this case, you enter the value 1 in Unit quantity because you sell by the piece, and the weight of the tracksuit, device, or beer is irrelevant for stock tracking.

But if this goods item is used to prepare other products, you can track in detail the quantities used or possible losses by entering the total quantity of your goods item (MU - KG / L), for example, “0.5” for a 0.5 KG pack of coffee, or “0.7” for a 0.7 L bottle of rum.

Two things happen automatically. If you choose MU = PC, Ebriza automatically fills in 1 for Unit quantity and does not allow you to enter anything else - so you do not have to type 1 yourself. And although ML and G also appear in the MU list, for a goods item whose name contains the volume or weight, use L and KG: Ebriza normalizes “330 ML” to 0.33 L and “40 G” to 0.04 KG, so choosing ML or G will be rejected when saving, with the message “The measuring unit or the unit quantity does not match the stock name.”

a) BOTTLED / CANNED BEER, WATER, SOFT DRINKS: For drinks that you sell exclusively by the piece, enter the figure 1 in UNIT QUANTITY (and set MU to “PC”). Then, in Nomenclature - Products - open the product - Recipe, on the goods item's line, enter the figure 1 in the Quantity column as well. This way, the stock will be correct because with every sale, one piece will be deducted from your goods item (1-1).

b) WINE, VODKA, RUM, WHISKY BOTTLES — drinks you pour by the glass, even if you also sell the whole bottle: the goods item stays in litres, and the recipes are built on the RAW MATERIAL

For drinks from which you take a quantity on every sale, the goods item is configured by volume: set MU to L (or KG) and enter in UNIT QUANTITY how much one purchased unit contains — 0.75 for a 0.75 L bottle of wine, 0.7 for a 0.7 L bottle of rum.

This is the step that is most often missed: the recipe of a product of type "Contains recipe" accepts only RAW MATERIALS, never goods — the search in "Product recipe" does not even offer goods items. So besides the goods item you also need a raw material with the same name, and the two are linked when you receive the invoice: on the goods receipt (NIR) line you first fill in the "Goods receipt" column and then, on the SAME line, the "Raw material receipt" column as well. One single reception then brings in both the goods item (for the purchase record) and the raw material (for recipes). The steps
are in the article "Create Reception Entry Note", section 2.2.

Example: on a 0.7 L bottle of whisky:

Stock Management - Stocks - the goods item "Jim Beam 0.7 L": MU = L, Unit quantity = 0.7 On the NIR, on the same line: the raw material "Jim Beam", also in L

Then, in Nomenclature - Products, create one product for each way you sell it, both of type "Contains recipe", and put the RAW MATERIAL in each recipe with the right quantity:

the product "Jim Beam 0.1 L" (the glass) - in the recipe, the raw material "Jim Beam", quantity 0.1
the product "Jim Beam 0.7 L" (the whole bottle) - in the recipe, the same raw material, quantity 0.7

This way, selling a glass deducts 0.1 L and selling a bottle deducts 0.7 L, from the same stock. You can create as many products as you like on top of the same raw material.

One thing to avoid: if you also sell the whole bottle, do NOT set it up as a product of type "I sell it as I buy it" over the goods item. On a NIR line where you filled in both columns, the stock movement is recorded against the RAW MATERIAL — the goods item remains the link to the purchase, but it gets no balance of its own on that line. A product built over the goods item would deduct an item the reception never fed, and would go negative. Both the glass and the whole bottle are sold from the raw material, only with different quantities in the recipe.

If you sell ONLY the whole bottle, by the piece, you need none of the above: leave the goods item on MU = PC and Unit quantity = 1, do not fill in the "Raw material receipt" column, and the product can be of type "I sell it as I buy it", linked directly to the goods item. See option a) above.

The complete steps for the "I sell it both by the bottle and by the glass" case are in the article "How do I receive and sell a drink that I sell both by the bottle and by the glass".

c) COCKTAILS, FOOD: c) COCKTAILS, FOOD: For products whose preparation involves several ingredients, in Nomenclature - Products - the product (of type "Contains recipe") - Product recipe, you will select all the ingredients one by one, entering the specific quantities. The ingredients are raw materials, not
goods: each one comes from the "Raw material receipt" column of the NIR, on the line of the corresponding goods item. Example: Cuba Libre is prepared with 0.04 L of rum and 0.15 L of cola.

Example: Cuba Libre is prepared with 0.04 L of rum and 0.15 L of cola.

After a drink is sold, 0.15 L will be deducted from the 2 L bottle of cola and 0.04 L from the 0.7 L bottle of rum.

Everything written above refers to goods. For a raw material — for example, one that you create directly from the product's recipe — you only choose the measuring unit (anything other than BOX), and the quantity used in the product is entered in the recipe, not on the raw material's form. The rule where the name dictates the measuring unit does not apply to raw materials: you can name a raw material “Oil 0.7L” and still give it any measuring unit you want, without the application stopping you.

Careful: that is the only rule raw materials are exempt from. The other rule, the one in the Frequently Asked Questions — an item that already has movements in stock management can no longer change its MU or unit quantity — applies to goods and raw materials alike.

On a stock item you produce (a raw material with a sub-recipe), the unit quantity has one more role: it states how many units one batch yields, and it is the divisor in the production cost. The cost a production records is the sum of (each ingredient's average purchase cost multiplied by its quantity in the recipe), divided by the produced stock item's unit quantity. If you leave it at 1 on an item that is produced in batches of 24, the cost of the whole batch will be recorded against a single piece. Details and examples are in the article “How I make production?”

As with any other movement, a production that has already been recorded keeps the unit quantity it had at that moment and is not recalculated if you change the field later: only later productions will use the new value.

Q: Why do I get the error “Value inconsistent with the goods name!” when I choose the measuring unit?

A: The goods item's name dictates the measuring unit. Ebriza reads the weight or volume from the name and infers the MU and unit quantity from it: “330ML” means MU = L and unit quantity = 0.33, “0.7L” means L and 0.7, and “40G” means KG and 0.04. If you choose an MU that does not match what the name says, the field is rejected with the message above, and when saving you get “The measuring unit or the unit quantity does not match the stock name.”

Careful: It is not enough to add “PC” at the end of the name. “Lager Beer 330ML PC” still contains “330ML”, so Ebriza still infers litres and rejects PC. The volume must be removed from the name completely.

Q: How do I change the measuring unit or the unit quantity of an item I already have? (For example, I want to move it from L to PC.)

A: It depends on whether the item has stock movements recorded or not. There are two situations, with two different procedures. The condition is the existence of movements, not the item type: the rule applies identically to goods, raw materials, consumables, and packaging.

If the item already has NIRs (goods receipt notes), sales, consumption through production or a recipe, inventories, resets, transfers, or productions, Ebriza refuses the change with the message: “You can't change the MU or the unit quantity of a stock item that has movements in stock management.” The block is intentional: the movements already recorded are saved in the old unit and would become incorrect if the unit were changed now. It cannot be forced and cannot be unlocked by the support team, and it stays in place for as long as those movements exist — it does not expire. It applies the same whether the item is a goods item or a raw material. The solution is to create a new item:

The old item remains in the account with its history, and that is how it should remain. Do not try to delete it: deletion is refused anyway as long as it has a quantity in stock or appears in a recipe.

Two particular situations: if the item has only stock resets, the change is allowed after all; and a goods item linked to a raw material (bulk goods) is refused even with no movements at all — in this case, go straight to Option 2.

Q: Can I edit the unit quantity or the measuring unit of a raw material that is already used in production?

A: Yes, but only if that raw material does not yet have movements in stock management. If it already has movements, the application refuses the change, exactly as it does for a goods item. A raw material gets movements from a NIR (raw material reception), from consumption through the recipe when products are sold, from production, from inventories and resets, and from transfers between locations — so a raw material with active production on it is almost certainly blocked. In that case, the only way forward is Option 2 above: create a new raw material with the correct measuring unit and unit quantity from the start, and replace it in the recipes of the products that use it.

Tags: [unit quantity goods, what do I enter in the unit quantity field when I add a goods item, new raw material, measuring unit, units, stock management, recipe, how do I configure the goods item correctly]