Materials Expenditure

On this page you can see information about the spent items by types of expenses and period. The screen is divided in three main sections: Header (1), Filter (2) and Results (3).


Within the Header (1) section you can see the title of the page.

Within the Filter (2) section you can filter the results in the Results (3) section by specific criteria like:

Column Meaning
Date Range Periods for expenses of warehouses
Company Filters by company (required field)
Warehouse Filters by warehouse
Spent During Period Filters by type of expenses and period
Type of Expense – Total / Sales / Production / Waste / Inventory Shrinkage / Other
Daily/Weekly/Monthly – basis for aggregating quantities and values
Groups Filters by group of the item
Brands Filters by brand of the item
Search Combined field for manual search of an item by ID, Name, Description, Brand or Group.

The Results (3) section is grouped in three tabs Items, Groups and Warehouse.

Results without expenses during period

The information is shown in columns that are described in the table below:

Column Meaning
ID ID of the item
Name Name of the item
Brand Brand of the item
Sales Qty. Sales quantity of the item
COGS Self-cost of the item
Production Qty. Quantities nested in the production of merchandise and materials
Production Cost Self-cost of the quantities nested in the production of merchandise and materials
Waste Qty. Quantities of the wasted items
Waste Cost Self-cost of the quantities of the wasted items
Inventory Shrinkage Qty. Quantities of inventory shrinkage
Inventory Shrinkage Cost Self-cost of the quantities of the inventory shrinkage
Other Qty. Quantities of other expenses on the items
Other Cost Self-cost of others
Total Quantity Total quantity spent
Total Cost Total Self-cost of the quantity spent



Exemplary results with expenses during period

Column Meaning
Total Quantity 01.2019 Total Quantity spent on 01.2019
Total Cost 01.2019 Total self-cost of the spent quantity on 01.2019
Total Quantity 02.2019 Total Quantity spent on 02.2019
Total Cost 02.2019 Total self-cost of the spent quantity on 02.2019
Total Quantity Total spent quantity
Total Cost Total self-cost of the spent quantity


 You also have an additional button:

Button Mouse over text Meaning
Record Item Allows you to view the Record Item
Редакция