A raw material can be created and added to a 'Material Set'.
Material Sets' are then linked to pricing component lines within operations, so they are included in quoting for cost and inventory purposes.
This is managed from ‘Material Admin’ under ‘Equipment’ in the ‘Configure the Factory’ screen.
Add new Material
New raw materials can be added through the Materials Admin screen. To get to this screen go to Admin -> Factory -> Configuration -> Equipment -> Materials Admin and click the ‘+’ button at the top of the page.
A material creation pop-up box will appear. This is where you configure the item details and pricing:
In this example we are creating a roll of gloss laminate:
Some fields to note:
Maximum code length is 100 characters
- Inventory Location - Choose a location for the material. This can be something general like the name of your company or if you have a full inventory warehouse configured, you can specify the exact location where this stock will be stored.
-
Code - A code will be auto generated by IQ but it is always best to use a code that actually relates to the material as this 'code' is what you select inside the operation component screen to link so the clearer the name the easier it is to select later
- Default Supplier - Select the default supplier the item is ordered from. Once the item has been created, you can add additional suppliers from within the inventory section of IQ.
- Owned by - You can specify if the material is owned by the 'Factory' (you), 'Supplier' or 'Customer'.
- Weight - You can enter a weight for the item 'per unit'.
- Quantity on Hand - If you already have stock on hand when you create the material, you can enter the qty here.
Checkboxes:
- Awaiting Delivery - This is just a flag you can check on if when creating the material and say the customer is sending it directly to you, you can mark it as awaiting delivery and you can filter this on the inventory screen for tracking purposes.
- Manage Stock Levels - Check this on if you want to manage the stock levels of the material. This allows you to do a 'pick' on the item from within a jobs 'Stock Pick' screen.
- Active - Turns the item from 'Active' to 'Inactive'.
At the top of the screen are some additional tabs:
Modifying Material Sets
Material Sets - When a material is created, a material set is generated using the item's code.
A material must be linked to at least one material set. Material sets are linked in pricing operation components:
If an operation requires multiple materials, you can create your own material set (enter a name and 'add').
You can then go into multiple materials and add that new material set to its list.
One material can be linked to as many different materials sets as you require.
Price Modifier - If you want the materials on this set to have a default 20% added to their price, you can enter '1.2' into this field:
Quantity Modifier – This field allows you to set the quantity per item of materials required for the material set. In the below example, we have a material setup to be ordered ‘Per Unit’:
On the material set, we have configured ‘packs’ of screws.
The quantity required can be set/selected depending on the item being quoted.
Against the operation component, we have 3 options linked to each material set:
On the quote you can select the required option:
The material will multiply per unit ordered and display throughout printIQ:
Calc Types
Sheet area {AreaLongUnitName}
Area of All Sheets, ignoring press spoils
Finish area {AreaLongUnitName}
Area of the finished job
Print Sheets
Count of all sheets
Operation Price
Quantity of 1
Per Unit
Job Quantity
Per Page
Job Quantity * Number of Pages
Job - {LengthLongUnitNameSingular} width
Job Quantity * Job Width
Job - {LengthLongUnitNameSingular} depth
Job Quantity * Job Depth
Job - {LengthLongUnitNameSingular} height
Job Quantity * Job Height
Job - {AreaLongUnitNameSingular} area
Job Quantity * Job Area
Job - {VolumeLongUnitNameSingular} volume
Job Quantity * Job volume
Job - {WeightLongUnitNameSingular} weight
Job Quantity * Job Weight
Job - perimeter
Job Quantity * Job Perimeter including any inner 'tiling'
Flat Per Page
Pages per item
Sheet - {LengthLongUnitNameSingular} length
Total Sheet Length + Any Defined Extra Per Sheet
Sheet - {LengthLongUnitNameSingular} width
Total Sheet Width + Any Defined Extra Per Sheet
Roll Applied to Sheets
Roll Applied to Items
Calculation applies to both items and sheets, ‘items’ applies to individual items, ‘sheets’ to the whole printed sheets
Take the Material Width Defined
If the material width covers the sheet across the long edge (MatWidth > LongEdge)
material goes across the long edge, length is (ShortEdge + extra) * Quantity
else
material goes across the short edge, length is (LongEdge + Extra) * Quantity
Roll Applied to Sheets w/ slit
Roll Applied to Items w/ slit
Calculation applies to both items and sheets, ‘items’ applies to individual items, ‘sheets’ to the whole printed sheets
Take the Material Width Defined
If the material has no overhang over the long edge (MatWidth >= LongEdge)
material goes across the short edge, length is (LongEdge + Extra) * Quantity
else
material goes across the long edge, length is (ShortEdge + extra) * Quantity
Plate Finish Area {AreaLongUnitName}
Job Area * Number of Plates * NUp
Plate Sheet Area {AreaLongUnitName}
Sheet Area * Number of Plates
Plate per unit
Number of plates
Tile - Join {LengthLongUnitNameSingular}
Length of all joined edges for tiles
Shape Output
Reference a Calculated Shape output by name, this value * quantity
Items Along Perimeter
Items Along Component Defined Length
These use the same calculation, Perimeter is Width * 2 + Depth * 2,
Component Defined uses Width * WidthMultiplier + Depth * DepthMultiplier from the component record
Options are roundup or round down and apply to total or apply to each edge.
if applying to all calculate how many items fit along the full length then round
Number of Items per unit = ROUND(((Width * WidthMultiplier + Depth * DepthMultiplier) / Gap)
else calculate and round each edge separately
Number of Items per unit = (ROUND(Width / Gap) * WidthMultiplier) + (ROUND(Depth / Gap) * DepthMultiplier)
Total Items = Number of Items * Quantity
You can set a default quantity to be added in addition to the calculated quantity.
Using the fields:
Extra total items - Sets an additional quantity to add to the calculation 'per item'
Extra items per edge - Sets an additional quantity to add to the calculation 'per edge' configured on a component (defined using component options 'Component Length Width/Depth Multiple')
Job - {LengthLongUnitNameSingular} from component
Job Width * ComponentWidthMultiplier + JobDepth * ComponentDepthMultiplier
Number of Packs
Material calculation based on the number of packs configured when "Use Packs' is enabled on quotes
Job - Assembled Perimeter
Job Quantity * Job Perimeter excluding any inner 'tiling'
Core
Calculates the amount of Core material required for roll labels.
Label Width + Extra * Number of rolls
Notes on calc types
Calculation types below do not work with Job Based Operations:
- Sheet area {AreaLongUnitName}
- Finish area {AreaLongUnitName}
- Print Sheets
- Sheet - {LengthLongUnitNameSingular} length
- Sheet - {LengthLongUnitNameSingular} width
- Roll Applied to Sheets
- Roll Applied to Sheets w/ slit
- Roll Applied to Items w/ slit
- Roll Applied to Items w/ slit
- Roll Applied to Items
- Plate Sheet Area {AreaLongUnitName}
- Plate Finish Area {AreaLongUnitName}
- Plate per unit
- Cylinder Plate Area
Export/Import
You can use the Export and Import options to export all or a filtered set of materials from the Materials Admin board to CSV.
Details of the materials can be changed and / or the pricing updated before importing the CSV back into printIQ to update those materials
refer to the Bulk Materials Upload screen for a detailed description of the calculation requirements to set up the Calculation Types
