Skip to main content

Stock history

Written by Andrei

Stock Management History helps us to track all stock movements that have taken place, they are recorded in real time.

History is a list of individual stock movements, one row per movement. It is not a balance: it does not show an opening balance, receipts, issues and a closing balance per item.

Stock Mangement History can be accessed from the Stock Management application, from the section entitled History:

In History we have predefined search filters at the top of the page, which help us, by clicking on any of them, to search the history after a certain stock move.

The stock movements recorded in the history are: Creation, Sale, Input, Reset, Inventory, Input / Output Transfer, Consumption Voucher, Input / Output Production, Voucher canceled, Protocol, Donation.

A transfer between locations appears here as two movements: a Transfer out on the source location and a Transfer in on the destination location, each with its own location. If you have the Insights app and want both locations on the same row, write to us and we will add the Source location and Destination location columns to your stock-movement report.

The Creation movement, marked with a purple badge, shows the moment a stock started to exist at a location: when you add a new stock from Stock Management - Stocks, when you add stocks through the product file import, or when you add a new location. Its quantity is 0 and it is only the opening record of the stock, not an operation someone made. Do not confuse it with a Reset (red badge), which means an actual change to the quantity of an already existing stock.

You can see only these rows by choosing the Creation filter. The Reset filter shows only actual resets.

For an even more detailed search, we need to click on the magnifying glass icon at the top right of the page.

Thus, we can search by the name or SKU code of a stock and / or a stock move.

The price shown on a Receipt movement, generated by the GRN, is the price per the stock item's inventory unit of measure, not the price shown on the supplier's invoice line: it is the unit price on the invoice divided by Quantity per unit.

The printed GRN, on the other hand, shows the price based on the invoice. The two figures are different by design and do not mean that the invoice was imported incorrectly.

The Receipt movement is recorded using the receipt date from the GRN, not the invoice issue date. Therefore, search for it by the stock item's name rather than within a date range around the invoice date — otherwise, you may not find it even though everything is correct.

We can filter your search over a specific time period, as well as over a specific location.

Why does Stock show one quantity while the last balance in History shows another?

Almost always, you searched differently on the two pages, and both figures are correct. Look at the "Name: …" filter shown under the search bar on each page.

In the History search you can filter in two ways:
​

  • Item picked from the list. Type the name, wait for the list that appears under the search bar, and pick the item from it. The filter shows the name with the type in brackets, for example "Name: Milk (Raw material)". You see exactly that item, with all its movements.

  • Typed text. Type some text (part of the name or the SKU code) without picking anything from the list. The filter shows only the text, for example "Name: milk". You see the movements of every item whose name or SKU code contains that text. If you have both a merchandise item and a raw material with a similar name, they are mixed together. Movements recorded under a different name or SKU code do not appear.

The "Remaining qty" column on a History row is the balance of that row's item right after that movement. It is not necessarily the current stock shown in Stock: with a text filter, the last row may belong to another item, or it may be a movement followed by others that do not match the text.

How to compare correctly:

  1. In Inventory → Stock, type the name in the search and pick the item with the right type (Merchandise or Raw material) from the list.

  2. In Inventory → History, click the magnifying glass, type the same name and pick the same item, with the same type, from the list. Also check the location and the calendar range.

  3. On the last row (the most recent movement), "Remaining qty" should equal the quantity in Stock.

This is not a browser problem: clearing the cache or using an incognito window changes nothing here. If the figures still differ after you searched the same way on both pages, write to us on chat with the item name, its type and the location.

What the History export contains

From History you can export the list shown on screen, with the filters you applied (period, location, stock item, movement tags), by clicking Export and choosing Excel or CSV.

The export is also how you print a stock movement that has no document of its own, for example a stock reset. Filter History on the item (picked from the list), on a period that includes the date of the movement (by default only the last 7 days are shown) and on the movement's tag (for example Reset), click Export, choose Excel or CSV and print the file. The export from Stock Management -> Stock does not replace this: it shows today's stock, not the movement on that date.

In the exported file, right after the Name column you have the SKU column (the stock item's SKU code) and the MU column (the stock item's unit of measure: PCS, KG, G, L, ML, etc.). The unit in the MU column applies to every quantity and price on the row: the quantity changed, the remaining quantity, the unit price and the average acquisition cost (these are in RON per that unit). For example, a row with MU = G and a quantity of -4 means 4 grams taken out of stock, not 4 pieces or 4 kilograms.

Quantities and prices are still numbers, so you can sum them in Excel as usual.

If you use an Excel sheet or formula that reads the History export by column position, check it: the SKU and MU columns were added after Name, so every column after them has moved two positions to the right.

Accessible options for every stock move

There are edit / delete / view options on each stock move, depending on its type. The options are accessible from the 3 dots on the right of the row.

Creation movements are an exception: they cannot be edited and cannot be deleted, because they are not a stock operation but the moment the stock started to exist at the location. From the 3-dot menu of a Creation row you can filter the history by that stock, open the stock's page with Edit, or view the stock's audit.

