From the Control File

• File name: ts.ctl
• Location: Common Tasks, File, Company Settings, General tab
• Fields:
  • Company name
  • Address
  • Phone

From the JC-Job record

• File name: master.jcm
• Location: Job Cost, Setup, Jobs
• Fields:
  • Project name
  • Address

From the PR-Employee record

• File name: master.prm
• Location: Payroll, Setup, Employees
• Fields:
  • Employee address and phone number
  • Employee SSN
  • Employee dependants
  • Employee race and gender

From the PR-Fringe record

• File name: system.prs
• Location: Payroll, Setup, Fringes
• Fields:
  • Type of fringe - drop-down list that identifies each fringe as Training, Medical/Dental, Pension, etc. Some state reports use the fringe types for classification.

From the PR-Check, Check tax, Check Deduct, Check Fringe records

• File name: current.prt
• Location: Payroll, Tasks, Enter Time or Enter Checks
• Fields:
  • Check number
  • FICA, FWH, SDI, SUI taxes
  • Other Deductions
  • Gross Pay
  • Fringe benefits other than cash fringe rate or amount
  • Week ending date (period end date)

From the Daily Distribution record

• File name: current.prt
• Location: Payroll, Tasks, Enter Time or Enter Checks
• Fields:
  • Regular daily hours
  • Overtime daily hours
  • Fringe benefit daily hours
  • Regular and OT pay rates
  • Earnings for the certified job (not the same as Gross Pay)
  • Classification (certified class)
  • Cash fringe rate and amount
  • Date and day of the week

Sage 300 CRE doesn't store the following information in its data. Enter this information manually if required by your state.

• Contractor or Subcontractor on the project?
• Payroll number
• "Date wages paid" and "Date wages due"
• Project no. and/or Contract no
• Contract amount
• Project start date and projected completion date
• Contractor license no. or registration no.
• Contracting state agency and agency contact address and phone no.
• Checkboxes for types of fringe benefits provided
• Workers’ Comp policy no.
• Subcontractor information (when a Gen. Contractor files the form)
• Alaska only - classification code, certificate #, Truck Lic #, Apprentice %, Union membership?
• Illinois only - Non-prevailing wage job hours per day if applicable