In the Stock Management Report, stock movements made during the selected interval will be generated.
The Inventory Report is a stock balance report: for each item, it shows the opening balance, incoming stock, outgoing stock, and closing balance for the selected period. It is not a list of documents — the “Incoming” section tells you how much of each product was received, not which NIRs were issued.
If you want a list of receipts for a specific period (NIR number, supplier, date, and value) that you can export to Excel, use the NIR Summary Report under Reports - Accounting. See the Accounting Reports article.
Want to see what goods you bought from a specific supplier?
If you need the list of goods bought from a supplier, with the quantity and value for each product, you can get it for free from the Stock management report, filtered on that supplier's stocks:
1. Go to Reports - Stock management report.
2. Click the blue "+ Add filter" button. The stock selection window opens.
3. In the "Filter by provider" field, choose the supplier, then tick all of its stocks.
4. Give the filter a name and click Save. The filter stays saved and you can use it again next time.
5. Choose the period you want and run the report.
6. The "Entries" section shows each item, with the quantity and value from the invoice. You can export the report to Excel from the 3 dots in the top right corner.
Note: the filter selects goods, not invoices. If you also buy an item from another supplier, the entries from that supplier also appear in the "Entries" section.
Other options, depending on what you need:
• NIR summary (Reports - Accounting), with the "Supplier name" filter: the list of receptions from that supplier, one row per NIR, not per product.
• The "Purchases from suppliers" report: the total bought from each supplier over the last 7 days. It gives you the total per supplier, not per product.
• The Insights app (from the Marketplace), if you want a clean list strictly for a single supplier. Insights is a paid app with a 15-day trial.
To generate the Stock Management Report, access the menu point Reports - Management Report.
Select the interval for which you want to generate the report, and click on the three dots in the top right corner to generate the report in your desired format (PDF, Excel, or CSV).
From the same three dots, you also have the option to choose whether to include or exclude resets based on the inventory or manual stock resets in the report.
Once the report is generated, you will see that it is divided into three types of stock movements (initial stock, entries, and exits), which are displayed in eight columns:
The eight columns are divided as follows:
Column 0 - item number
Column 1 - type of modification
Column 2 - item name (including quantity and unit of measure)
Column 3 - item type (goods or raw materials)
Column 4 - modified quantity (data appears only for entries and exits)
Column 5 - existing stock quantity (initial balance: stock existing at the beginning of the interval; entries: quantity remaining after entry; exits: quantity remaining after the stock exit)
Column 6 - purchase value without VAT of the existing stock (for initial balance and exits, it is calculated using the weighted average cost method; for entries, the purchase value from the invoice is displayed)
Initial Balance
This is the balance you had at the start date of the interval (for example, in the picture below - date 04.08.2020 23:59).
At the end of the initial balance movement type, a total of the purchase value of all goods (weighted average cost) is displayed.
For the initial balance movement type, all existing goods in the company are displayed.
Entries
All entries made during the selected interval are displayed.
Entries made through transfers from another management to the one from which the report is generated are displayed.
At the end of the entries movement type, a total of the purchase value of all goods (invoice value) is displayed.
Exits
All types of exits (sales, consumption receipts, exits through transfer) are displayed.
At the end of the exits movement type, a total of the purchase value of all goods (weighted average cost) is displayed.
[tags: stock report, stock movements, management tracking, entries, exits, initial balance, purchase value, goods, raw materials, purchase cost,supplier, goods bought from supplier, products purchased from supplier, purchases per product]