Versions Compared

Version Old Version 10 New Version 11
Changes made by

Tom Williams

Tom Williams

Saved on

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.

...

Identifies  This defaults to blank for new records but is required and always editable for Accruals Settle . 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 .This lookup contains the list of all AP Vendors

Database Field: 

Database Field: 

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'. (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. price.  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 Accounts

    This defaults to blank for new records and is only enabled/editable when either Paid Weight or Deliver Weight.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 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 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 - Program ID - Accruals
    Def - Program ID - Accruals
    nopaneltrue
     This is required and is always editable from the Accruals Record View.

    Database Field: ERPx_CPAccrual.AccrualItem

    AP Vendor

    Should be titled 'Vendor Name'

    Insert excerpt
    Vendor Name
    Vendor Name
    nopaneltrue
     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 Accruals Record View.  For Accrual programs with a 'Settlement Method' of "GL Accrual"

    , this is blank and not editable.

    Database Field: ERPx_CPAccrual.VendorSK

    Assign Rate ByAssign Rules ByCalculated On

    Insert excerpt
    Def - Assign Rate By GA Accrual
    Def - Assign Rate By GA Accrual
    nopaneltrue
     This is required and is always editable from the Accruals 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
    nopaneltrue
     This is required and is always editable from the Accruals 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
    nopaneltrue
     This is required and is always editable from the Accruals 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 Accruals Record View. The number format of this column is not right. It should be Decimal as this may be a $ Rate or percentage.

    (lightbulb) 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 Accruals Record View.

    Database Field: ERPx_CPAccrual.EndDate

    Expense Account

    Insert excerpt
    Def - GL Account - Expense
    Def - GL Account - Expense
    nopaneltrue

    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.DRAccount

    Inactive

    Insert excerpt
    Def - Inactive
    Def - Inactive
    nopaneltrue

    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. 

    This should show a % sign when the 'Calculated On' is set to

    "% Gross $"

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database Field: ERPx_CPAccrual.UOMSK

    Settlement Method

    Identifies how the

    Accrual Program is Settled. This is required and is always editable from the Accruals 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 Accruals Record View.

    Database Field: ERPx_CPAccrual.StartDate

    Related Topics



    Expand
    titlePage Definitions

    Page Definitions


    ...