Versions Compared

Old Version 16

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 inquiry is to display

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.0708.01 26 and newer

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

...

This is a multi-select lookup that is not required to return results. It defaults as "All".

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

  • Delivered Date
  • Harvested Date
  • GL Date
Farmer
Insert excerpt
Def - FarmerDef - Farmer
nopaneltrue
Farmer Class
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:

  • PostedVoids
  • Repriced & Corrected
  • ReplacedUnpostedUnposted
  • 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

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

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

 Grower Accounting Ticket Classes.

Page Detail

Database Field: ERPx_CPTicketHeader.TicketVersion

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

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

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

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

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

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

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

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

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

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.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 'PropertiesHome' 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

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 - Tare Weight
nopaneltrue

Database Field: ERPx_CPTicketHeader.ContainerTare

VersionUnits

Identifies the

version

# of containers the Ticket

. A blank value signifies a version 1 ticket. All ticket versions greater than 1 will display.
Insert excerpt
Def - VersionDef - Version
nopaneltrue
Unpaid Wt.

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

...