Versions Compared

Version Old Version 1 New Version Current
Changes made by

Tom Williams

Tom Williams

Saved on

Key

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

Insert excerptDef - Accrual - GADef - Accrual - GAnopaneltrueThe purpose

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

Software Version: 2022.0204.2522 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Delete

Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
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
Save
Insert excerpt
Save - RV Header 3.0
Save - RV Header 3.0
nopaneltrue
Save & Close
Insert excerpt
Save & Close - RV Header 3.0
Save & Close - RV Header 3.0
nopaneltrue
FieldsDescription
AccrualCharge

Insert excerpt
Def - Program ID -
Accruals
Charges
Def - Program ID -
Accruals
Charges
nopaneltrue
This is a single select lookup that refreshes the page to show the details for the Program selected.

Database Field: ERPx_CPAccrualCPCharge.AccrualItemChargeItem

Properties Tab 

 This is required and defaults to "No" if unassigned on new Programs. This is always editable.after the Start Date." will be displayed on Save.  

Database Field: ERPx_CPAccrualCPCharge.IsInactive

 Charge GL Account 
Toolbar IconsDescription
Excel

Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue

Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
FieldsDescription
Group: Configuration
Accrual Charge ID

Insert excerpt
Program ID
Program ID
nopaneltrue
 This This is a text box that is required. It defaults to blank for new records. If not assigned, the message "Accrual Charge ID is required." will be displayed on Save. This value must be unique. If not, the message "Duplicate Accrual Charge ID's are not allowed." will be displayed on Save. This field is always editable and must be <= 25 characters. 

Database Field: ERPx_CPAccrualCPCharge.AccrualItemChargeItem

Start Date

Identifies the date the Program starts. Tickets with a 'Delivered' date on or after the Program's 'Start Date' will be evaluated for the Program. This is a date picker that is required. If missing, the message "Start Date is required." will be displayed on Save. This defaults as blank on new records and is always editable. 

Database Field:  ERPxERPx_CPAccrualCPCharge.StartDate

End Date

 Identifies the date the Program ends. Tickets with a 'Delivered' date on or before the Program's 'End Date' will be evaluated for the Program. This is a date picker that is not required. This defaults as blank and is always editable. A blank value assumes the Program never ends, but if a date is entered it must be >= the 'Start Date' field. Else the message "End Date must be on or after the Start Date." will be displayed on Save.  

 Database Field: ERPx_CPAccrual.EndDate

InactiveAssign Rules By

Insert excerpt
Def - InactiveDef - Inactive
nopaneltrue
Group: Assign Rules By

EndDate

Inactive

Insert excerpt
Def -
Assign Rules By GA Accrual
Inactive
Def -
Assign Rules By GA Accrual
Inactive
nopaneltrue
 This is a multi-select lookup where at least one selection is required. If missing, the message "Assign Rules By is required." will be displayed on Save. This defaults as blank and is always editable. When one or more values are selected, on Save, additional tabs for each of the selected items will be added to the record view.

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

Database Field: ERPx_CPAccrual.AssignRulesByCSVEN

Assign Rate

is required and defaults to "No" if unassigned on new Programs. This is always editable.

Database Field: ERPx_CPCharge.IsInactive

Group: Assign Rules By
Assign Rules ByIdentifies how the Accrual Program is Settled.

Insert excerpt
Def - Assign

Rate

Rules By GA Accrual
Def - Assign

Rate

Rules By GA Accrual
nopaneltrue

 

This is a

single

multi-select lookup

that

where at least one selection is required.

It defaults as blank and is always editable. If it is changed, it must match one of the values in the '

If missing, the message "Assign Rules By

' Property. If not, the message "Assign Rate By must be assigned by one of the Assign Rules By values." will be displayed on Save

is required." will be displayed on Save. This defaults as blank and is always editable. When one or more values are selected, on Save, additional tabs for each of the selected items will be added to the record view.

This lookup contains all the values in

the CPAssignRateBy

the CPAssignRulesBy Enumeration Class

.

Database Field: ERPx_CPAccrual.AssignRateByEN

Settlement Method

.

Database Field: ERPx_CPCharge.AssignRulesByCSVEN

Assign Rate By

Insert excerpt
Def - Assign Rate By GA Accrual
Def - Assign Rate By GA Accrual
nopaneltrue
This is a single-select

standard

