Project And Job Costing Details Screen
This field appears only for earnings, accrual payments, and expense reimbursements.
This field is enabled only for:
- Time and Material projects.
- Fixed Price projects with an accounting method of Billings and Costs or Accrual-Basis, where the invoice type is Item.
For a standard project, the Accounts Receivable item number specified for the employee resource for the project and category is displayed by default.
For a basic project, the Accounts Receivable item number specified for the contract category is displayed by default.
You can select another valid Accounts Receivable item number.
This field appears only for earnings, accrual payments, and expense reimbursements.
This field is enabled only for:
- Time and Material projects.
- Fixed Price projects with an accounting method of Billings and Costs or Accrual-Basis, where the invoice type is Item.
For a standard project, the Accounts Receivable UOM specified for the employee resource for the project and category is displayed by default.
For a basic project, the Accounts Receivable UOM specified for the contract category is displayed by default.
You can select another valid Accounts Receivable UOM. The UOM must be valid for both the Accounts Receivable item number entered and for the contract customer’s currency.
This field appears only for earnings, accrual payments, and expense reimbursements, and if multicurrency is specified in the Accounts Receivable field.
This field is enabled only for:
- Time and Material projects.
- Fixed Price projects with an accounting method of Billings and Costs or Accrual-Basis, where the invoice type is Item.
This field displays the currency of the customer specified for the selected contract.
This field appears only for earnings, accrual payments, and expense reimbursements, and if the billing type is billable.
This field is enabled only for:
- Time and Material projects.
- Fixed Price projects with an accounting method of Billings and Costs or Accrual-Basis.
This field displays the amount or percent at which to bill the customer. By default:
- The field displays information defined in the Payroll Employees or Earnings and Deductions screens (in the Sage 300 Desktop).
- For piece rate and sales commission earnings, the billing rate is zero.
You can change the default billing rate/percent.
This field appears only for earnings, accrual payments, and expense reimbursements.
This field is enabled only for:
- Time and Material projects.
- Fixed Price projects with an accounting method of Billings and Costs or Accrual-Basis.
Enter a category that is assigned to the project you selected.
The category must have a cost class of labor, unless you are allocating an expense reimbursement.
For standard projects, you can enter only categories to which the employee specified on the timecard has been assigned.
Enter a contract number.
You can enter only contracts that are open, or that are currently on hold but have previously been open. (You cannot enter a contract that is on hold and has never been open).
This field appears only for expense reimbursements. It corresponds to the Cost Class field in Sage 300 Project and Job Costing. The cost class is based on the Category field.
This field displays the A/R customer assigned to the contract.
If applicable, enter the number of hours to be applied to the earning for this job.
You must enter a value in this field for a Flat, Fixed, Hourly Rate, or Amount per Hour earning, or an accrual payment.
If you use Transaction Analysis and Optional Field Creator and you want to assign optional fields to an earning/deduction or tax, click the Edit icon in the Optional Fields column to open the Optional Fields screen. You must already have defined optional fields in the Sage 300 Desktop (specifically, in Common Services and in the Payroll Optional Fields screen).
On the Optional Fields screen, enter or change optional field information:
- Change default values. If an optional field requires validation, you must enter a value that is specified for the optional field in Common Services. (If the optional field allows a blank, you can leave the field blank.) Otherwise, you can enter any combination of characters that is consistent with the type of field (text, amount, date, and so on).
- Add an optional field. Click Add Line, and then use the Finder to select an optional field to add. You can select only optional fields that are set up for the earning/deduction or tax on the Optional Fields screen.
- Delete an optional field. Select an optional field on the list, and then click Delete Line.
These fields appear only for earnings, accrual payments, and expense reimbursements, and if the Override Overtime option is selected on the timecard.
Enter overtime hours or the overtime billing rate.
For a piece rate earning, enter the number of pieces completed. If the number of pieces on the corresponding timecard detail line is zero, then it will be automatically updated to contain the total number of pieces specified in the job details.
For sales commission, expense reimbursements, benefits, or deductions, enter the amount. If the amount on the corresponding timecard detail line is zero, then it will be automatically updated to contain the total amount specified in the job details.
Enter a project that is assigned to the contract you selected.
You can enter only projects that are open, or that are currently on hold but have previously been open. (You cannot enter a project that is on hold and has never been open).
This field appears only for expense reimbursements. It corresponds to the Resource field in Sage 300 Project and Job Costing. The resource is based on the Cost Class field:
- If the cost class is labor, the Resource field displays the employee number, and you cannot change it.
- If the cost class is not labor:
- For a basic project, you do not need to enter a resource, but you can.
- For a standard project, you must enter a resource.
This field appears only for expense reimbursements. It displays a name or description for the resource entered in the Resource field, and is based on the Cost Class field:
- If the cost class is labor, the Resource Description field displays the employee’s name, and you cannot change it.
- If the cost class is not labor, the Resource Description field displays information from Sage 300 Project and Job Costing, and you can change it.
If applicable, enter start and stop times. Information in the Hours field is updated automatically.
These fields appear only for earnings, accrual payments, and expense reimbursements.
These fields are enabled if they are applicable to the timecard detail (for example, the Overtime Acct field will be editable only if the overtime schedule has been specified on the timecard detail), and depends on the contract/project. For example, you can edit WIP accounts for a project that has the following setup:
- Project Type: Fixed Price
- Accounting Method: Billings and Costs
- A/R Invoice Type: Item
Sage 300 Payroll displays the Work in Progress (WIP) account from Sage 300 Project and Job Costing.
If the G/L Integration option Apply Cost Center Overrides To Project And Job Costing Accounts is selected, the WIP account with any cost center overrides is entered on the Payroll Employees screen (in the Sage 300 Desktop) for the earning/deduction. Job cost center overrides are available for:
- Time and Materials projects.
- Fixed Price projects using the Accrual-Basis accounting method.
- Cost Plus projects using the Accrual-Basis accounting method.
If you modify the segment overrides for the timecard detail after the jobs have been entered, and Sage 300 Payroll uses the Apply Cost Center Overrides To Project And Job Costing Accounts option for G/L Integration, the jobs for that detail will be automatically modified with the segment overrides.
Segment overrides are applied to Project and Job Costing accounts using the same rules as for the accounts in the timecard detail.
Overview
As part of entering earnings/deductions on the Employee Timecards screen, you use the Project And Job Costing Details screen to enter job-related information for the earnings/deductions.
You begin by specifying the contract, project, and category of the job to which you want to apply job-related information for an earning/deduction. After you've done this, most of the other fields on the screen display default information originating from Sage 300 Project and Job Costing, or from the Payroll Employees and Earnings and Deductions screens (in the Sage 300 Desktop). You can change some of this information.
- The contract, project, and category correspond to those that are set up in Sage 300 Project and Job Costing (so if you use terms different than contract, project, and category, the terms you use appear instead).
- After you have added a job detail line, you cannot change the contract, project, or category.
- For each earning/deduction, you can distribute job-related information among multiple jobs.