Insert excerptDef - Grower TicketDef - Grower Ticketnopaneltrue 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.

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: 2021.11.05 and newer

Table of Contents

exclude	(Toolbar Icons\|Column Headers)
type	flat

Page Header

Search

...

Filter Items

...

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

...

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

...

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

...

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.

Page Detail

...

Column Headers

...

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

...

Insert excerpt

	Def - Grower Ticket
	Def - Grower Ticket
nopanel	true

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.

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.08.26 and newer

Table of Contents

exclude	(Toolbar Icons\|Column Headers)
type	flat

Page Header

Search

Filter Items

Description

Auto Hide Filters

Insert excerpt

	Auto Hide Filters
	Auto Hide Filters
nopanel	true

Auto Refresh on Open

Insert excerpt

	Auto Refresh on Open
	Auto Refresh on Open
nopanel	true

Crop

Insert excerpt

	Def - Crop
	Def - Crop
nopanel	true

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
nopanel	true

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
nopanel	true

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
nopanel	true

Search

Insert excerpt

	Search - Search Options
	Search - Search Options
nopanel	true

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
nopanel	true

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
nopanel	true

The lookup contains a list of all Sites.

Ticket Class

Insert excerpt

	Inq - Transaction Class
	Inq - Transaction Class
nopanel	true

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
nopanel	true

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

Page Detail

GrossChargesAmount

Database Field: ERPx_CPTicketHeader.CreatedDate

Database Field: ERPx_CPTicketHeader.CreatedBy

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

Database Field: ERPx_CPTicketHeader.CropSK

Identifies the date the ticket was delivered. This can only be edited by editing the 'Delivered' field on the yet

Database Field: ERPx_CPTicketHeader.DeliveryDate

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

Class assigned to the Farmer on the ticket. This from the Farmer Master File. Farmer Class Farmer ClassLinked APVendorVendorClassSK

by editing the 'Harvested' field on the Ticket Record View for tickets that have not yet been Approved or Posted.

Database Field: ERPx_CPTicketHeader.

FieldSK This is required for the transaction to be approved or posted. It can be edited from the 'GL Date' field 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 HarvesterSK

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

Print

Insert excerpt

	Print - LV 3.0
	Print - LV 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global 3.0
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Search Options

Insert excerpt

	Search Options - Inquiry Grid 3.0
	Search Options - Inquiry Grid 3.0
nopanel	true

Column Headers

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

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
nopanel	true

Database Field: ERPx_CPTicketHeader.CreatedDate

Created By

Insert excerpt

	Created By
	Created By
nopanel	true

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
nopanel	true

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
nopanel	true

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
nopanel	true

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
nopanel	true

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
nopanel	true

Database Field: ERPx_CPTicketHeader.FieldSK

GL Date

Insert excerpt

	GL Date
	GL Date
nopanel	true

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.

Created

Created By

Crop

Insert excerpt

Def - Crop

nopanel

true

Delivery Date

GLDate

GL Period

Insert excerpt

	GL Period
	GL Period
nopanel	true

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
nopanel	true

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.

Farmer

Insert excerpt

Def - Farmer

nopanel

true

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

Farmer Class

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
nopanel	true

Database Field: ERPx_

CPTicketHeader.

GrossWeight

FieldHarvested

Identifies the

Field

date the ticket was harvested

from

. This can only be edited

when initially creating a ticket.

Insert excerpt

Def - Field

nopanel

true

GL Date

Insert excerpt

GL Date

nopanel

true

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
nopanel	true

Database Field: ERPx_CPTicketHeader.GLDate

GL Period

Insert excerpt

GL Period

nopanel

true

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. This field is not stored in the database.

GL Year

Insert excerpt

	Def - Hauler
	Def - Hauler
nopanel	true

Database Field: ERPx_CPTicketHeader.HaulerSK

Last Updated

GL Year

Insert excerpt

GL Year

Item Last Updated (Date & Time)
	Item Last Updated (Date & Time)
nopanel	true

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 Amount

Database Field: ERPx_CPTicketHeader.LastUpdated

Last Updated By

Insert excerpt

	Last Updated By
	Last Updated By
nopanel	true

Database Field: ERPx_CPTicketHeader.LastUser

Net Amt.

Displays the sum of the Extended Amount for all line itemsline items, minus any applied 'Charges'. This is a calculated field and can only be edited by changing the weight or price of one or more line itemsis not editable.

