Skip to main content

How is the NIR surcharge calculated?

Written by Andrei

NIR is the only place in Ebriza where you can see the sale price of a stock item

On the NIR, you have the sale price both without VAT and as a retail sale price, with VAT included, next to the markup columns. It is the only document in the application that displays the sale price of a stock item: stock reports (Analytical Stock Balance, Stock Management Report, Inventory, stock history, exports) always value stock at purchase price, using weighted average cost, and cannot be switched to sale price.

The sale price - and, along with it, the markup - appears on the printed NIR only under the conditions below. The sale price is not entered on the supplier invoice in Costs, nor on the NIR: it is set on the product, in Product Catalog (Nomenclator) → Products → the product → the Sale price field.

If you need the stock value at sale price for accounting, download the NIRs for the respective goods from Inventory - Receptions, Print NIR.

When you create a product in the Nomenclature, Ebriza will calculate the commercial markup (percentage) based on the price you set for this product, at sale, and the average purchase cost of the goods or raw materials in its recipe.

If at the time of adding the product there are no entries yet for the goods/raw materials in the recipe, the markup will not be calculated and will display 0.

Commercial margin is calculated and displayed on the NIR only for Goods (Marfă) lines. Raw materials, consumables, and packaging do not have a margin on the NIR — the columns remain blank or 0, and this is not an error.

For the margin to appear on a goods line, all three of the following conditions must be met:

  • The goods are associated with a single sale product in the Product Catalog, and in that product’s recipe the goods are the only ingredient (a “sold as purchased” product). The sale price and the markup then appear automatically on the printed NIR. If the goods are part of a recipe with several ingredients (a prepared dish), the system cannot determine a sale price for them, and the markup stays 0. If the same goods are used by several sale products, the printed NIR is not left blank: an (i) icon appears in the Retail sale price cell. Clicking it opens the window “Several products use this stock. Choose the sale price to apply” (in the app: „Mai multe produse folosesc acest stoc. Alege prețul de vânzare de aplicat”), where you pick the price of one of those products. Only then are the markup columns filled in.

  • The sale product has a selling price set. The selling price is set only on the product, in Product Catalog (Nomenclator) → Products → the product → the Sale price field, or with Bulk edit (Editare multiplă) from the product list. There is no field on the NIR where you can enter the selling price: the NIR records only the reception from the supplier, and the margin is calculated automatically from the price set on the product.

  • The goods have recorded purchase entries. Without purchase entries, there is no purchase price from which the margin can be calculated, so it is displayed as 0. This is the most common reason why the margin is not calculated on any NIR.

There is no condition that the goods must have “a single sale price”. What matters is how many sale products use the goods. If only one product uses them (and they are the only item in its recipe), that product’s price appears automatically. If several products use them, when you print the NIR you choose from the (i) icon which product’s price to use on the document.

We created the product in Nomenclature Fanta 0, with the Fanta Zero merchandise in the recipe, we enter the invoice in Costs, then we add the NIR.

I bought 100 pcs. for 2 Ron each. We save or print the NIR. ​

We notice, if we go back to the Nomenclature, that the data regarding the purchase cost and the commercial markup have been updated.

What does the NIR display?

Column 9 (Commercial Add-on%) will show the percentage of the commercial addition for a unit sold, as in the nomenclature, respectively 358.72%

Column 10 will calculate the product between the unit price without VAT and the commercial addition, respectively 2RON * 358.72% = RON 7.17 (representing the commercial addition without VAT / unit)

Column 11 adds the purchase price without VAT with this addition / unit, respectively 2RON + 7.17RON = 9.17 RON (selling price, without VAT), as it is also displayed in the nomenclature.

Column 12 calculates the VAT related to the addition / unit, respectively 7.17 RON * 9% = 0.6453 RON, which it rounds to 0.65 RON.

The sale price on the printed NIR

There is no sale-price column for you to fill in. Neither the supplier invoice line in Costs nor the table you generate the NIR from (the Goods receipt and Raw material receipt columns) has a sale-price column. There you only work with quantities, purchase price and VAT. The markup is not calculated on the invoice.

The retail sale price and the markup appear only on the printed NIR (Inventory → Receptions → Print NIR), in the markup columns (9–12) and the retail sale price column. They are calculated from the price set on the product and cannot be entered or changed on the NIR.

If the product does not have a sale price yet, set it in Product Catalog (Nomenclator) → Products → the product → the Sale price field (or with Bulk edit from the product list). Then print the NIR again: the price and the markup appear automatically.

If the same goods are used by several sale products, an (i) icon appears in the sale price cell. Clicking it opens the window “Several products use this stock. Choose the sale price to apply” and you pick one of those products’ prices. You cannot type a new price, and the choice is not saved anywhere: it only affects the sale price and markup shown on the NIR you are printing.

If the Margin Still Does Not Appear

If all three conditions above are met and the margin is still not calculated, it is no longer a configuration issue with your account. Contact us via chat with the NIR number and the affected goods, and we’ll investigate it for you.

Did this answer your question?