Versions Compared

Old Version 3

changes.mady.by.user Emma Greenwood

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

Insert excerpt
Def - Grower Ticket
Def - Grower Ticket
nopaneltrue
 The purpose of this inquiry is to display Ticket items for all Tickets that have been posted.

(lightbulb) This inquiry also contains columns for each Attribute that is set up under the 'Grower Accounting Items' Master File attribute type and 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.0608.30 26 and newer

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

...

This is a multi-select lookup that is not required to return results. It defaults as "All".Farmer Class
  • GL Date

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".
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. The  It defaults to 'GL Date' and the lookup contains the following values:

  • Delivered Date
  • Harvested DateGL Date
Farmer
Insert excerpt
Def - FarmerDef - Farmer
nopaneltrue
Farmer
Insert excerpt
Def - Farmer
Class
Def - Farmer
Class
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. This  It defaults to 'Posted' and the lookup contains:

  • VoidsPostedReplaced
  • Repriced & Corrected
  • Unposted
  • Void
Item

Used to select one or more Items. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Ticket Items (GA)
Def - Ticket Items (GA)
nopaneltrue

The lookup contains a list of all 'Active' Ticket Items.

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
  • Ticket Item Description
  • Ticket Item ID 
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

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

    		Version

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

    Page Detail

    Toolbar Icons

    		Description
    Column Filter Show/Hide

    Insert excerpt
    Column Filter Show/Hide - Global
    Column Filter Show/Hide - Global
    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 - Multi-Select Trans Type - Global 3.0
    New - Multi-Select Trans Type - 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 - Global3.0 - Global
    nopaneltrue


    CheckboxtrueCropSK

    Crop that was harvested from the Field Ticket when initially creating a ticket Crop Crop CPTicketHeaderCropSKDelivered date was deliveredThis 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

    from the Farmer Master File Class ClassLinked APVendorVendorClassSKFarmer ID ID of Farmer that the ticket is assigned to This from the Vendor Master file.  Farmer FarmerAPVendor.VendorIDDef - FarmerCPTicketHeader.FieldSK

    Database Field: ERPx_CPTicketHeader.FarmerSK

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

    Database Field: ERPx_CPTicketHeader.FieldSKDatabase Field: ERPx_CPTicketHeader.PriceListSK

    Column Headers

    		Description
    Checkbox
    Insert excerpt
    Checkbox
    Checkbox
    nopaneltrue
    Accrual Amt.Checkbox

    Insert excerpt
    Def - Accrual Amt. (GA)
    Def - Accrual Amt. (GA)
    nopaneltrue

    Column Headers

    		Description

    Database Field: ERPx_CPTicketItem.AccrualAmount

    Charge Amt. 

    Insert excerpt

    		Checkbox

    Def - Charge Amt. (GA)
    Def - Charge Amt. (GA)
    nopaneltrue

    Accrual Amt

    Database Field: ERPx_CPTicketItem.ChargeAmount

    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 -
    Accrual Amt. (GA)
    Crop
    Def -
    Accrual Amt. (GA)
    Crop
    nopaneltrue

    Database Field: ERPx_CPTicketItemCPTicketHeader.AccrualAmount

    		Charge Amt. 

    Insert excerpt
    Def - Charge Amt. (GA)Def - Charge Amt. (GA)nopanel
    Delivered

    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_CPTicketItemCPTicketHeader.ChargeAmountDeliveryDate

    Crop
    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

    Linked Database Field:

    ERPx_

    APVendor.

    VendorClassSK

    Farmer ID

    Identifies the

    ID of the Farmer that the ticket

    is assigned to. 

    This can only be edited

    		Farmer Class

    Identifies the Class assigned to the Farmer on the ticketfrom the Vendor Master file. 

    Insert excerpt
    Def - Farmer
    Def - Farmer
    nopaneltrue

    Database Field: ERPx_APVendor.VendorID

    Farmer Name

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

    when initially creating a ticket.

    Insert excerpt
    Def - Farmer

    Def - Farmer

    nopaneltrue

    Database Field: ERPx_

    CPTicketHeader.

    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_

    		Farmer Name

    Identifies the Farmer that the ticket is assigned to. This can only be edited when initially creating a ticket.

    Insert excerpt
    Def - Farmer
    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
    		Field
    Insert excerpt
    Def - FieldDef - Field
    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 Amt.

    Displays the Extended Amount of the line item. This is a calculated field and can only be edited by changing the weight or price of the line item.

    Database Field: ERPx_CPTicketItem.GrossAmount

    Harvested

    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

    Item

    Insert excerpt
    Item ID & Item Description
    Item ID & Item Description
    nopaneltrue
     This is required.

    Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescription

    Item Type

    A text box to display the 'Item Type' assigned to the Ticket Item. This can only be edited from the Ticket Items Record View.

    Insert excerpt
    Item Type (GA)
    Item Type (GA)
    nopaneltrue

    Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN

    Net Amt.

    Insert excerpt
    Def - Net Amt. (GA)
    Def - Net Amt. (GA)
    nopaneltrue
     This is a calculated field and is not editable.

    Database Field: ERPx_CPTicketItem.NetAmount

    Net Wt.

    Insert excerpt
    Def - Delivered Wt. (GA)
    Def - Delivered Wt. (GA)
    nopaneltrue
     This is editable from the Ticket Record View.

    Database Field: ERPx_CPTicketItem.TotalWeight

    Paid Wt.

    Identifies the weight of the line item with a non-zero price. This can only be edited by editing the 'Price' on the 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_CPTicketItem.PaidWeight

    Price

    Identifies the price of the line item. This can only be edited by editing the 'Price' on the ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted. 

    Database Field: ERPx_CPTicketItem.Price

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

    Price UOM

    Identifies the unit of measure which the line item's price is based upon. This can only be edited by changing the

    price list assigned to the farmer.

    value selected in the "Scale Weight UOM" preference.

    Database Field: ERPx_MFPriceListItemHistory.PriceUOMSK

    Purchase GL AccountDef - Price List
    nopaneltrue
    Insert excerpt

    Def - Price List

    GL Account - Purchases (GA)
    GL Account - Purchases (GA)
    nopaneltrue
     This is required for any Ticket Item that has a Net Amount <> 0.00. This is editable from the Item grid on the Ticket Record View until the Ticket is Approved or Posted.

    Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.PurchaseGLAccountSK

    Sample

    Identifies the weight of the sample that graded out for the line item. This is required and can be edited from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Posted.

    Database Field: ERPx_CPTicketItem.SampleWeight

    Sample Pct.

    Identifies the percentage of the entire sample that graded out for the line item. This is a calculated field and can be edited by editing the 'Sample Size' from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Posted.

    Database Field: ERPx_CPTicketItem.SampleWeightPercent

    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 - New
    Def - Status - New
    nopaneltrue

    Insert excerpt
    Def - Status - Received
    Def - Status - Received
    nopaneltrue

    Insert excerpt
    Def - Status - Graded
    Def - Status - Graded
    nopaneltrue

    Insert excerpt
    Def - Status - Reviewed
    Def - Status - Reviewed
    nopaneltrue

    Insert excerpt
    Def - Status - Approved
    Def - Status - Approved
    nopaneltrue

    Insert excerpt
    Def - Status - Ready to Post
    Def - Status - Ready to Post
    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 Created

    Insert excerpt
    Created
    Created
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.CreatedDate

    Ticket Created By

    Insert excerpt
    Created By
    Created By
    nopaneltrue

    Database Field: ERPx_CPTicketHeader.CreatedBy

    Ticket Last Updated

    Insert excerpt
    Last Updated
    Last Updated
    nopaneltrue

    Database Field: ERPx_CPTicketItem.LastUpdated

    Ticket Last Updated By

    Insert excerpt
    Last Updated By
    Last Updated By
    nopaneltrue

    Database Field: ERPx_CPTicketItem.LastUser

    Units

    Identifies the # of containers the Ticket Item was delivered in. This is not required and is editable until the Ticket is Approved or Posted.

    Database Field: ERPx_CPTicketItem.Units

    Unpaid Wt.

    Identifies the weight of the line item 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_CPTicketItem.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 UOM

    Identifies the Weight Unit of Measure of the line item. This comes from the Scale Weight UOM preference and UOM field on the Ticket Record View. It can only be edited from the preference for tickets that have not yet been Approved or Posted.

    Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK

    Related Topics


    Expand
    titlePage Definitions


    ...