Database Field: ERPx_CPTicketHeader.GrossTicketAmount

Gross Weight

NetTicketAmount

Net Wt.

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

Insert excerpt

	Def - Gross Delivered Weight
	Def - Gross Delivered Weight
nopanel	true

Database Field: ERPx_CPTicketHeader.GrossWeight

Harvest Date

NetWeight

Paid Wt.

Identifies

the date the ticket was harvested.

the sum of the weight of all the ticket line items with a non-zero price. This can only be edited by editing the '

Harvested' field

Price' of a ticket line on the Ticket Record View for tickets that have not yet been

Approved or Posted

Approved or Posted.

Insert excerpt

	Def - Paid Weight
	Def - Paid Weight
nopanel	true

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.

HarvestDate

PaidWeight

Harvester

Database Field: ERPx_CPTicketHeader.HarvesterSK

Hauler

Database Field: ERPx_CPTicketHeader.HaulerSK

Last Updated

Database Field: ERPx_CPTicketHeader.LastUpdated

Last Updated ByPrice 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
nopanel	true

Database Field: ERPx_CPTicketHeader.

LastUser

PriceListSK

Net AmountSample SizeDisplays

Identifies the

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

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.

NetTicketAmountNet WeightIdentifies 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

SampleWeight

Site Name

Insert excerpt

	Site Name
	Site Name
nopanel	true

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

Insert excerpt

	Def -

Net Weight

Site
	Def -

Net Weight

Site
nopanel	true

Database Field:Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.NetWeight

Paid Weight

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

Status

Insert excerpt

	Status
	Status
nopanel	true

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

Insert excerpt

	Def - Status
	Def - Status
nopanel	true

The Statuses that apply to transactions in this Inquiry include:

Insert excerpt

	Def - Status - Posted
	Def - Status - Posted
nopanel	true

Insert excerpt

	Def - Status -

Paid Weight

Void
	Def - Status -

Paid Weight

Void
nopanel	true

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.TicketStatusSK, ERPx_CPTicketStatus.StatusName

Ticket

Insert excerpt

	Transaction ID
	Transaction ID
nopanel	true

This is a system assigned value and is not editable. Clicking on this link opens the transaction record view.

Database Field: ERPx_CPTicketHeader.PaidWeightTicketNumber

SiteTicket Class

Insert excerpt

Site

	Transaction Class

Site

	Transaction Class
nopanel	true

This comes from the '

Site' lookup on the Ticket Record View. It

Transaction Class' value selected by the user when the transaction was created. It is not editable.

Excerpt

-include

	Def - Transaction Class - General
	Def -

SiteDef - Site

Transaction Class - General
nopanel	true

Database

Fields: ERPx_MFSite.SiteName,

Field: ERPx_CPTicketHeader.

SiteSK

TransactionClassSK

Status Insert excerptStatusStatusnopaneltrue This comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable.
Insert excerptDef - StatusDef - Statusnopaneltrue The Statuses that apply to transactions in this Inquiry include: Insert excerptDef - Status - PostedDef - Status - Postednopaneltrue Insert excerptDef - Status - VoidDef - Status - Voidnopaneltrue

Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName

Ticket Insert excerptTransaction IDTransaction IDnopaneltrue This is a system assigned value and is not editable.

Database Field: ERPx_CPTicketHeader.TicketNumber

Ticket Class Insert excerptTransaction ClassTransaction Classnopaneltrue This comes from the 'Transaction Class' value selected by the user when the transaction was created. It is not editable. Insert excerptDef - Transaction Class - GeneralDef - Transaction Class - Generalnopaneltrue

Database Field: ERPx_CPTicketHeader.TransactionClassSK

Unpaid WeightTotal 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
nopanel	true

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 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
nopanel	true

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
nopanel	true

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
nopanel	true

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
nopanel	true

Database Field: ERPx_CPTicketHeader.WeightOut

Versions Compared

Old Version 10

New Version Current

Key

Page Header

Search

Filter Items

Page Detail

Column Headers

Page Header

Search

Filter Items

Page Detail

Column Headers

Page Comparison

Versions Compared

Old Version 10

New Version Current

Key

Page Header

Search

Filter Items

Page Detail

Column Headers

Page Header

Search

Filter Items

Page Detail

Column Headers