/
Ticket Lines List View

Ticket Lines List View

Aug 31, 2022

 The purpose of this list view is to display Ticket items, Accruals and Charges (if applicable) for all Tickets that have not been posted. From this list view, users may open the corresponding Ticket. 

 This list view 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

[ 1 Page Header  ] [ 2 Columns ] [ 2.1 Related Topics ]

Page Header 

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Edit

Excel

Favorites

Group By Show/Hide

Help

New

Print

Quick Column Filter

Refresh

Saved Layouts

Columns

Column Headers

Description

Column Headers

Description

Checkbox

Accrual Amt.

Database Field: ERPx_CPTicketItem.AccrualAmount

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

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

Delivered Wt.

 This is a calculated field that cannot be edited unless:

  • One or more of the following header values are edited: Weight In, Weight Out, or Total Tare

  • One or more of the following ticket items values are edited: Sample or Sample Pct.

Database Field: ERPx_CPTicketItem.TotalWeight

Farmer Class

Identifies the Class assigned to the Farmer. This can only be edited by changing the 'Vendor Class ID' value on the Vendor Record View.

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 by changing the 'Vendor ID' value on the Vendor Record View. 

Database Field: ERPx_APVendor.VendorID

Farmer Name

Identifies the Farmer that the ticket is assigned to. This can only be edited by changing the 'Vendor Name' value on the Vendor Record View.

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.

 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.

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

Item

For Ticket Items - 

For Charge and Accrual Items - Display the Program ID

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

Item Type

 This can only be edited from the Ticket Items Record View.

 This is not populated for rows where the 'Row Type' = 'Charge' or 'Accrual'.

Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN

Last Updated

Database Field: ERPx_CPTicketItem.LastUpdated

Last Updated By

Database Field: ERPx_CPTicketItem.LastUser

Net Amt.

 This is a calculated field and is not editable.

Database Field: ERPx_CPTicketItem.NetAmount

Paid Wt.

 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. 

 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

 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.

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 value selected in the "Scale Weight UOM" preference.

Database Field: ERPx_MFPriceListItemHistory.PriceUOMSK

Purchase GL Account

 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

 This is editable 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.

 This is a calculated field that can only be edited by changing either the 'Sample' or 'Sample Pct.' on a Ticket Item.

Database Field: ERPx_CPTicketItem.SampleWeightPercent

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

Ticket Created

Database Field: ERPx_CPTicketHeader.CreatedDate

Ticket Created By

Database Field: ERPx_CPTicketHeader.CreatedBy

Units

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

Database Field: ERPx_CPTicketItem.Units

Unpaid Wt.

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

Version

Identifies the version of the Ticket. This is a system assigned value and is not editable. A blank value signifies a version 1 ticket. All ticket versions greater than 1 will display with a numeric value.

Database Field: ERPx_CPTicketHeader.TicketVersion