Grower Accounting Accruals are assigned to Price List Items for the purpose of making Accruals to the General Ledger when Tickets are posted. Unlike Charges, Accruals are not deducted or paid to the Farmer. Accruals are most commonly used to record Tax expenses and payables that must be paid by the company as the result of a Ticket purchase. The

Insert excerpt

	Def - Program Type - GA Accrual
	Def - Program Type - GA Accrual
nopanel	true

The purpose of this page is to add, edit, remove, and activate/inactive these records.

Software Version: 20192022.0904.03 and 22 and newer

Table of Contents

type	flat

Page Header

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Delete

Insert excerpt

	Delete -

Global

LV 3.0
	Delete -

Global

LV 3.0
nopanel	true

Edit

Insert excerpt

	Edit -

List View (ML)

LV 3.0
	Edit -

List View (ML)

LV 3.0
nopanel	true

Excel

Insert excerpt

	Excel -

Global

LV 3.0
	Excel -

Global

LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Grid LayoutGroup By Show/Hide

Grid Layout

Insert excerpt

Grid Layout

Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global

Icon

3.0
	Help - Global

Icon

3.0
nopanel	true

New

Insert excerpt

	New -

In line addNew - In line add

Global 3.0
	New - Global 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

SaveSaved LayoutsSave - List View (ML)

Insert excerpt

Save - List View (ML)

Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

FieldsDescriptionCheckboxCheckboxUsed to select one or more records for delete or mass update.

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Accrual Account

The GL Account that is Credited, to record the liability, when the Accrual is assigned to a Ticket Item. This defaults as blank on new records, but is required. If blank, the message "Accrual 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

Linked

Insert excerpt

	Def - GL Account - Accrual
	Def - GL Account - Accrual
nopanel	true

This is displayed as [GL Account ID] - [GL Account Description]. This is required and is always editable from the Accrual Record View.

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

Accrual ID

Insert excerpt

	Def - Program ID - Accruals
	Def - Program ID - Accruals
nopanel	true

This is required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.

CRAccountAccrual Item

A text box that shows the unique identifier of the Accrual record.

This defaults to blank for new records and is required. If not assigned, the message "Accrual Item is required." will be displayed on Save. This value must be unique. If not, the message "Violation of Unique key constraint" will be displayed on Save. This field is always editable from the record view and must be <= 25 characters.

The Accrual Item is used as a short description and unique identifier of the Accrual.

Linked Database Field: ERPx_CPAccrual.AccrualItem

AP Vendor

A single select load on demand lookup to assign the AP Vendor that will be paid when this accrual is used. This defaults to blank for new records but is required and always editable for Accruals with a'Settle Method' of "AP Invoice". 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 Method' of "GL Accrual".

This lookup contains the list of all AP Vendors.

Linked

AccrualItem

Assign Rate By

Insert excerpt

	Def - Assign Rate By GA Accrual
	Def - Assign Rate By GA Accrual
nopanel	true

This is required and is always editable from the Accrual 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
nopanel	true

This is required and is always editable from the Accrual 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
nopanel	true

This is required and is always editable from the Accrual Record View.

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

Database Field: ERPx_CPAccrual.

VendorSK

AccrualCalcMethodSK

Calculated OnA single select load on demand lookup to assign the data value that will be used to calculate the Accrual amountDefault Rate

Identifies the "Default" rate/percentage of the Accrual. This defaults to

blank

0.0000 for new records but is not required to be changed.

If missing, the message "Calculated On is required." will be displayed on Save. This value Rate

Identifies the price/percentage of the Accrual. This defaults to 0.0000 for new records but is not required to be changed. This field is always editable.

Linked This field is always editable

. The options include:

% Gross $: The Accrual is calculated by multiplying the Ticket Line 'Amount' (extended amount) by the Accrual 'Rate'.
Delivered Weight: The Accrual is calculated by multiplying the Ticket Lines 'Total Weight' by the Accrual 'Rate'. This does not convert to the UOM specified.
Paid Weight: The Accrual is calculated by multiplying the Ticket Lines '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.

Linked Database Field: ERPx_CPAccrual.AccrualCalcMethodSK

Expense Account

The GL Account that is Debited, to record the Expense, when the Accrual is assigned to a Ticket Item. This 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

Linked Database Field: ERPx_CPAccrual.DRAccount

from the Accrual Record View.

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 Accrual Record View.

Database Field: ERPx_CPAccrual.EndDate

Expense Account

Insert excerpt

	Def - GL Account - Expense
	Def - GL Account - Expense
nopanel	true

This is displayed as [GL Account ID] - [GL Account Description]. This is required and is always editable from the Accrual Record View.

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

Inactive

Insert excerpt

	Def - Inactive
	Def - Inactive
nopanel	true

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. If the 'Calculated On' property is set to '% Gross $' then the Rate UOM value will display '%'.

Insert excerpt

	Def - UOM
	Def - UOM
nopanel	true

Database Field: ERPx_CPAccrual.

Rate

UOMSK

Settle Settlement MethodA single select load on demand lookup to assign how the 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:

Identifies how the Accrual Program is Settled. This is required and is always editable from the Accrual Record View.

AP Invoice: The Accrual is created via a separate AP Invoice that

goes straight to Dynamics GP..

posts directly to AP when the Ticket is posted.
GL Accrual: The Accrual is

created as part of

included with the journal entry created by the Ticket.

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

Linked

Database Field: ERPx_CPAccrual.AccrualSettleMethodSK

UOM

This value is informational only. This defaults to blank for new records and is only enabled/editable when 'Calculated On' is set to either Paid Weight or Deliver Weight.

Linked

Start Date

Identifies the Date the Accrual Program starts. This is required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.StartDate

Vendor Name

Insert excerpt

	Vendor Name
	Vendor Name
nopanel	true

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 Accrual Record View. For Accrual programs with a 'Settlement Method' of "GL Accrual", this is blank and not editable.

Database Field: ERPx_CPAccrual.

UOMSK

VendorSK

Version	Old Version 6	New Version Current
Changes made by	Tom Williams	Tom Williams
Saved on	Sept 30, 2019	Jun 16, 2022

Versions Compared

Key

Page Header

Related Topics

Page Definitions

Page Comparison

Versions Compared

Key

Page Header

Related Topics

Page Definitions