Versions Compared

Old Version 15

changes.mady.by.user Tom Williams

Saved on

compared with

New Version Current

changes.mady.by.user Emma Greenwood

Saved on

Key

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

Insert excerptDef - Grower TicketDef - Grower Ticketnopaneltrue The purpose of this inquiry is to display Tickets that have been

Insert excerpt
Def - Grower Ticket
Def - Grower Ticket
nopaneltrue
 The purpose of this inquiry is to display Tickets that have been posted. Users may utilize search options to filter the results. From this inquiry, users may open the corresponding Ticket. 

(lightbulb) This inquiry also contains columns for each Attribute that is set up under the 'Grower Accounting' Transaction attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout. User configured attributes are not included in the help documentation.

Software Version: 2022.0108.31 26 and newer

Table of Contents
exclude(Toolbar Icons|Column Headers)
typeflat

...

The lookup contains a list of all 'Active' Grower Accounting Ticket Classes.

Filter Items

Description
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Crop

Insert excerpt
Def - Crop
Def - Crop
nopaneltrue
This is a multi-select lookup that is not required to return results. It defaults as "All".

Delivery Date Range
Insert excerpt
Date Control Text Box
Date Control Text Box
nopaneltrue
Date Type

A single-select lookup to identify which 'Date' field will be used. It defaults to 'GL Date' and the lookup contains the following values:

  • Delivered Date
  • Harvested Date
  • GL Date
Farmer
Insert excerpt
Def - Farmer
Def - Farmer
nopaneltrue
This is a multi-select lookup that is not required to return results. It defaults as "All".".
Include

A lookup to assign one or more conditions you want included in your search. It defaults to 'Posted' and the lookup contains:

  • Posted
  • Repriced & Corrected
  • Unposted
  • Void
Saved Searches
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • Attr: [Attribute Value] (columns are not displayed by default in the grid, but may still be searched on)
  • Crop
  • Farmer
  • Field
  • Site: [Site ID] or [Site Name]
  • Ticket
Site

Insert excerpt
Inq - Site
Inq - Site
nopaneltrue
It displays as [Site Name]. This is a multi-select lookup that is not required to return results. It defaults as "All".

Insert excerpt
Def - Site
Def - Site
nopaneltrue

The lookup contains a list of all 'Active' Sites.

Ticket Class

