/
Accruals List View

Accruals List View

Jun 16, 2022

 The purpose of this page is to add, edit, remove, and activate/inactive these records.

Software Version: 2022.04.22 and newer

[ 1 Page Header ] [ 1.1 Related Topics ] [ 1.1.1 Page Definitions ] [ 1.1.2 Technical Details ]

Page Header

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Delete

Edit

Excel

Favorites

Group By Show/Hide

Help

New

Quick Column Filter

Saved Layouts

Fields

Description

Checkbox

Accrual Account

This is displayed as [GL Account ID] - [GL Account Description]. This is required and is always editable from the Accrual Record View.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.CRAccount

Accrual ID

 This is required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.AccrualItem

Assign Rate By

This is required and is always editable from the Accrual Record View.

This lookup contains all the values in the CPAssignRateBy Enumeration Class.

Database Field: ERPx_CPAccrual.AssignRateByEN

Assign Rules By

This is required and is always editable from the Accrual Record View.

This lookup contains all the values in the CPAssignRulesByEnumeration Class.

Database Field: ERPx_CPAccrual.AssignRulesByCSVEN

Calculated On

This is required and is always editable from the Accrual Record View.

This lookup contains all the values in the CPAccrualCalcMethod Enumeration Class.

Database Field: ERPx_CPAccrual.AccrualCalcMethodSK

Default Rate

Identifies the "Default" rate/percentage of the Accrual. This defaults to 0.0000 for new records but is not required to be changed. This field is always editable from the Accrual Record View.

 This only identifies the default rate. However, the actual Rates may be different if the "Assign Rate By" property is not set to "Default Rate".

Database Field: ERPx_CPAccrual.Rate

End Date

Identifies the Date the Accrual Program ends. A blank value assumes the Accrual program does not end. This is not required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.EndDate

Expense Account

This is displayed as [GL Account ID] - [GL Account Description]. This is required and is always editable from the Accrual Record View.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.DRAccount

Inactive

Database Field: ERPx_CPAccrual.IsInactive

Rate UOM

Identifies the UOM associated with the Accrual Rate. This value is informational only and can only be edited by changing the 'Calculated On' property on the Accrual Record View.  If the 'Calculated On' property is set to '% Gross $' then the Rate UOM value will display '%'.  

Database Field: ERPx_CPAccrual.UOMSK

Settlement Method

Identifies how the Accrual Program is Settled. This is required and is always editable from the Accrual Record View.

  • AP Invoice: The Accrual is created via a separate AP Invoice that posts directly to AP when the Ticket is posted.

  • GL Accrual: The Accrual is included with the journal entry created by the Ticket.

This lookup contains all the values in the CPSettleMethod Enumeration Class.

Database Field: ERPx_CPAccrual.AccrualSettleMethodSK

Start Date

Identifies the Date the Accrual Program starts. This is required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.StartDate

Vendor Name

This identifies the AP Vendor that will be paid when this accrual is used. For Accrual programs with a 'Settlement Method' of "AP Invoice", this is required and always editable from the Accrual Record View.  For Accrual programs with a 'Settlement Method' of "GL Accrual", this is blank and not editable.

Database Field: ERPx_CPAccrual.VendorSK