Table of Contents

QB - 14.04.03 Maestro* Technologies Materials Export

Views: 811 Last Updated: 11/07/2022 03:00 pm	0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

Our developers worked with Maestro* Technologies to determine what they need to use our export.

Caution

Although the Bid, Labor, and Material Exports are available to any licensed user, the Accounting and Custom Exports are only available to users under a maintenance subscription.

If you've allowed your maintenance subscription to expire, you can renew easily by clicking File > Check Authorization and clicking the Renew link.

QB License Activation dialog box - renew link

That link opens the MyOnCenter customer portal where you (or whoever can pay the invoice) may renew your maintenance subscription.

You can also contact Customer Success to discuss renewing your maintenance subscription.

Note

On Center Software does not provide assistance with importing Materials Export Files into your Accounting package. Accounting packages are very complex and the vendor of your particular Accounting package is best equipped to support it.

To export materials to Maestro* Technologies Accounting software,

Click the Exports button on the Bids Toolbar

Select Job Material File

Click the Options button - the Modify Options for Job Materials Export dialog displays

From the Export Format drop down, select "Maestro* Technologies", (exported to a CSV file)

Note

The exported file only includes items with Material Cost Codes. Equipment, Other, and Subcontractors are not included in this export. The Material File export allows you to update the material list in Maestro* based on the final Bid information from Quick Bid. For assistance importing a material file into Maestro, please consult your Maestro User Guide or Maestro's support.

Export Column Definition

Column #	Column Header	Column Value
1	Project No.	<Job Number in the Cover Sheet>, if <Job No> is blank then <Blank>
2	Resource No.	<Account Id in the Cover Sheet>, if <Account ID> is blank then <Blank>
3	Resource Description	<Unit Size (Container)>
	Inventory Code	<Product Number>, if product number is not available, then <Item Code>
	Req. Qty.	-When Priced by container; <Container Quantity> <Material Quantity>/<Container> -When Priced by UOM; <Material Quantity>
	Characteristics	<Blank>
	Activity	If Use Account Codes is not checked: <Cost Code> If Use Account Codes is checked: <Account Code> If Cost Code does not have an assigned Account Code: <Cost Code>
	Group	M
	Item Date	<Export Date>
	User No.	<Blank>
	UP	<Unit Price>
	Amount	<Material Net Amount>
13	Item Code	<Item Code>
14	Size	<Size>
15	Description	<Product Description>

Export Example

If you are looking for information on Maestro's Accounting export (not just Materials), see Related articles.

QB - 14.03.09 Maestro* Technologies Accounting Export