Angie,

In Sage Knowledgebase please look up article 18768. Also Sage BusinessWorks Table and field definitions used to help design User Defined Reports can be accessed through the Sage BusinessWorks Viewer by selecting Main Sage BusinessWorks News on the right hand side of the Welcome Screen. Scroll down to the section titled 'Sage BusinessWorks Tables and Fields'.

Please note that Sage Customer Support is not responsible for assisting with report creation. If you need additional assistance, your Sage BusinessWorks business partner may be of assistance with the creation of reports. For a list of Sage BusinessWorks business partners who specialize in this area, please contact ClientCare at 800-447-5700.

Angie,

In Sage Knowledgebase please look up article 18768. Also Sage BusinessWorks Table and field definitions used to help design User Defined Reports can be accessed through the Sage BusinessWorks Viewer by selecting Main Sage BusinessWorks News on the right hand side of the Welcome Screen. Scroll down to the section titled 'Sage BusinessWorks Tables and Fields'.

Please note that Sage Customer Support is not responsible for assisting with report creation. If you need additional assistance, your Sage BusinessWorks business partner may be of assistance with the creation of reports. For a list of Sage BusinessWorks business partners who specialize in this area, please contact ClientCare at 800-447-5700.

Yes I have access to the tables and fields manual. I see there is a link between the JCJob table and the SKJCJob field. But my problem is, I am trying to customize the payroll Check Register -Detail report (prints after paychecks are printed) to include a column listing with the Job ID number for the hours worked by each employee where applicable. The SQL Syntax process of linking the tables is not working to allow the data to populate the column and dbtext field I have created.

Angie,

This is an issue that would be best discussed with Customer Support, 800-447-5700, option 3 or with your Sage Partner. Thank you.