lookup that is required. It defaults as blank and is always editable.

  • 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

    If it is changed, it must match one of the values in the 'Assign Rules By' Property. If not, the message "Assign Rate By must be assigned by one of the Assign Rules By values." will be displayed on Save.

    This lookup contains all the values in the 

    CPSettleMethod Enumeration

    CPAssignRateBy Enumeration Class.

    Database Field:

     ERPx

    ERPx_

    CPAccrual

    CPCharge.

    AccrualSettleMethodSK

    AssignRateByEN

    Calculated On

    Insert excerpt
    Calculated On - Ticket
    Accruals
    Charges
    Calculated On - Ticket
    Accruals
    Charges
    nopaneltrue
     This is a single-select lookup that is required. If missing, the message "Calculated On is required." will be displayed on Save. It defaults to blank and is always editable.
    Insert excerpt
    Def - Calculated On - Ticket
    Accruals
    Charges
    Def - Calculated On - Ticket
    Accruals
    Charges
    nopaneltrue

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

    Database Field:  ERPxERPx_CPAccrualCPCharge.AccrualCalcMethodSKChargeCalcMethodSK

    Default Rate

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

    (lightbulb) Leaving this as 0.000000 and the 'Assign Rate By' to "GLOBAL" and the 'Calculated On' on anything other than "Fixed Amount" will result in no tax Charge being calculated.

    (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 ERPx_CPAccrualCPCharge.Rate

    Rate UOM

    Identifies the UOM associated with the Accrual Charge Rate. This value is informational only and can only be edited by changing the 'Calculated On' property on the Accrual Charge Record View. 

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database Field: ERPx ERPx_CPAccrualCPCharge.UOMSK

    Group: Accounting
    Expense Account
    Insert excerpt
    Def - GL Account - ExpenseDef - GL Account - Expense
    nopaneltrue

    Identifies the GL Account used to record the Charge. This is a single-select lookup that is required. If missing, the message "Expense Charge GL Account is required." will be displayed on Save. This defaults as blank, is always editable, and displays as [GL Account ID] - [GL Account Description].

    The 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.DRAccountSK

    		Accrual Account

    Insert excerpt
    Def - GL
    Account
    Account - Charge -
    Accrual
    GA
    Def - GL Account -
    Accrual
    Charge - GA
    nopaneltrue
     

    Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPCharge.CRAccountSK

    Settlement Method

    Identifies how the Charge Program is Settled. This is a single-select standard lookup that is required

    . If missing, the message "Accrual Account is required." will be displayed on Save. This defaults as blank, is always editable, and displays as [GL Account ID] - [GL Account Description].

    The 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.CRAccountSK

    . It defaults as blank and is always editable.

    • AP Invoice: The Charge is created via a separate AP Invoice that posts directly to AP when the Ticket is posted.
    • GL Accrual: The Charge is included with the journal entry created by the Ticket.

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

    Database Field: ERPx_CPCharge.ChargeSettleMethodSK

    Vendor Name

    Insert excerpt
    Vendor Name
    Vendor Name
    nopaneltrue
     This is a single-select lookup that defaults as blank, is only required, and is only editable if the 'Settlement Method' is "AP Invoice". If the 'Settlement Method' is "AP Invoice" this is always editable. If the 'Settlement Method' is "GL AccrualCharge" this is blank and disabled.

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

    Database Fields: ERPx_APVendor.VendorName, ERPx ERPx_CPAccrualCPCharge.VendorSK

    Crops Tab 

    This tab will only be visible if "Crops" is selected in the 'Assign Rules By' property. This tab is used to assign one or more 'Crops' to the Program. If this tab is not visible, the Program applies to all Crops.

    Toolbar IconsDescription
    Excel

    Insert excerpt
    Excel - LV 3.0
    Excel - LV 3.0
    nopaneltrue

    Delete
    Insert excerpt
    Delete - RV Grid 3.0
    Delete - RV Grid 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
    FieldsDescription
    Checkbox
    Insert excerpt
    Checkbox
    Checkbox
    nopaneltrue
    Crop

    A single select lookup to assign a Crop(s) to the Accrual Charge Program. This is only visible when "Crop" is selected in the 'Assign Rules By' value in the Properties tab. By default, when a new Accrual Charge Program is created, all Crops are assigned. If you want only specific Crops to apply to the Program, click the ‘New’ icon and manually add the Crop(s) that you wish to apply. 

    This lookup contains a list of all the records in the Crops Master List.

    Database Fields: ERPx_CPCrop.Crop, ERPx_CPAccrualCropCPChargeCrop.CropSK

    Rate

    Insert excerpt
    Accrual Charge Rate - GAAccrual
    Charge Rate - GA
    nopaneltrue
     This is a text box that is not required.This field is only enabled and required when "Crop" is selected as the 'Assign Rate By' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable to any amount >= 0.

    Database Fields: ERPx_CPAccrualCPCharge.Rate ERPx_CPAccrualCropCPChargeCrop.Rate

    Items Tab 

    This tab will only be visible if "Items" is selected in the 'Assign Rules By' property. This tab is used to assign one or more 'Items' to the Program. If this tab is not visible, the Program applies to all Items.

    Toolbar IconsDescription
    Excel

    Insert excerpt
    Excel - LV 3.0
    Excel - LV 3.0
    nopaneltrue

    Delete
    Insert excerpt
    Delete - RV Grid 3.0
    Delete - RV Grid 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
    FieldsDescription
    Checkbox
    Insert excerpt
    Checkbox
    Checkbox
    nopaneltrue
    Item

    Insert excerpt
    Item ID & Item Description
    Item ID & Item Description
    nopaneltrue
     A single select lookup to assign an a Ticket Item(s) to the Accrual Charge Program. This is only visible when "Item" is selected in the 'Assign Rules By' value in the Properties tab. By default, when a new Accrual Charge Program is created, all Items are assigned. If you want only specific Items to apply to the Program, click the ‘New’ icon and manually add the Item(s) that you wish to apply. 

    This lookup contains a list of all the records in the Ticket Items List View.

    Database Fields: ERPx_CPItem.ItemDescription, ERPx_CPAccrualItemCPChargeItem.ItemSK

    Rate

    Insert excerpt
    Accrual Rate - GA
    Accrual Rate - GA
    nopaneltrue
     This is a text box that is not required.This field is only enabled and required when "Item" is selected as the 'Assign Rate By' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable to any amount >= 0.

    Database Fields: ERPx_CPAccrualCPCharge.Rate, ERPx_CPAccrualItemCPChargeItem.Rate


    Related Topics



    Expand
    titlePage Definitions

    Page Definitions


    ...