A single select lookup to specify which Ticket Version(s) to return. The options include:

  • All Versions. Use this method if you want all versions of the ticket.
    • Current Posted Version. Use this method if only want to return the 'Current' version of the ticket. This is the default value.

    Insert excerpt
    Inq - Transaction Class
    Inq - Transaction Class
    nopaneltrue
    The values in this lookup are listed alphabetically. This is a multi-select lookup that is not required to return results. It defaults as "All".

    Insert excerpt
    Def - Transaction Class - General
    Def - Transaction Class -
    General
    nopaneltrue
    Version

    General
    nopaneltrue

    The lookup contains a list of all Grower Accounting Ticket Classes.

    Page Detail

    This column has not yet been added.

    This column has not yet been added.

     CPTicketHeaderDeliveryDate is This when initially creating a ticket. CPTicketHeaderFarmerSK

    This column has not yet been added.

    This column has not yet been added.

    This column has not yet been added.

    This column has not yet been added.This column has not yet been added..PriceListSK

    This column has not yet been added.

    Properties

    This column has not yet been added.

    Identifies the version of the Ticket. A blank value signifies a version 1 ticket. All ticket versions greater than 1 will display Version VersionDatabase Field: TicketVersion
    Toolbar IconsDescription
    Column Filter Show/Hide
    Insert excerpt
    Column Filter Show/Hide - Global
    Column Filter Show/Hide - Global
    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
    Print
    Insert excerpt
    Print - LV 3.0
    Print - LV 3.0
    nopaneltrue
    Quick Column Filter
    Insert excerpt
    Quick Column Filter
    Quick Column Filter
    nopaneltrue
    Refresh
    Insert excerpt
    Refresh - Global 3.0
    Refresh - Global 3.0
    nopaneltrue
    Saved Layouts
    Insert excerpt
    Column Layouts for Framework 3.0 - Global
    Column Layouts for Framework 3.0 - Global
    nopaneltrue
    Search Options
    Insert excerpt
    Search Options - Inquiry Grid 3.0
    Search Options - Inquiry Grid 3.0
    nopaneltrue

    Column Headers

    		Description
    Checkbox
    Insert excerpt
    Checkbox
    Checkbox
    nopaneltrue
    Accruals

    Displays the sum of the Extended Amount of all 'Accruals'. This is a calculated field and can only be edited by changing the Rate on one or more Accrual lines.

    Database Field: ERPx_CPTicketHeader.GrossAccrualsAmount

    Charges

    Displays the sum of the Extended Amount of all 'Charges'. This is a calculated field and can only be edited by changing the Rate on one or more Charge lines.

    Database Field: ERPx_CPTicketHeader.GrossChargesAmount

    Created

    Insert excerpt
    Created
    Created
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.CreatedDate

    Created By

    Insert excerpt
    Created By
    Created By
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.CreatedBy

    Crop

    Identifies the Crop that was harvested from the Field assigned to the Ticket. This can only be edited when initially creating a ticket.

    Insert excerpt
    Def - Crop
    Def - Crop
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.CropSK

    Delivery DateDelivered

    Identifies the date the ticket was delivered. This can only be edited by editing the 'Delivered' field on the Ticket Record View for tickets that have not yet been Approved or Posted..

    Database Field: ERPx_CPTicketHeader.DeliveryDate

    Farmer Class

    Identifies the Class assigned to the Farmer on the ticket. This can only be edited from the Farmer Master File.

    Insert excerpt
    Def - Farmer Class
    Def - Farmer Class
    nopaneltrue

    Database Field:

    ERPx_

    APVendor.

    VendorClassSK

    Farmer ID

    Identifies the ID of the Farmer that the ticket

    is assigned to. 

    This can only be edited

    from the Vendor Master file. 

    Insert excerpt
    Def - Farmer
    Def - Farmer
    nopaneltrue

    Database Field:

    ERPx_

    APVendor.

    VendorID

    Farmer ClassName

    Identifies the

    Class assigned to the

    Farmer

    on

    that the ticket is assigned to. This can only be edited

    from the Farmer Master File

    when initially creating a ticket.

    Insert excerpt
    Def - Farmer

    Class

    Def - Farmer

    Class

    nopaneltrue

    Linked

    Database Field: ERPx_

    APVendor

    CPTicketHeader.

    VendorClassSK

    FarmerSK

    Field

    Identifies the Field the ticket was harvested from. This can only be edited when initially creating a ticket.

    Insert excerpt
    Def - Field
    Def - Field
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.FieldSK

    GL Date

    Insert excerpt
    GL Date
    GL Date
    nopaneltrue
    This is required for the transaction to be approved or posted. It can be edited from the 'GL Date' field on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted.

    Database Field: ERPx_CPTicketHeader.GLDate

    GL Period

    Insert excerpt
    GL Period
    GL Period
    nopaneltrue
     This is required for the transaction to be approved or posted. It is not directly editable.  It can only be changed by editing the 'GL Date' field on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted. This field is not stored in the database.

    GL Year
    Insert excerpt
    GL Year
    GL Year
    nopaneltrue
         This is required for the transaction to be approved or posted. It is not directly editable.  It can be changed by editing the 'GL Date' field on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted. This field is not stored in the database.
    Gross AmountAmt.

    Displays the sum of the Extended Amount for all line items. This is a calculated field and can only be edited by changing the weight or price of one, or more line items.

    Database Field: ERPx_CPTicketHeader.GrossTicketAmount

    Gross WeightWt.

    Identifies the 'Gross Weight' from the Ticket. This is a calculated field that can only be edited by changing either the 'Weight In' or 'Weight Out' fields on the Ticket Record View, for tickets that have not yet been Approved or Posted. 

    Insert excerpt
    Def - Gross Weight
    Def - Gross Weight
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.GrossWeight

    Harvest DateHarvested

    Identifies the date the ticket was harvested. This can only be edited by editing the 'Harvested' field on the Ticket Record View for tickets that have not yet been Approved or Posted.

    Database Field: ERPx_CPTicketHeader.HarvestDate

    Harvester

    Identifies who harvested the crop. This is not required and can be edited on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted.

    Insert excerpt
    Def - Harvester
    Def - Harvester
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.HarvesterSK

    Hauler

    Identifies who delivered the crop. This is not required and can be edited on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted.

    Insert excerpt
    Def - Hauler
    Def - Hauler
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.HaulerSK

    Last Updated

    Insert excerpt
    Item Last Updated (Date & Time)
    Item Last Updated (Date & Time)
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.LastUpdated

    Last Updated By

    Insert excerpt
    Last Updated By
    Last Updated By
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.LastUser

    Net AmountAmt.

    Displays the sum of the Extended Amount for all line items, minus any applied 'Charges'. This is a calculated field and is not editable.

    Database Field: ERPx_CPTicketHeader.NetTicketAmount

    Net WeightWt.

    Identifies the 'Weight In' from the Ticket. This can be edited from the 'Weight In' field on the Ticket Record View for tickets that have not yet been Approved or Posted. 

    Insert excerpt
    Def - Delivered Weight
    Def - Delivered Weight
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.NetWeight

    Paid WeightWt.

    Identifies the sum of the weight of all the ticket line items with a non-zero price. This can only be edited by editing the 'Price' of a ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted. 

    Insert excerpt
    Def - Paid Weight
    Def - Paid Weight
    nopaneltrue

    (lightbulb) Note: Paid Weight is calculated for line-items with a non-zero Price. Items with a negative price are considered 'paid'.

    Database Field: ERPx_CPTicketHeader.PaidWeight

    Price List

    Identifies the Price List associated with the Farmer on the ticket. This can only be edited by changing the price list assigned to the farmer.

    Insert excerpt
    Def - Price List
    Def - Price List
    nopaneltrue

    Database Field: ERPx_CPTicketHeader

    		Sample Weight

    .PriceListSK

    Sample Size

    Identifies the weight of the delivery that was selected as a sample. This is required and can be edited from the 'Sample Size' field on the '

    Home' tab of the Ticket Record View for tickets that have not been Approved or Posted.

    Database Field: ERPx_CPTicketHeader.SampleWeight

    Site Name

    Insert excerpt
    Site Name
    Site Name
    nopaneltrue
    This comes from the 'Site' lookup on the Ticket Record View. It is not editable. 

    Insert excerpt
    Def - Site
    Def - Site
    nopaneltrue

    Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

    Status

    Insert excerpt
    Status
    Status
    nopaneltrue
    This comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable. 

    Insert excerpt
    Def - Status
    Def - Status
    nopaneltrue
     The Statuses that apply to transactions in this Inquiry include:

    Insert excerpt
    Def - Status - Posted
    Def - Status - Posted
    nopaneltrue

    Insert excerpt
    Def - Status - Void
    Def - Status - Void
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName

    Ticket

    Insert excerpt
    Transaction ID
    Transaction ID
    nopaneltrue
    This is a system assigned value and is not editable. Clicking on this link opens the transaction record view. 

    Database Field: ERPx_CPTicketHeader.TicketNumber

    Ticket Class

    Insert excerpt
    Transaction Class
    Transaction Class
    nopaneltrue
     This comes from the 'Transaction Class' value selected by the user when the transaction was created. It is not editable.

    Insert excerpt
    Def - Transaction Class - General
    Def - Transaction Class - General
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.TransactionClassSK

    		Ticket Version

    .TransactionClassSK

    Total Tare

    Identifies the 'Total Tare' weight of delivery. This is not required and is editable from either the 'Total Tare' field on the Home tab or by editing the details on the Tare tab of the ticket record view.

    • If the Tare is entered on the Tare tab, this field will populate from the detail totals and be disabled.
    • If the Tare is being managed from the Home tab, it is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted.

    Insert excerpt
    Def -

    Tare Weight
    Def -

    nopaneltrue

    Tare Weight
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.ContainerTare

    Units

    Identifies the # of containers the Ticket Item was delivered in. This is not required and can only be edited by editing the 'Units' of a ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted.

    Database Field: ERPx_CPTicketHeader.

    Units

    Unpaid WeightWt.

    Identifies the sum of the weight of all the ticket line items with a 0.00 price. This can only be edited by editing the 'Price' of a ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted.

    Insert excerpt
    Def - Unpaid Weight
    Def - Unpaid Weight
    nopaneltrue

    (lightbulb) Note: Unpaid Weight is only calculated for line-items with a 0.00 Price. Items with a negative price are not considered 'Unpaid'.

    Database Field: ERPx_CPTicketHeader.UnpaidWeight

    Version

    Identifies the version of the Ticket. A blank value signifies a version 1 ticket. All ticket versions greater than 1 will display.

    Insert excerpt
    Def - Version
    Def - Version
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.TicketVersion

    Weight In

    Identifies the 'Weight In' from the Ticket. This can be edited from the 'Weight In' field on the Ticket Record View for tickets that have not yet been Approved or Posted.

    Insert excerpt
    Def - Weight In
    Def - Weight In
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.WeightIn

    Weight Out

    Identifies the 'Weight Out' from the Ticket. This can be edited from the 'Weight Out' field on the Ticket Record View for tickets that have not yet been Approved or Posted.

    Insert excerpt
    Def - Weight Out
    Def - Weight Out
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.WeightOut

    ...