Versions Compared

Old Version 12

changes.mady.by.user Tom Williams

Saved on

compared with

New Version Current

changes.mady.by.user Tom Williams

Saved on

Key

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

Insert excerptDef - Accrual - GADef - Accrual - GAnopaneltrueThe purpose of this page is to add, edit, remove, and activate/inactive these records.

Software Version: 2022.02.25 and newer

Table of Contents
typeflat

Page Header

...

Database Field: ERPx_CPAccrual.AccrualItem

Properties Tab 

...

Database Field: ERPx_CPAccrual.AccrualItem

...

Database Field: ERPx_CPAccrual.StartDate

...

 

Database Field: ERPx_CPAccrual.EndDate

...

Database Field: ERPx_CPAccrual.IsInactive

...

Specifies how Accruals are assigned to tickets. 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 field 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.

...

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

Software Version: 2022.04.22 and newer

Table of Contents
typeflat

Page Header

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
Accrual

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

Database Field: ERPx_CPAccrual.AccrualItem

Properties Tab 

AssignRulesByCSVENSpecifies where the Accrual Rate comes from.  standard is required "???"

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

Database Field: ERPx_CPAccrual.AssignRateByEN

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

Database Field: ERPx_CPAccrual.AccrualSettleMethodSK

 This is a single-select standard 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. If it is changed from "???", 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.
Calculated On - Ticket Accruals Calculated On - Ticket Accruals

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

 ERPxAccrualCalcMethodSKDefault Rate - Tax & Premium This text box Rate  will  It defaults to "0.000000" and is always editable. If the tax is configured to be an expense for the company and the fisherman, the default rate is automatically divided. If this causes the rate to be more than 6 decimals, then the company rate is rounded up and the fisherman rate is rounded down.

(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 being calculated.

(lightbulb) If the 'Assign Rate By' is anything other than 'Globally" this is only represents the Default Rate. The actual rates may be different. 

Database Field: ERPx_CPAccrual.Rate

Database Field: ERPx_CPAccrual.UOMSK

Company Tax Expense Company Tax Expense  standard if "Company" is selected in the 'Expense For' propertyCompany Expense and is always editable.The lookup contains ERPxDRAccountSK . If missing, the message "Tax Liability GL Account is required." will be displayed on Save. This

The lookup contains a list of all the 'Active' GL Accounts.

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

  standard lookup that is not required. It defaults to blank and is always editable Fishermen, Tenders, Fishermen & Tenders and
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 ID

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

Database Field: ERPx_CPAccrual.AccrualItem

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: ERPx_CPAccrual.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

Inactive

Insert excerpt
Def - Inactive
Def - Inactive
nopaneltrue
This is required and defaults to "No" if unassigned on new Programs. This is always editable.

Database Field: ERPx_CPAccrual.IsInactive

Group: Assign Rules By
Assign Rules By

Insert excerpt
Def - Assign Rules By GA Accrual
Def - Assign Rules By GA Accrual
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 By

Insert excerpt
Def - Assign Rate By GA Accrual
Def - Assign Rate By GA Accrual
nopaneltrue
This is a single-select lookup that is required. It defaults as blank and is always editable. 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 CPAssignRateBy Enumeration Class.

Database Field: ERPx_CPAccrual.

Assign Rate By

AssignRateByEN

Calculated On

Insert excerpt
Calculated On - Ticket Accruals
Calculated On - Ticket Accruals
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

Settlement MethodCalculated On
Insert excerpt
Calculated On - Ticket AccrualsCalculated On - Ticket Accruals
nopaneltrue

blank and is always editable.

Insert excerpt
Def - Assign Rate ByDef - Assign Rate By
nopaneltrue

Insert excerpt
Def - Calculated On - Ticket Accruals
Def - Calculated On - Ticket Accruals
nopaneltrue

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.

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

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. 

Insert excerpt
Def -

UOM
Def -

UOM
nopaneltrue

Database Field:

 ERPx_CPAccrual.

Default Rate

UOMSK

Group: Accounting
Expense Account

Insert excerpt

Default Rate - Tax & Premium

Def - GL Account - Expense
Def - GL Account - Expense
nopaneltrue

This is a

single-select lookup that is required. If missing, the message "

Expense Account is required."

will be displayed on Save.

Rate UOM
Group: Accounting
Expense

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 -

Accrual
Def - GL Account -

Accrual
nopaneltrue

This is a single-select

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.

Accrual Account
Insert excerpt
GL Account - Tax Liability AccountGL Account - Tax Liability Account
nopaneltrue

CRAccountSK

Settlement Method

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

. It defaults as blank and is always editable.

AP Vendor
  • 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

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 Accrual" 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_CPAccrual.VendorSK

Crops Tab 

This tab will only be visible if "Crops" Crops" is selected in the 'Assign Rules By' propertyis 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.

Tax FishermanTax Fisherman
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 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 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_CPAccrualCrop.CropSK

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 "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_CPAccrual.Rate ERPx_CPAccrualCrop.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.

Tax FishermanTax Fisherman 
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 Item(s) to the Accrual 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 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_CPAccrualItem.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_CPAccrual.Rate, ERPx_CPAccrualItem.Rate


Related Topics



Expand
titlePage Definitions

Page Definitions


...