Accrual Record View

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 IconsDescription
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.
FieldsDescription
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 IconsDescription
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.
FieldsDescription
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'. (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 "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. 

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 CPSettleMethod 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 ViewThis 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 IconsDescription
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.
FieldsDescription
CheckboxUsed 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 IconsDescription
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.
FieldsDescription
CheckboxUsed 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

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details