Insert excerpt

	Def - Program Type - GA Accrual
	Def - Program Type - GA Accrual
nopanel	true

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

Software Version: 20192022.0904.03 and 22 and newer

Table of Contents

type	flat

Page Header

Database Field:

A single select lookup to assign Accruals are processed. This defaults to blank for new records but is required. If missing, the message "Settle Method is required." will be displayed on Save. This value is always editable. The options include:

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Delete

Insert excerpt

	Delete - LV 3.0
	Delete - LV 3.0
nopanel	true

Edit

Insert excerpt

	Edit - LV 3.0
	Edit - LV 3.0
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

New

Insert excerpt

	New - Global 3.0
	New - Global 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Fields

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Accrual Account

Insert excerpt

	Def - GL Account - Accrual
	Def - GL Account - Accrual
nopanel	true

This defaults as blank on new Account is required." will be displayed on Save. This field is always editable.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts

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

Insert excerpt

	Def -

Item

Program ID - Accruals
	Def -

Item

Program ID - Accruals
nopanel	true

A text box that shows the unique identifier of the Accrual record.This defaults to blank for new records and is required. If not assigned, the message "Accrual Item is required." will be displayed on Save. This value must be unique. If not, the message "Duplicate Accrual Items are not allowed" will be displayed on Save. This field This is required and is always editable from the record view and must be <= 25 characters. The Accrual Item is used as a short description and unique identifier of the AccrualAccrual Record View.

Database Field: ERPx_CPAccrual.AccrualItem

AP Vendor

Identifies the AP Vendor that will be paid when this accrual is used. This defaults to blank for new records but is required and always editable for Accruals with a 'Settle Method' of "AP Invoice". If missing, the message "AP Vendor is required when the Settle Method is AP Invoice." will be displayed on Save.

This field is not editable for Accruals with a 'Settle Method' of "GL Accrual".

This lookup contains the list of all AP Vendors.

Database Field: ERPx_CPAccrual.VendorSK

Assign Rate By

Assign Rules By

Calculated On

A single select lookup to assign the data value that will be used to calculate the Accrual amount. This defaults to blank for new records but is required. If missing, the message "Calculated On is required." will be displayed on Save. This value is always editable. The options include:

% Gross $: The Accrual is calculated by multiplying the ticket items extended amount by the Accrual 'Rate'.

Delivered Weight: The Accrual is calculated by multiplying the ticket items 'Total Weight' by the Accrual 'Rate'.

This does not convert to the UOM specified.

Paid Weight: The Accrual is calculated by multiplying the ticket items 'Total Weight' by the Accrual 'Rate' for only line items with a non-zero 'Amount'.

This does not convert to the UOM specified

Assign Rate By

Insert excerpt

	Def - Assign Rate By GA Accrual
	Def - Assign Rate By GA Accrual
nopanel	true

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

Insert excerpt

	Def - Assign Rules By GA Accrual
	Def - Assign Rules By GA Accrual
nopanel	true

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

Insert excerpt

	Def - Calculated On - Ticket Accruals
	Def - Calculated On - Ticket Accruals
nopanel	true

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 price"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

Insert excerpt

	Def - GL Account - Expense
	Def - GL Account - Expense
nopanel	true

This defaults as blank on new records but is required. If blank, the message "Expense Account is required." will be displayed on Save. This field is always editable.This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accountsis 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

Insert excerpt

	Def - Inactive
	Def - Inactive
nopanel	true

Database Field: ERPx_CPAccrual.IsInactive

Rate UOM

Identifies the UOM associated with the Accrual Rate. This value is informational only and can only

. This defaults to blank for new records and is only enabled/editable when

be edited by changing the 'Calculated On' property on the Accrual Record View. If the 'Calculated On' property is set to

either Paid Weight or Deliver Weight.

'% Gross $' then the Rate UOM value will display '%'.

Insert excerpt

	Def - UOM
	Def - UOM
nopanel	true

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

Insert excerpt

	Vendor Name
	Vendor Name
nopanel	true

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

Version	Old Version 9	New Version Current
Changes made by	Tom Williams	Tom Williams
Saved on	Feb 25, 2022	Jun 16, 2022

Versions Compared

Key

Page Header

Related Topics

Page Definitions

Page Comparison

Versions Compared

Key

Page Header

Related Topics

Page Definitions