Directly Packaged Novated Lease

Job 100178 - SP - Update Direct Link Item to link Vehicle Contract

Table: spemployeepackageitems

Purpose: Links the item directly to the vehicle contract for the following package items:

• Direct Link Novated Lease

• Direct Link Associate Lease Managed

Selection criteria:

• Employees / Item "Package Item" is linked to a car profile and the car profile quoteflag = 'yes' and contractflag = 'yes'

• Employees / Item Car Details "Contract ID" is populated

• Contracts / Contract "Contract Type" is linked to the same car profile as the item

• Contract paycycle_id matches the Employees / Contact "Pay Cycle"

• Employees / Item "Disbursement Type" is 'Claim'

• Employees / Item "Contract ID" field is blank

Updates:

• Employees / Item "Contract ID" is populated from the Car Details "Contract ID"

Related Jobs: 100217, 100180

Job 100176 - SP - Update Direct Link Item from Vehicle Contract

Table: spemployeepackageitems

Purpose: This job updates items to reflect updates being done in direct linked vehicle contracts.

Package types:

• Direct Link Novated Lease

• Direct Link Associate Lease Managed

Selection criteria:

• Employees / Item "Package Item" is linked to a car profile and the car profile quoteflag = 'yes' and contractflag = 'yes'

• Employees / Item Car Details "Contract ID" is populated

• Employees / Item "Contract ID" field is populated

• Contracts / Contract "Contract ID" matches both the item and the car details "Contract ID"

Updates:

• Disbursement Type - 'Claim'

• Description - contract's "Description"

• Total Deduction - Cycles x Deductions Per Pay

• Employee Contribution - Pay Cycles Per Year x next pending EC or ECM Total budget (this is an annualised amount)

• fbtpayable - Pay Cycles Per Year x next pending FBT Total budget (this is an annualised amount)

• Cycles - the contract's max billing period

• Start Date - the contract's min billing date (if billings have been built)

• End Date - the contract's max billing date (if billings have been built)

• Deductions Per Pay - the contract's next billing total (if there are pending billings)

• Status:

  • If contract "Contract Start" is blank and "Suspend Date" is blank then 'Accepted'

  • If contract "Contract Start" is populated and "Suspend Date" is blank and "Reg No" is not 'ORDER' then 'Active'

  • If contract "Suspend Date" is populated and no pending billings exist then 'Suspended'

• Reference - contract's "Reg Number"

Related Jobs: 100218, 100178

Pay Run updates

Employees / Transactions

Job 100166 - Employees / Transactions - Disbursement

Run Time: Table: spemployeetransactions

Purpose: Create or update records that are displayed in the Employees / Transactions tab that are payments or claims.

Job updates:

• Date: If record is linked to an active BECS batch or BPAY batch, then transaction date is populated. If record is linked to an active BECS batch or BPAY batch, and transactiondate is not populated, transaction date is updated.

• Description:

  • If "Group" is 'Salary Packaged' then contract description is shown

  • If "Group" is not 'Salary Packaged' then client description is shown

  • If "Payment Type" is not 'Single Posting Class' then approval description is shown

  • If "Payment Type" is 'Single Posting Class' then payment description is shown

• Reference: The "Reference" field will show as:

  • {approvalid} if record is pending, history-only or posted and no BECS or BPAY will be attached

  • {paymentno} if record is pending, history-only or posted and no BECS or BPAY will be attached

  • {approvalid}:{becsid}

  • {approvalid}:{bpayid}

  • {paymentno}:{becsid}

  • {paymentno}:{bpayid}

• Status:

  • Pending when records are posted and no BECS batch or BPAY batch is linked

  • Posted when Linked to an active BECS batch or a BPAY batch or No BECS batch or BPAY batch will be linked

  • History Only when claim has a history only status

  • Deleted (no longer visible) when claim or payment records has a deleted status

Job 100187 - SP - Employees / Transactions - Payroll Deduction

Run Time: Refer to parent job. Table: spemployee_transactions

Purpose: Update records that are displayed in the Employees / Transactions tab.

System Updates:

Payroll Deduction records are created and updated by the system in the following situations:

• When a Pay Run is invoiced - records are created here at pending status

• When a Pay Run invoice is unposted - records are updated here to deleted status

Job Updates:

• Reference:

  • {invoiceno}:{receiptid} when an invoice record is fully paid on a single receipt

  • {invoice_no}:Multiple when an invoice record is fully paid on multiple receipts

• Status:

  • Posted when an invoice record is fully paid

  • Deleted and no longer visible when:

    • An invoice record is unposted

    • The item's "Benefit Type" is 'Exempt' and "Disbursement Type" is 'Claim' and the invoice record has a total of 0

Associate Lease - Depreciation Report Process

Annual Tasks