A Grower Accounting Accrual is used to automate the recording expenses incurred as part of a Ticket. These are most often used to accrue for taxes, harvesting, or hauling expenses that will be paid by the company.The purpose of this page is to add, edit, remove, and activate/inactive these records.

Software Version: 2022.04.22 and newer

Page Header

Toolbar Icons	Description
Delete	Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. _{WARNING: Records cannot be recovered once they are deleted!}
Help	Opens the online WIKI help page for the current page.
New	Opens a new blank record for data entry.
Save	Saves the changes made to the record.
Save & Close	Saves your changes and closes the page.
Fields	Description
Accrual	Accrual IDs are the unique identifier for Accrual programs.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

Toolbar Icons	Description
Excel	Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported.
Quick Column Filter	Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Fields	Description
Group: Configuration
Accrual ID	Identifies the short description and unique identifier for Tax, Premium, Charge, Accrual and Sales Program. 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	Identifies if the record is "Inactive". If inactive (set to "Yes"), it will not be included in look-ups for transactions or other master files. If set to "No" or blank, the record is active and can be freely used.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	The Assign Rules By field determines the criteria used to calculate Grower Ticket Accruals. One or more of the following values may be selected: Crop Item 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	The Assign Rate By field determines where the 'Rate' is identified on a Grower Accounting Accrual Program. The selection must match one of the values assigned in the 'Assign Rules By' property. The potential values include: Crop: The rate is assigned based on the Crop(s) Default Rate: The rate is the same of everything covered under the Accrual program Item: The rate is assigned based on the Item(s) 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.AssignRateByEN
Calculated On	Identifies the value used, for each applicable ticket line, for calculating Ticket Accruals.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. Identifies the values used for determining Ticket Accruals. It can be set to one of the following values: % 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. 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. 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. 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. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. Database Field: ERPx_CPAccrual.UOMSK
Group: Accounting
Expense Account	The GL Account that is Debited to record the expense when an Accrual is assigned to a transaction.This is a single-select lookup that is required. If missing, the message "Expense 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	The GL Account that is Credited to record the liability (e.g., Accrued Taxes) when a Charge or Accrual is assigned to a transaction.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.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 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 C PSettleMethod Enumeration Class. Database Field: ERPx_CPAccrual.AccrualSettleMethodSK
Vendor Name	Identifies the name of the Vendor assigned to the transaction or master file. This is set in the Vendor Record View. 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" 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 Icons	Description
Excel	Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported.
Delete	Deletes the selected line(s) from the transaction. When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This icon is only enabled for transactions with a Status of 'New'.
New	Opens a new blank record for data entry.
Quick Column Filter	Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Fields	Description
Checkbox	Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
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	Identifies the tax rate used for calculating the Grower Accounting Ticket Accrual. 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.

Toolbar Icons	Description
Excel	Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported.
Delete	Deletes the selected line(s) from the transaction. When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This icon is only enabled for transactions with a Status of 'New'.
New	Opens a new blank record for data entry.
Quick Column Filter	Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Fields	Description
Checkbox	Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Item	Identifies the Item, displayed as Item ID: Item Description. 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	Identifies the tax rate used for calculating the Grower Accounting Ticket Accrual.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

NorthScope

Accrual Record View

Page Header

Properties Tab

Crops Tab

Items Tab

Related Topics

Page Definitions

Technical Details