Update Database from Estimate (SQL)
Description
Cause
Resolution


You can update the following item elements to the standard database.

  • Waste Factor
  • Crew
  • Price (per item category)
  • Productivity/Conversion Factor (per item category)
  • Apply Waste (per item category)
  • Taxable or Non-taxable (per item category)
  • Job Cost Phase (per item category)
  • Job Cost Category (per item category)
  • WBS Code Values
  • Add new item categories

Tips:

  • Create a custom spreadsheet layout that only shows the columns you can update to the standard database.
  • Sage Estimating (SQL) does not update items in the database with attachments in the estimate.
  • Select the "Update DB" check box for the items to be updated.



[BCB:164:Chat Estimating US:ECB]

Steps to duplicate
Related Solutions

Saving items as an assembly (SQL)