Versions Compared

Version Old Version 7 New Version Current
Changes made by

Tom Williams

Tom Williams

Saved on

Key

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

Grower Accounting Charges are assigned to Price List Items for the purpose of deducting what is owed to a Farmer when Tickets are posted. Unlike Accruals, Charges are deducted from the Farmer. Charges are most commonly used to record fees associated with Harvesting, Hauling, dockage, and damaged/down grade product..

Insert excerpt
Def - Program Type - GA Charges
Def - Program Type - GA Charges
nopaneltrue
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
typeflat

Page Header

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete -
Global
LV 3.0
Delete -
Global
LV 3.0
nopaneltrue
Edit
Insert excerpt
Edit -
List View (ML)
LV 3.0
Edit -
List View (ML)
LV 3.0
nopaneltrue
Excel
Insert excerpt
Excel -
Global
LV 3.0
Excel -
Global
LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid LayoutGrid Layout
Group By Show/Hide
Insert excerpt
Grid Layout
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Icon
3.0
Help - Global
Icon
3.0
nopaneltrue
New
Insert excerpt
New -
In line addNew - In line add
Global 3.0
New - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
SaveSave - List View (ML)
Saved Layouts
Insert excerpt
Save - List View (ML)
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
Used to select one or more records for delete or mass update.AP Vendor

A single select load on demand lookup to assign the AP Vendor that will be paid when this Charge is used. This defaults to blank for new records but is required and always editable for Charges 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_CPCharge.VendorSK

Calculated On

A single select load on demand lookup to assign the data value that will be used to calculate the Charge 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:

  • $ Fixed Amount: The Charge is applied using the Charge items 'Rate'. It is a fixed amount, not a variable amount.
  • % Gross $: The Charge is calculated by multiplying the Ticket Line 'Amount' (extended amount) by the Charge 'Rate'.
  • Delivered Weight: The Charge is calculated by multiplying the Ticket Lines 'Total Weight' by the Charge 'Rate'. (lightbulb) This does not convert to the UOM specified.
  • Paid Weight: The Charge is calculated by multiplying the Ticket Lines 'Total Weight' by the Charge 'Rate' for only line items with a non-zero 'Amount'. (lightbulb) This does not convert to the UOM specified.
    • Unpaid Weight:  The Charge is calculated by multiplying the Ticket Lines 'Total Weight' by the Charge 'Rate' for only line items with a zero 'Amount'. (lightbulb) This does not convert to the UOM specified
    nopaneltrue
    Assign Rate By

    Insert excerpt
    Def - Assign Rate By GA Charge
    Def - Assign Rate By GA Charge
    nopaneltrue
    This is required and is always editable from the Charge Record View.

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

    Database Field: ERPx_CPCharge.AssignRateByEN

    Assign Rules By

    Insert excerpt
    Def - Assign Rules By GA Charge
    Def - Assign Rules By GA Charge
    nopaneltrue
    This is required and is always editable from the Charge Record View.

    This lookup contains all the values in the CPAssignRulesByEnumeration Class.

    Database Field: ERPx_CPCharge.AssignRulesByCSVEN

    Calculated On

    Insert excerpt
    Def - Calculated On - Ticket Charges
    Def - Calculated On - Ticket Charges
    nopaneltrue
     This is required and is always editable from the Charge Record View.

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

    Linked

    Database Field: ERPx_CPCharge.

    AccrualCalcMethodSKCharge Item

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

    This defaults to blank for new records and is required. If not assigned, the message "Charge 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_CPCharge.ChargeItem

    Credit AccountThe GL Account that is Credited, to record the liability, when the Charge is assigned to a Ticket Item. This defaults as blank on new records, but is required. If blank, the message "Credit Account is required." will be displayed on Save. This field is always editable. The Farmers AP Account is debited when the Charge reduces what the Farmer is owed

    ChargeCalcMethodSK

    Charge GL Account

    Insert excerpt
    Def - GL Account - Charge - GA
    Def - GL Account - Charge - GA
    nopaneltrue

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

    This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts

    Linked

    Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPCharge.CRAccountSK

    Charge ID

    Insert excerpt
    Def - Program ID - Charges
    Def - Program ID - Charges
    nopaneltrue
     This is required and is always editable from the Charge Record View.

    Database Field: ERPx_CPCharge.

    CRAccount

    ChargeItem

    Default Rate

    Identifies the

    price

    "Default" rate/percentage of the Charge. This defaults to 0.0000 for new records but is not required to be changed. This field is always editable

    . Linked AP Invoice: The Accrual

    from the Charge Record View.

    (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_CPCharge.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:

    End Date

    Identifies the Date the program ends. A blank value assumes the program does not end. This is not required and is always editable from the Charge Record View.

    Database Field: ERPx_CPCharge.EndDate

    Inactive

    Insert excerpt
    Def - Inactive
    Def - Inactive
    nopaneltrue
    This is always editable from the Charge Record View.

    Database Field: ERPx_CPCharge.IsInactive

    Rate UOM

    Identifies the UOM associated with the Charge Rate. This value is informational only and can only be edited by changing the 'Calculated On' property on the Charge Record View. If the Calculated On property is set to '% Gross $' then the Rate UOM value will display '%' and when it is set to '$ Fixed Amount' the Rate UOM value will be blank. 

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database Field: ERPx_CPCharge.UOMSK

    Settlement Method

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

    • AP Invoice: The Charge 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
    • Charge 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_CPCharge.ChargeSettleMethodSK

    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 program starts. This is required and is always editable from the Charge Record View.

    Database Field: ERPx_CPCharge.StartDate

    Vendor Name

    Insert excerpt
    Vendor Name
    Vendor Name
    nopaneltrue
     This identifies the AP Vendor that will be paid when this charge is used. For Charge programs with a 'Settlement Method' of "AP Invoice", this is required and always editable from the Charge Record View.  For Charge programs with a 'Settlement Method' of "GL Accrual", this is blank and not editable.

    Database Field: ERPx_CPCharge.

    UOMSK

    VendorSK

    Related Topics



    Expand
    titlePage Definitions

    Page Definitions


    ...