In the Stock Management Report, stock movements made during the selected interval will be generated.
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]