/
Ticket History Inquiry

Ticket History Inquiry

Aug 31, 2022

 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

[ 1 Page Header  ] [ 1.1 Search ] [ 1.1.1 Filter Items ] [ 2 Page Detail ] [ 2.1 Related Topics ]

Page Header 

Search

Filter Items

Description

Auto Hide Filters

Auto Refresh on Open

Crop

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

Date Range

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

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

Search

  • 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

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

The lookup contains a list of all Sites.

Ticket Class

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

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

Page Detail

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

Print

Quick Column Filter

Refresh

Saved Layouts

Search Options

Column Headers

Description

Checkbox

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

Database Field: ERPx_CPTicketHeader.CreatedDate

Created By

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.

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.

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. 

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.

Database Field: ERPx_CPTicketHeader.FarmerSK

Field

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

Database Field: ERPx_CPTicketHeader.FieldSK

GL Date

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

 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

 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. 

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.

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.

Database Field: ERPx_CPTicketHeader.HaulerSK

Last Updated

Database Field: ERPx_CPTicketHeader.LastUpdated

Last Updated By

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. 

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. 

 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.

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 'Home' tab of the Ticket Record View for tickets that have not been Approved or Posted.

Database Field: ERPx_CPTicketHeader.SampleWeight

Site Name

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

Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

Status

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

 The Statuses that apply to transactions in this Inquiry include:

Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName

Ticket

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

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

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.

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.

 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.

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.

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.

Database Field: ERPx_CPTicketHeader.WeightOut