Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Accrual
Def - Accrual
nopaneltrue
 The purpose of this page is to add, edit, remove, and activate/inactive these records.

...

Page Header

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Edit
Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New
Insert excerpt
New - Global 3.0
New - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Accrual Account

Insert excerpt
Def - GL Account - Accrual
Def - GL Account - Accrual
nopaneltrue
 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

 This is displayed as [GL Account ID] - [GL Account Description]. This is required and is always editable from the Accruals 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
nopaneltrue
 
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 AccrualAccruals 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


Database Field: 

Assign Rules By


Database Field: 

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 WeightThe Accrual is calculated by multiplying the ticket items 'Total Weight' by the Accrual 'Rate'. (lightbulb) 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'. (lightbulb) This does not convert to the UOM specified.

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

Database Field: ERPx_CPAccrual.AccrualCalcMethodSK

Default Rate

Identifies the price/percentage of the Accrual. This defaults to 0.0000 for new records but is not required to be changed. This field is always editable. 

Database Field: ERPx_CPAccrual.Rate

End Date


Database Field: ERPx_CPAccrual.EndDate

Expense Account

Insert excerpt
Def - GL Account - Expense
Def - GL Account - Expense
nopaneltrue
This defaults as blank on new records but is required. If blank, the message "Expense Account is required." will be displayed on SaveThis field is always editable.

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

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

Inactive


Database Field: ERPx_CPAccrual.IsInactive

Rate UOM

This value is informational only. This defaults to blank for new records and is only enabled/editable when 'Calculated On' is set to either Paid Weight or Deliver Weight.

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Field: ERPx_CPAccrual.UOMSK

Settlement Method

A single select lookup to assign how the 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:

  • AP Invoice: The Accrual is created via a separate AP Invoice that posts directly to AP when the Ticket is posted.
  • GL AccrualThe 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


Database Field: ERPx_CPAccrual.StartDate

Related Topics



Expand
titlePage Definitions

Page Definitions


...