Insert excerptDef - Grower TicketDef - Grower Ticketnopaneltrue The purpose of this inquiry is to display Ticket items for all Tickets that have been posted.

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

Table of Contents

exclude	(Toolbar Icons\|Column Headers\|Toolbar Icon)
type	flat

Page Header

Search

...

Filter Items

...

Insert excerpt

	Def - Grower Ticket
	Def - Grower Ticket
nopanel	true

The purpose of this inquiry is to display Ticket items for all Tickets that have been posted.

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

Table of Contents

exclude	(Toolbar Icons\|Column Headers\|Toolbar Icon)
type	flat

Page Header

Search

Delivery Date Insert excerptDate Control Text BoxDate Control Text Box

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

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

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

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

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

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

FarmerDef - Farmer

Edit

Insert excerpt

Def - Farmer

Saved Searches

Edit - LV 3.0
	Edit - LV 3.0
nopanel	true

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

Excel

Insert excerpt

Search Options for Framework 3.0 - Global

Excel - LV 3.0

- Global


	Excel - LV 3.0
nopanel	true

Search

Favorites

Insert excerpt

Search - Search OptionsSearch - Search Optionsnopaneltrue

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

Inq - Site

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

Group By Show/Hide

Insert excerpt

Inq - Site

lect lookup that is not required to return results. It defaults as "All".

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

It displays as [Site Name]. This is a multi-seDef - Site

Help

Insert excerpt

Def - Site

Help - Global 3.0
	Help - Global 3.0
nopanel	true

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

Ticket ClassInq - Transaction Class

New

Insert excerpt

Inq - Transaction Class

New - Multi-Select Trans Type - Global 3.0
	New - Multi-Select Trans Type - Global 3.0
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".Def - Transaction Class - General

Print

Insert excerpt

Def - Transaction Class - General

Print - LV 3.0
	Print - LV 3.0
nopanel	true

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

Ticket ItemVersion

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

This column has not yet been added.

Created

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

Column Filter Show/Hide - Global

nopanel

true

Edit

Insert excerpt

Edit - LV 3.0

nopanel

true

Excel

Insert excerpt

Excel - LV 3.0

nopanel

true

Favorites

Insert excerpt

Favorites Add/Remove - Global

nopanel

true

Group By Show/Hide

Insert excerpt

Group By Show/Hide - Global

nopanel

true

Help

Insert excerpt

Help - Global 3.0

nopanel

true

New

Insert excerpt

New - Multi-Select Trans Type - Global 3.0

nopanel

true

Print

Insert excerpt

Print - LV 3.0

nopanel

true

Quick Column Filter

Insert excerpt

Quick Column Filter

nopanel

true

Refresh

Insert excerpt

Refresh - Global 3.0

nopanel

true

Saved Layouts

Insert excerpt

Column Layouts for Framework 3.0 - Global

nopanel

true

Column Headers

Description

Checkbox

Insert excerpt

Checkbox

nopanel

true

Accruals

Charges

Created

Insert excerpt

Created

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

CreatedDate

This column has not yet been added.

Created By

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.

Def - Crop

Database Field: ERPx_CPTicketHeader.CropSK

Identifies the date the ticket was delivered. This can only be edited Delivered 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.

Database Field: ERPx_CPTicketHeader.FarmerSK

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

Linked Database Field: ERPx_APVendor.VendorClassSK

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

This column has not yet been added.

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.

Def - HarvesterCPTicketHeader.HarvesterSK

