Versions Compared

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

Software Version: 2019.09.03 and newer

Table of Contents
typeflat

Page Header

...

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

...

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.

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

Linked Database Field: ERPx_CPCharge.AccrualCalcMethodSK

 

...

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_#####.#####.

A (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, 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. Linked Database Field: ERPx_#####.#####

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

...

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_#####.#####.

A (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_#####.#####.

...

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

Software Version: 2019.09.03 and newer

Table of Contents
typeflat

Page Header

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.
AP Vendor

A single select load on demand lookup to assign how the Accruals are processedthe 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 "the message "AP Vendor is required when the Settle Method is requiredAP Invoice." will be displayed on Save. 

This value field 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

    not editable for Accruals with a 'Settle Method' of "GL Accrual".

    This lookup contains  all the values in the CPSettleMethod Enumeration Classthe list of all AP Vendors.

    Linked Database Field: ERPx_CPAccrualCPCharge.AccrualSettleMethodSKVendorSK

    UOMCalculated On

    A

    (

    single

    -

    select

    standard, 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 Charge amount. 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. Linked Database Field: ERPx_#####.#####

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

    (Field Name) ID

    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.

    Linked Database Field: ERPx_####.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. Linked Database Field: ERPx_#####.#####.
    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). 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. Linked Database Field: ERPx_#####.#####.

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

    Lookup (non Enumeration)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. Linked Database Field: ERPx_#####.#####

    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.

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

    Linked Database Field: ERPx_CPCharge.AccrualCalcMethodSK

    Charge 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 Account

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

    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_#####.#####.

    A (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...GL Accounts

    Linked Database Field: ERPx_CPCharge.CRAccount

    Rate

    Identifies the price/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 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:

    • 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_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 Database Field: ERPx_CPCharge.UOMSK

    Related Topics



    Expand
    titlePage Definitions

    Page Definitions


    ...