Material cost tool

Filters

• Project – select project
• Stage – select stage

Options

• Generate Excel – Generate an Excel file from the filtered rows.
• Generate inv movement – Create a stock movement for the rows marked with a checkmark in the “To move” column.
• Generate – Display the filtered rows.
• Print – Print the filtered rows.
• Open in Excel – Open the filtered rows in Excel.
• Save row conf. – Save the row configuration. Click after configuring the view to your preference (hiding/showing desired columns, adjusting column widths, etc.).
• Restore row conf. – Restore the row configuration to its default settings.

Columns

• Allocated qty – Rows where the required quantity has been transferred are displayed in green.
• Wastage – Rows where more than the required quantity has been transferred are displayed in red.
• To move checkbox – Check the box if you want to move the row. The checkbox is automatically selected when you enter a quantity in the “To move qty” column. When the checkbox is selected, the “To move qty” column is automatically filled with the maximum available quantity (based on stock availability).
• To move qty – Enter the quantity you want to move. Entering a quantity automatically selects the checkbox in the “To move checkbox” column. Selecting the checkbox in the “To move checkbox” column automatically fills the “To move qty” column with the maximum available quantity (based on stock availability). Automatically filled quantities can be manually overwritten.

Creating an inventory movement

1. Select the desired rows by checking the box in the “To move checkbox” column and/or enter a quantity in the “To move qty” column.
2. Click “Generate inv movement”.
3. Clicking the button opens a window where you can select the warehouse to which you want to create the inventory movement.
4. The inventory movement form will open. Confirm and save it.