This column has not yet been added.

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 Hauler HaulerCPTicketHeaderHaulerSKThis column has not yet been addedItem Last Updated (Date & TimeLastUpdatedThis column has not yet been added.Item Last Updated ByLastUser This is required.Price

Column Headers

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Accrual Amt.

Insert excerpt

	Def - Accrual Amt. (GA)
	Def - Accrual Amt. (GA)
nopanel	true

Database Field: ERPx_CPTicketItem.AccrualAmount

Charge Amt.

Insert excerpt

	Def - Charge Amt. (GA)
	Def - Charge Amt. (GA)
nopanel	true

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

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

Created By

Insert excerpt

Created By

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

GL Period

Insert excerpt

	GL Period
	GL Period
nopanel	true

Crop

Insert excerpt

Def - Crop

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

Delivery Date

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

Farmer Class

Insert excerpt

Def - Farmer Class

nopanel

true

Field

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

Database Field: ERPx_CPTicketHeader.

HarvesterSK

Gross Amount

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

Harvest Date

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

Insert excerpt

Def - Harvester

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

Database Field: ERPx_CPTicketHeader.HaulerSK

Item

Insert excerpt

	Item ID & Item Description
	Item ID & Item Description
nopanel	true

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

Database Field: ERPx_

Hauler

CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN

Net Amt.

Insert excerpt

	Def -

Net Amt. (GA)
	Def -

Net Amt. (GA)
nopanel	true

This is a calculated field and is not editable.

Database Field: ERPx_

CPTicketItem.

Last Updated

NetAmount

Net Wt.

Insert excerpt

Item Last Updated (Date & Time)

Def - Delivered Wt. (GA)
	Def - Delivered Wt. (GA)
nopanel	true

This is editable from the Ticket Record View.

Database Field: ERPx_CPTicketItem.

Last Updated By

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

Item Last Updated By

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

PaidWeight

Item

Insert excerpt

Item ID & Item Description

nopanel

true

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.ItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescription

Item CR Acct

Item DR Acct

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 ViewPrice

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.

Item Type (GA)

Insert excerpt

Item Type (GA)

Def - Price List
	Def - Price List
nopanel	true

Database Field: ERPx_

CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeENRow TypePaid WeightIdentifies the weight of the line item with a non-zero price. This

CPTicketHeader.PriceListSK

Price UOM

Identifies the unit of measure which the line item's price is based upon. 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.

changing the value selected in the "Scale Weight UOM" preference.

Database Field: ERPx_MFPriceListItemHistory.PriceUOMSK

Purchase GL AccountDef - Paid Weight

Insert excerpt

Def - Paid Weight

GL Account - Purchases (GA)
	GL Account - Purchases (GA)
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_CPTicketItem.PaidWeight

Price

Identifies the price of the line item. This can only be edited by editing the 'Price' on the ticket line 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

yet

been Approved or Posted.

Database Field: ERPx_CPTicketItem.

Price

SampleWeight

Sample PercentPct.

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

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

Insert excerpt

Database Field:

	Def - Site
	Def - Site
nopanel	true

Database Fields:

Site Name

Insert excerptSiteSitenopaneltrueThis comes from the 'Site' lookup on the Ticket Record View. It is not editable. ERPx_MFSite.SiteName, ERPx_

CPTicketItem.SampleWeightPercentSample Weight

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

CPTicketHeader.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 - New
	Def - Status - New
nopanel	true

Insert excerpt

	Def - Status - Received
	Def - Status - Received
nopanel	true

Insert excerpt

	Def -

Site

Status - Graded
	Def -

Site

Status - Graded
nopanel	true

Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

Status

Insert excerpt

	Def - Status - Reviewed
	Def - Status - Reviewed
nopanel	true

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved
nopanel	true

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

Insert excerpt

	Def - Status - Ready to Post
	Def - Status - Ready to Post
nopanel	true

The Statuses that apply to transactions in this Inquiry include:

Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName

TicketDef - Status - New

Insert excerpt

Def - Status - New

Insert excerptDef - Status - ApprovedDef - Status - Approvednopaneltrue

Transaction ID
	Transaction ID
nopanel	true

Received:

Graded:

Reviewed:

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

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

Insert excerpt

	Def -

Status - Ready to Post

Transaction Class - General
	Def -

Status - Ready to Post

Transaction Class - General
nopanel	true

Database Field: ERPx_CPTicketHeader.

TicketStatusSK, ERPx_CPTicketStatus.StatusName

TransactionClassSK

Ticket Created

Insert excerpt

Transaction ID

	Created

Transaction ID

	Created
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.CreatedDate

Ticket Created By

Insert excerpt

	Created By
	Created By
nopanel	true

Database Field: ERPx_CPTicketHeader.

TicketNumber

CreatedBy

Ticket ClassLast UpdatedTransaction Class

Insert excerpt

Transaction Class

Last Updated
	Last Updated
nopanel	true

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

Database Field: ERPx_CPTicketItem.LastUpdated

Last Updated By

Def - Transaction Class - General

Insert excerpt

Def - Transaction Class - General

Last Updated By
	Last Updated By
nopanel	true

Database Field: ERPx_CPTicketHeaderCPTicketItem.TransactionClassSK

Ticket VersionThis column has not yet been added.

LastUser

Units

Identifies the

version

# of containers the Ticket

. A blank value signifies a version 1 ticket. All ticket versions greater than 1 will display. Insert excerptDef - VersionDef - Versionnopaneltrue

Database Field: ERPx_CPTicketHeader.TicketVersion

Unpaid Weight

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
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_CPTicketItem.UnpaidWeight

WeightVersion

Identifies the

Net Weight

version of the

line item. This can only be edited on the Ticket Record View for tickets that have not yet been Approved or Posted

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

Insert excerpt

	Def -

Net Weight

Version
	Def -

Net Weight

Version
nopanel	true

Database Field: ERPx_

CPTicketItem.TotalWeightWeight UOM

CPTicketHeader.TicketVersion

Versions Compared

Old Version 2

New Version Current

Key

Page Header

Search

Filter Items

Page Header

Search

Filter Items

Page Detail

Toolbar Icons

Page Detail

Toolbar Icons

Column Headers

Column Headers

Related Topics

Page Comparison

Versions Compared

Old Version 2

New Version Current

Key

Page Header

Search

Filter Items

Page Header

Search

Filter Items

Page Detail

Toolbar Icons

Page Detail

Toolbar Icons

Column Headers

Column Headers

Related Topics