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

Insert excerpt
Def - Accrual
Def - Accrual
nopaneltrue
 The purpose of this page is to add, edit, remove, and activate/inactive these records.

...

Page Header

(Multi Line) (Multi Line) Global (old) Global (old)Grid LayoutGrid Layout Grid Layout In line addNew - In line addSaveSave - LV (Multi Line)Used to select one or more records for delete or mass update.
Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Edit
Insert excerpt
Edit - LV
3.0
Edit - LV
3.0
nopaneltrue
Excel
Insert excerpt
Excel -
LV 3.0
Excel -
LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New
Insert excerpt
New -
Global 3.0
New - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Save - LV (Multi Line)
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Accrual AccountThe GL Account that is Credited, to record the liability, when the Accrual is assigned to a Ticket Item.

Insert excerpt
Def - GL Account - Accrual
Def - GL Account - Accrual
nopaneltrue
 This defaults as blank on

new records, but is required. If blank, the message "Accrual 

new 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

FieldsERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.CRAccount

Accrual ID

Insert excerpt
Def - Item ID
Def - Item ID
nopaneltrue
 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 "Duplicate 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 Identifies 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

Assign Rate By


Database Field: 

Assign Rules By


Database Field: 

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' (ticket items extended amount ) by the Accrual 'Rate'.
  • Delivered WeightThe Accrual is calculated by multiplying the Ticket Lines 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 Lines 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.

Linked Database Field: ERPx_CPAccrual.AccrualCalcMethodSK

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

Database Field: ERPx_CPAccrual.Rate

End Date


Database Field: ERPx_CPAccrual.EndDate

Expense Account

Insert excerpt
Def - GL Account - Expense
Def - GL Account - Expense
nopaneltrue
This defaults as blank on new records

,

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

Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.DRAccount

Inactive


Database Field: ERPx_CPAccrual.IsInactive

Rate Identifies the price/percentage of the AccrualUOM

This value is informational onlyThis defaults to 0.0000 blank for new records but is not required to be changed. This field is always editable. Linked and is only enabled/editable when 'Calculated On' is set to either Paid Weight or Deliver Weight.

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Field: ERPx_CPAccrual.RateUOMSK

Settle Settlement 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.posts directly to AP when the Ticket is posted.
  • GL AccrualThe 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


Database Field:

 ERPx

 ERPx_CPAccrual.

UOMSK

StartDate

Related Topics



Expand
titlePage Definitions

Page Definitions


...