Also from the history you can find and edit / delete consumption receipts. Click here for more information on consumption receipts.

Click here for details on tracking the average cost of acquisition (CMP) in history.

A “Reset” You Didn’t Perform: The Automatic Entry Created When a Stock Item Is Created

When creating any new stock item - merchandise, raw material, consumable, or packaging - Ebriza automatically records a Reset movement for that stock item, with a quantity of 0, one for each inventory location, using the exact date and time when the stock item was created. No one actually performed a reset: the movement appears automatically in History, the moment you save the stock item.

How to recognize it:

  • it is the first movement in the history of that stock item;

  • it has a quantity of 0 and appears for each inventory location, at the exact same second;

  • it is not linked to a reset document - from the three-dot menu, you cannot access a reset document that could be cancelled.

This movement cannot be deleted and should not be deleted. It is not the cause of a stock issue, and the option to delete a reset does not apply to it because there is no reset document behind it.

Why Does a Newly Created and NIR-Received Stock Item Show a Quantity of 0?

Reset and Inventory are absolute movements: they do not add to the current balance, but instead set it to their value, regardless of what came before. The balance you see is the quantity from the latest movement in chronological order.

The stock entry generated by a NIR is recorded using the receipt date from the invoice, not the time when you clicked Generate NIR, while the stock creation entry uses the exact time when the stock item was created.

Therefore, when you create the stock item on the same day you make the receipt - which is the usual case, since the stock item is created precisely so it can be added to the NIR - the stock creation entry becomes the latest movement chronologically, sets the balance to 0, and hides from the screen a receipt that was actually recorded correctly.

What to Do in This Situation?

  1. Do not delete the Reset movement - it is the automatic entry created when the stock item was created.

  2. Check the NIR entry in History: the receipt is recorded correctly, with the quantity and date from the document. You do not need to recreate the NIR.

  3. Bring the quantity back to the actual value by performing a stock reset today (Inventory Management → Stock → select the stock item → Reset Stock). Since this is a movement dated today, it becomes the latest movement chronologically and sets the correct balance.

  4. The average purchase cost (CMP) remains the one brought in by the NIR - the reset only changes the quantity; it does not modify the purchase price.

  5. If this happens with every newly created stock item, or there are too many items to correct one by one, contact us via chat with the NIR number, inventory location, and affected stock items.

The daily production report is generated from History

Important: the production tags only contain data if production is enabled, meaning the raw material with the sub-recipe has at least one location selected under "Produced in locations". Production is not enabled by default. In that case the "Production Output" and "Production Input" tags are empty: a sale deducts the recipe and sub-recipe ingredients directly, and the movement appears as "Sale" on each ingredient. The semi-finished item stays at 0. For raw-material consumption from sales, select the period, select only the "Sale" tag and click "Export". To see which raw materials each product is made of, use Configuration → Products → the down arrow on the right → "Export detailed products". The steps below apply only if production is enabled.

There is no menu item called “Production Report,” but the report exists: it is generated from History, filtered by the desired day and by the production movement.

How to generate it

  1. Go to the Inventory app, History section.

  2. Click the magnifying glass in the top-right corner, select the location, and set the calendar to the day you are interested in. The time range can be set down to the minute, so you can cover exactly one day.

  3. Click the colored tag below the search bar that corresponds to the production movement. One click applies the tag, a second click removes it, and multiple active tags are combined.

  4. Click Export in the page action bar and save the exact filtered list — this is the format you can send to your accountant.

The two production tags and what each contains

  • Production output: finished products obtained — one row for each production recorded on that day, with the quantity produced and its cost.

  • Production input: ingredients consumed — one row for each ingredient, with the quantity deducted from stock.

The names of the two tags are given from the perspective of the production document, so they read the opposite way from the stock movement. If you want “what I produced, how much, and at what cost,” the tag you need is the one for finished products; if you select both tags, you get the full production for the day, with the ingredients consumed alongside the products obtained.

History is a standalone page in the Inventory app, alongside Stock. There is no history screen inside the Stock page. If you are interested in a single item, on its row in Inventory → Stock, open the three-dot menu and select “Show history ‘item name’”. This opens the same History page in a new tab, filtered by the item's SKU code. If other items have a similar SKU code, their movements may appear too; to see a single item, pick it from the list under the search bar (see "Why does Stock show one quantity while the last balance in History shows another?")."

The Inventory Report (Reports → Inventory Report) is not a replacement for this: production appears mixed in with all other stock entries and exits for the selected period, rather than being isolated to a single day.

[tags: stock history, how can I see what changes have been made lately, stock sales, consumption receipts, where to find consumption receipts, stock decreases, resets, exit transfer, can't find the entry, entry not showing, where to see NIRs made, negative stock after receipt, not showing in stock after receipt, creation, stock creation, purple badge, why does a new stock show as reset, new stock shown as reset, creation filter, new location reset]

Did this answer your question?