Pay Run Processing

Reports

Receipt Processing

Optional jobs.

Receipting

Job 100147 (executeScript) - SP - Create Receipt batches for items

Use this job to create pending receipt batches for client invoices. This is only suited to a process where your client has confirmed the pay run and the expected funds normally match. If you sometimes need to make adjustments to pay runs, do not create pending receipt batches, as this will slow down your process.

Related Job: 100199

See also the Pay Run Receipts Setup page.

Auto Build Claims

Job 100181 (autoBuildClaims) - Auto-build claims - with exceptions report

Run Times: Mon-Fri 5am

Delivery Type: Email

Attachment Required: Checked

Purpose: Creates and posts claims where there are funds available. Sends a report to the selected recipient with a report showing any contracts where autoBuildClaims cannot be completed with a message.

Selection Criteria:

• The item "Disbursement Type" is 'Recurring'

• The contract is in the Salary Packaged group

• There are funds available.

See also the Pay Run Receipts Setup page.

Auto Updates

The first three jobs below are usually set-up as a chain and run together. The frequency of the jobs depends on your business processes.

Job 100150 (autoPostClaims) - Auto-post claims

Purpose: Posts claims where there are funds available.

Selection Criteria:

• The item "Disbursement Type" is 'Claim'

• The contract is in the Salary Packaged group

• The claim is 'Pending Funds'

• There are funds available.

Job 100151 (autoBuildClaims) - Auto-build claims

Purpose: Creates and posts claims where there are funds available.

Selection Criteria:

• The item "Disbursement Type" is 'Recurring'

• The contract is in the Salary Packaged group

• There are funds available.

Parent Job: 100150

Job 100152 (autoPostPayments) - Disbursement Payments

Purpose: Posts payment schedule records where there are funds available.

Selection Criteria:

• The item "Disbursement Type" is 'Periodic'

• The contract is in the Salary Packaged group

• There are funds available.

Parent Job: 100151

Contracts

Contract Balance Checks

Contracts / Billing

Contracts / Payments

Contracts / Claims

Contracts / Billing

Job 100185 (executeQuery) - SP - Car Contract Budget Checks

Run Time: Weekdays 5:00am

Delivery Type: Email

Purpose: List contracts where budgets are not complete for a car contract that is linked to an item.

Selection Criteria:

• Item is linked to a car profile and item "Contract ID" is the same

• Contracts / Billing contains pending periodic budget records

Data Checks:

• ECM: Contracts / FBT "ECM Flag" is checked and ECM budget is 0, or ECM GST - Contracts / FBT "ECM Flag" is checked and ECM GST budget is 0, or

• FBT:

  • Clients / Contract Defaults "Employer FBT Type" is 'Full FBT Payable' or 'Rebatable'

  • Contracts / FBT "Benefit Type" is not 'Exempt'

  • Contracts / FBT "FBT Treatment Type" is not 'EV Exempt Reportable'

  • Contracts / FBT "ECM Flag" is 'No'

  • FBT budget is 0

• FBT:

  • Clients / Contract Defaults "Employer FBT Type" is 'Concessional 30000 Exempt' or 'Concessional 17000 Exempt'

  • Clients / Quote Defaults "Allow Quoting within Exempt Cap" is un-checked

  • Contracts / FBT "Benefit Type" is not 'Exempt'

  • Contracts / FBT "FBT Treatment Type" is not 'EV Exempt Reportable'

  • Contracts / FBT "ECM Flag" is 'No'

  • FBT budget is 0

• Operating Cost Method - Business Use: contracts are excluded if Contracts / FBT "Benefit Type" is 'Operating' and Contracts / FBT "Business Use" is 100%

• Operating Cost Method - ECMR: contracts are excluded if Contracts / FBT "Benefit Type" is 'Operating' and Contracts / Events contains an active event for 'EmployeeContribution Required'. Visit the Employee Contribution for details about this feature.

Related Job: 100225

Pay Runs

Period Dates

Items

Update Item Data

Selection Criteria:

• The linked contract has billing dates and Cycles do not match Last Billing Period

• The linked contract has billing dates and Start Date does not match Contract First Billing Date

• The linked contract has billing dates and End Date does not match Contract Last Billing Date

• The linked contract has billing dates and Deduction Per Pay does not match Next Pending or Last Posted Billing Total

• Status is not 'Accepted' and Contract is order (Suspend Date is blank and one un-dated billing record has been created or there are no billing records)

