Versions Compared

Key

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

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 purpose of this page is to add, edit, remove, and activate/inactive these records.

...

(Default Value) and is (always, never, or conditionally) required. If not assigned(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.##### the (EnumerationClassName)  A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled##########
Toolbar IconsDescription
Delete
Insert excerpt
Delete - Global
Delete - Global
nopaneltrue
Edit
Insert excerpt
Edit - List View (ML)
Edit - List View (ML)
nopaneltrue
Excel
Insert excerpt
Excel - Global
Excel - Global
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout
Grid Layout
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
New
Insert excerpt
New - In line add
New - In line add
nopaneltrue
Save
Insert excerpt
Save - List View (ML)
Save - List View (ML)
nopaneltrue
FieldsDescription
CheckboxUsed to select one or more records for delete or mass update.
Accrual Item

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Accrual AccountA (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####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 recordsbut is required. If blank, the message "Accrual Account is required." will be displayed on SaveThis field is always editable.

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

AP Vendor

GL Accounts

Linked Database Field: ERPx_CPAccrual.CRAccount

Accrual 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 "

(what message is displayed)

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

 This field is

(always, never, or conditionally) enabled

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.

#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

Calculated OnA single-select standard lookup to select (describe what is being selected)

AccrualItem

AP Vendor

A single select load on demand lookup to assign the AP Vendor that will be paid when this accrual is usedThis defaults to

(Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled

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 Database Field: ERPx_

#####

CPAccrual.

#####.

This lookup contains all the values in the (EnumerationClassName) Enumeration Class.

Expense AccountA (single-select standard,

VendorSK

Calculated OnSettle Method

A single select load on demand , or multi-select) lookup to select (describe what is being selected)lookup to assign the data value that will be used to calculate the Accrual amountThis defaults to (Default Value) and is (always, never, or conditionally) required. If not assignedblank for new records but is required. If missing, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

Rate

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####.Calculated On is required." will be displayed on Save. This value 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'. (lightbulb) 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'. (lightbulb) This does not convert to the UOM specified.

This lookup contains all the values in

the (EnumerationClassName) 

the CPAccrualCalcMethod Enumeration Class.

Linked Database Field: 

UOM

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####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 recordsbut is required. If blank, the message "Expense Account is required." will be displayed on SaveThis field is always editable.

The unique identifier of the (what type of record is this). This default to blank but is required for all records, must be unique (what must it be unique by), and must be <= 25 characters.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

(Field Name) ID

GL Accounts

Linked Database Field: ERPx_

####

CPAccrual.

OOOO
(Field Name) Description

The name associated with the (ID Field Name) ID. This is required for all records but does not need to be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

InactiveA Yes/No field used to identify if the record is Inactive. If set to 'Yes' then it's "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then it's "Active" and can be used without restrictions. ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####.
Date FieldThe date of the (what is the date for) that was created by the transaction.

DRAccount

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 Database Field: ERPx_

#####

CPAccrual.

#####.

Rate

HyperlinkA hyperlink show the (Field Name) of the transaction. Clicking on the link opens the record view of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.
Lookup (from an Enumeration)A single-select standard lookup to select (describe what is being selected)Settle Method

A single select load on demand lookup to assign how the Accruals are processedThis 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:

  • AP Invoice: The Accrual is created via a separate AP Invoice that goes straight to Dynamics GP..
  • GL Accrual: The Accrual is created as part of the Ticket.

This lookup contains all the values in

the CPSettleMethod Enumeration Class.

Lookup (non Enumeration)

Linked Database Field: ERPx_

CPAccrual.

AccrualSettleMethodSK

UOM

This lookup contains a blank value , the current assigned value, and a list of all the 'Active' (what does it include).

Text Field

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Yes/No Lookup

A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime. 

A value of "Yes" means that...

A value of "No" means that...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 Database Field: ERPx_CPAccrual.UOMSK

Related Topics



Expand
titlePage Definitions

Page Definitions


...