The Ancillary Items Editor button allows you access and save a configuration file that includes the number of holes drilled in a cabinet to be reported based on the layer name, depth and or diameter.

The Ancillary Items Editor can be accessed from the Catalog/Drawing Properties and located on either the:-

• Hardware > Managers page

Click to Expand

or

• Pricing > Materials/Hardware page

Click to Expand

These figures can appear on Board, Hardware and Quantity reports that are grouped by Cabinet.

Ancillary Items

There are two types of Ancillary Item...

1. System (e.g. Shelf Supports) which are in-built statistics;
2. Custom which can be created and maintained by individual users.

Ancillary Additional Statistics

Tick the Use Shelf Supports checkbox to include statistics in reports. These are controlled on the Mach.General > Tool page.

A custom heading can be set in the Report As edit box.

Statistics are split over multiple report lines and Lines with zero holes can be turned Off/On and allows you not show lines when the value is zero. 

A Hardware table, generally the Hardware.qlt, can be linked to this item by using the Browse button. This allows association with a Supplier and a Price.

Click to view location of Hardware table using the Browse button

Custom Ancillary Items

Each configuration line consists of...

• Reported Name e.g. 3mm Screws;
• The resulting machining Layers to which it applies (this can be a comma separated list);
• The hole Diameters to which it applies (this can be a comma separated list);
• The hole Depths to which it applies (this can be a comma separated list);
• A multiplication Factor applied to the result (this can be a formula) -
  • The example shown is a formula that creates a value based on the adjustable shelf holes being grouped - so that the resulting number is the number of shelf pins required i.e. if the holes are groups of 5 then the factor is 1/5.

Notes

1. If any of the above are blank or zero then they are ignored.
   • The example above shows both the Diameter and Depth as zero, so the result will include ALL depths and diameters for the Layers.
2. Using comma separated lists for more than one property will give misleading results e.g. for both Layer Names and Diameter within the same reported name.
   • So only use one separated list per configuration line.
3. In addition to the configured options the reports will also display a Total number of holes of all layers, diameters and depths. 

Reports

For this example report, ensure that the necessary categories on the Pricing/Markups page are set and the Hardware Accessory is costed.

Pricing and Markups

Ensure you have the Hardware category ticked and any other required Categories.

Labour category must be enabled if labour costing for hardware items is required.

We have also priced Materials using the 'Price if Zero' options.

To designate the Sell price you need to set the Level Markup percentages which are applied after any Markup % set for the hardware item.

Custom Ancillary Items and corresponding Hardware costing.

The Ancillary Item '5mm Screws' has been associated with the Hardware accessory 'Screws' which has a cost set to $20 each.

You can create a Hardware accessory for each screw size and therefore price separately.

Also, note that Shelf Supports are already a Hardware accessory that can be selected from the drop list and priced in the same way as 'Screws'.

The following report shows that there are 19 x 5mm Screws (Ancillary statistics).

• Using the Hardware Manager Form, screws have a cost price of $20 each.
  • Also, a Supplier has been specified i.e. AccessoriesRUs (see notes on Hardware costing above)
• Therefore the reported Cost price for 19 screws is $380
  • The Sell price hasn't been assigned a Markup value on the Pricing/Markups page (see notes on Pricing and Markups above).

The Quantities Report shown here reports the 19 screws separately because the Hardware Supplier Details checkbox is ticked and the hardware item 'Screws' has a specified Supplier.

Click to view Floor 5 Drawer priced for this report