JC Cost Code Format and Job Section Mapping

The mask identifies the cost code numbering structure in the Sage Timberline® Office Job Cost Accounting database. WMS will not be able to receive job information from Job Cost if the mask does not match the cost code numbering structure exactly. Once a job number section is mapped to a code, a match must exist for all values assigned in order to successfully import a job from Sage Timberline® Office Accounting, otherwise, the job will not import into WMS.

To set the JC Cost Code format:

• From the Integration menu, select Timberline Accounting > Accounting DB Settings.
   

• • Or, select the Accounting DB Settings icon from the Timberline Accounting Integration toolbar.

2. Verify the database currently selected in the Accounting Databases field list is the correct database for which this setting will be defined. If necessary, click on a different database.

3. Click the Timberline Accounting Configuration tab.

4. Enter the mask in the JC Cost Code Format field.

• Enter the '#' symbol to represent each character.

• Enter the appropriate number of characters in each section.

• Separate the sections of the cost code number with the'-' symbol.

• For example, the JC cost code numbers have 9 characters with 3 in the first section, 2 in the second section, and 4 in the last section, the mask would be '###-##-####'.  

5. Click the Save button at the top of the screen to save the changes.

6.  

1. To verify the JC Cost Code number mask:

2. In the Timberline Accounting Configuration tab, verify the JC Cost Code Number mask by clicking the Verify icon next the JC Cost Code Format field. The Timberline Accounting JC Cost Code Sections dialog appears.
   
   
   
    

2. The numbers appearing in the Section fields represent the number of '#' characters entered in the JC Cost Code Format field. ClickVerify in the lower right side.

3. • If the mask is correct the Information dialog displays a "Current Sections Match Accounting Data" dialog.

4. • If the mask is not correct, the error dialog appears, "Current sections do not match Accounting data." In this case, the user needs to change the mask until it matches the Sage Timberline® Office Job Cost Accounting cost code number structure exactly.

3. Adjust the mask as necessary.

4. Click OK when complete.

5.  

    

   Related Topics

   Timberline Accounting Version

   Path to Job Cost Accounting Database

   Job Number Format

   JC Job Field Mapping