Link JCJob database field for selection in Report Builder

SUGGESTED

Is it possible to link fields, specifically Job ID (on time card entry) or make available for choosing, from JCJob database when customizing the Check Register Detailed Report in Payroll? A report has already been created and customized under a different name for the Check Register -Detailed but not sure how to link the JCJob database which contains the Job ID to this report. It does not appear in the available fields databases in the SQL Syntax Wizard. Would like to know how to add it to the Available Fields.

  • 0

    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.

  • 0 in reply to Janice Carnarvon

    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.

  • 0 in reply to Angie at ASC
    SUGGESTED

    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.