Accounting and Estimating DB Settings and Updating Job Fields

Configuration (Cross Reference to Table Below)

Timberline Job Cost Does NOT Overwrite Workflow Management

Workflow Management Populates Blank Fields in Timberline Job Cost

Use Estimate Cover Page Information

1

Unchecked

Unchecked

Unchecked

2

Unchecked

Unchecked

Checked

3

Checked

Unchecked

Unchecked

4

Checked

Unchecked

Checked

5

Checked

Checked

Unchecked

6

Checked

Checked

Checked

Configuration (Cross Reference to Table Above)

Summary of Software Behavior based on Configuration of Accounting and Estimating DB Settings

1

These are the Default settings.

• Job Cost: Sage Timberline Office® Job Cost fields always overwrite mapped WMS Job fields, even if the Job Cost field is blank and the WMS field is not blank.

• WMS:  Edits made to WMS Job fields that are mapped to Sage Timberline Office Job Cost will be lost.  

• Estimate:  Estimate Cover Page Information will not write to WMS or to Sage Timberline Office Job Cost.

2

• Job Cost:  Sage Timberline Office Job Cost fields always overwrite mapped WMS Job fields, even if the Job Cost field is blank and the WMS field is not blank.

• WMS:  Edits made to WMS Job Fields that are mapped to Sage Timberline Office Job Cost will be lost.  

• Estimate:  Estimate Cover Page Information fields will overwrite WMS fields if the WMS fields are blank.  However, Sage Timberline Office Job Cost fields will overwrite any Estimate Cover Page information written to WMS.

3

• Job Cost:  Sage Timberline Office Job Cost fields will only update mapped WMS Job fields that are blank.

• WMS:  Edits made to WMS Job Fields that are mapped to Sage Timberline Office Job Cost will NOT be sent to Job Cost.  Data can easily get out of sync if edits are allowed to mapped fields.  THIS CONFIGURATION OF SETTINGS IS NOT RECOMMENDED.

• Estimate:  Estimate Cover Page Information will not write to WMS or to Sage Timberline Office Job Cost.

4

• Job Cost:  Sage Timberline Office Job Cost fields will only update mapped WMS Job fields that are blank. Edits made to Sage Timberline Office Job Cost fields that are mapped to WMS will only be updated in WMS if the WMS field is blank (1st time only).  Subsequent edits in Job Cost will not update WMS.

• WMS:  Edits made to WMS Job fields that are mapped to Sage Timberline Office Job Cost will NOT be sent to Job Cost.  Data can easily get out of sync if edits are allowed to mapped fields.  THIS CONFIGURATION OF SETTINGS IS NOT RECOMMENDED.

• Estimate:  Estimate Cover Page Information fields will overwrite WMS fields if the WMS fields are blank.  However,  the Estimate Cover Page Information will NOT be sent to Sage Timberline Office Job Cost.

5

• Job Cost:  Sage Timberline Office Job Cost fields will only update mapped WMS Job fields that are blank.  Edits made to Sage Timberline Office Job Cost fields that are mapped to WMS will only be updated in WMS if the WMS field is blank (1st time only).  Subsequent edits in Job Cost will not update WMS.

• WMS:  WMS Job fields will only update mapped Sage Timberline Office Job Cost fields that are blank.  Edits to WMS Job Fields that are mapped to Sage Timberline Office Job Cost will only be updated in Job Cost if the Job Cost field is blank (1st time only).  Subsequent edits in WMS will not update Job Cost.

• Estimate: Estimate Cover Page Information will not write to WMS or to Sage Timberline Office Job Cost.

6

• Job Cost:  Sage Timberline Office Job Cost fields will only update mapped WMS Job fields that are blank. Edits made to Sage Timberline Office Job Cost fields that are mapped to WMS will only be updated in WMS if the WMS field is blank (1st time only).  Subsequent edits in Job Cost will not update WMS.

• WMS: WMS Job fields will only update mapped Sage Timberline Office Job Cost fields that are blank. Edits to WMS Job Fields that are mapped to Sage Timberline Office Job Cost will only be updated in Job Cost if the Job Cost field is blank (1st time only).  Subsequent edits in WMS will not update Job Cost.

• Estimate:  Estimate Cover Page Information fields will overwrite WMS fields if the WMS fields are blank.  Estimate Cover Page Information that has overwritten WMS Job Fields will only update mapped fields in Sage Timberline Office Job Cost if the Job Cost fields are blank (1st Time Only).

For this configuration of settings to work efficiently, the following workflow order will need to be followed:

1. Enter data in Sage Timberline Office Job Cost fields that are to be controlled by Job Cost.

2. Synchronize jobs by running the Receive New Jobs from Job Cost process in WMS.  From the Main menu select Integration > Timberline Accounting > Receive New Jobs from Job Cost.

3. Import the base house estimate into the job in WMS.  From the main menu select Purchasing > Issue Purchase Orders > Add Timberline Estimate.

4. Enter data in WMS Job fields that are to be controlled by WMS.

5. Synchronize jobs by running the Share All Job Information with Job Cost process in WMS.  From the Main menu select Integration > Timberline Accounting > Share All Job Information with Job Cost.