There are a few different ways to complete this function:
To Print:
Open Reports, Estimating, Print Bill
Press OK to Price type message
Select Unpriced Bill from Other Options Section, Press OK
This will produce a report with the Ref, Description, Qty and Unit Columns populated. The Rate and Extension column will be visible but blank.
To Export Option 1 (No Formulas):
Open Input/Output, Estimating, Excel, Job
Press OK, Save the File
Remove the additional Columns
To Export Option 2 (No Formulas):
Open Estimating
Click on the View In Excel Icon (top right of view screen)
Tick Unpriced
Press OK and Save File
Open File and all columns visible within the View window will be displayed including the Rate and Extension column but they will be empty as will all Totals, summary totals etc
To Export Option 3 (With formulas only with Online Enquiries module):
Open Enquiries, Online Enquiries
Create a sendout
In Trade Packages, Create Bills for all trades
On the Far right column select Show Q Files
Double click on the Trade Bill allocated to the selected trade to remove it and it will reappear on the right menu
Highlight all Files and right click, Export Selected to a location of your choice.
This will export Formatted Trade Bills with Formulas for the Rate and Extension columns.