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.

...

Toolbar IconsDescription
Delete
Insert excerpt
Delete - GlobalLV
Delete - GlobalLV
nopaneltrue
Edit
Insert excerpt
Edit - List View LV (MLMulti Line)
Edit - List View LV (MLMulti Line)
nopaneltrue
Excel
Insert excerpt
Excel - Global (old)
Excel - Global (old)
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
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 LV (MLMulti Line)
Save - List View LV (MLMulti Line)
nopaneltrue
FieldsDescription
CheckboxUsed to select one or more records for delete or mass update.
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 recordsbut is required. If blank, the message "Accrual Account is required." will be displayed on SaveThis 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.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 "Accrual Item is required." will be displayed on Save. This value must be unique. If not, the message "Violation of Unique key constraintDuplicate Accrual Items are not allowed" 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 Database Field: ERPx_CPAccrual.VendorSK

Calculated On

A single select load on demand lookup to assign the data value that will be used to calculate the Accrual amount. This defaults to blank for new records but is required. If missing, the message "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 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 recordsbut is required. If blank, the message "Expense Account is required." will be displayed on SaveThis 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

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

Settle Method

A 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:

  • 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.

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 Database Field: ERPx_CPAccrual.UOMSK

...