• Status is not 'Active' and Contract is active (Suspend Date is blank and billing records exist)

• Status is not 'Suspended' and Contract is suspended (Suspend Date is populated)

Updates:

• Total Deduction:

  • If the linked contract has billing dates and Compress is 'Yes' and Inertia is 'Yes' and Cycles is less than Pay Cycles per Year - update to show Cycles X Deduction Per Pay

  • If the linked contract has billing dates and Compress is 'Yes' - update to show Cycles X Deduction Per Year

  • If the linked contract has billing dates - update to show Cycles X Deduction Per Pay

  • Otherwise, keep the stored Total Deduction

• Cycles:

  • If the linked contract has billing dates - update to show Last Billing Period (this can become different if billings are shortened or extended)

  • If the linked contract billing dates are blank, keep the stored Cycles

  • If the linked contract has a Suspend Date and there are no billing records, make this 0

• Start Date:

  • If the linked contract billing dates are blank, keep the stored Start Date

  • If the linked contract has no billing records, keep the stored Start Date

  • If the linked contract has billing dates, use the First Billing Date (this can become different if the first billing is delayed)

• End Date:

  • If the linked contract has billing dates, use the Last Billing Date (this can become different if billings are shortened or extended)

  • If the linked contract billing dates are blank, keep the stored End Date

  • If the linked contract has a Suspend Date and there are no billing records, make this date blank

  • Otherwise, keep the stored End Date

• Deduction Per Pay:

  • If there are pending deductions, show the amount of the next pending billing (item 1). Note: 0 value billing records are excluded

  • If there are no pending deductions, show the amount of the last posted billing (item 1). Note: 0 value billing records are excluded

  • Otherwise, keep the stored amount

• Status:

  • If the linked contract does not have a Suspend Date and there is an un-dated billing record - update to 'Accepted'

  • If the linked contract does not have a Suspend Date and there are no billing records - update to 'Accepted'

  • If the linked contract does not have a Suspend Date and there are pending billings - update to 'Active'

  • If the linked contract has a Suspend Date - update to 'Suspended'

Contracts (Jobs)

Job 100183 (executeScript) - SP - Update Contract Budgets - EOL

Run Time: Daily 6:00am. See parent job.

Table: fmcontractbudgets

Purpose: Update Suspended Contracts to remove pending budgets that occur on or after the "Suspend Date". These budgets do not show up in the Pay Run screen and will not be posted. Removing these budgets improves the detail of contracts and items.

Related Jobs: 100224, 100173

Job 100169 (executeImportTableData) - SP - Update Contract Data

Run Time: Daily 6:00am. See parent job.

Table: fm_contracts

Purpose: Clean up details to maintain alignment with the details in the linked Item record. These can become mis-aligned over time as edits are made to the contract.

Updates:

• Contract Start - update to show first billing date.

• Contract End - update to show last billing date.

• Term - update to show updated term.

• Inertia - update to show Item Inertia.

• Billing Periods - update to show highest billing period.

Parent Job: 100183

Job 100177 (executeImportTableData) - SP - Update Contract Data - EOL

Run Time: Daily 6:00am. See parent job.

Table: fm_contracts

Purpose: Update contracts to be suspended when they have reached end of life. This is done to save time for users and to show the suspended contracts clearly.

Selection Criteria:

• Package Item "Inertia" default is unchecked

• Item "Inertia" is unchecked

• Item Status is 'Active'

• Contract Group is 'Salary Packaged' (Novated should be excluded as EOL Reconciliation required)

• There are posted billings

• There are no pending billings

• Final Billing Date is less than today

Updates:

• Contract Status - 'Suspended'

• Suspend Date - Final Billing Date + 1 day

Parent Job: 100169

Job 100110 (executeScript) - Contract Status and Contract Sub Status update

Run Times: 10:00pm Daily

Purpose: Update Contract Status and Contract Sub Status if they are not congruent with the "Reg No" and contract date settings. This job needs to be updated in Salary Packaging is in use, as salary packaged contracts require different updates.

Job TBA (CAT-18024) (executeScript) - SP - Update Contract Status

Run Times: 10:00pm Daily

Car Items

Install and use the jobs below for Package Items configured with car profiles.

Direct Link Car Items

Install and use the jobs below if you are offering the following package items: direct novated leases or Direct Link Associate Lease Managed.

See also the process page Direct link car benefit auto updates.