Versions Compared

Old Version 11

changes.mady.by.user Tom Williams

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

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

Page Header 

...

Filter Items

...

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

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

Page Header 

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' and the lookup contains the following values:

  • Delivered Date
  • Harvested Date
  • GL Date
Farmer
Insert excerpt
Def - Farmer
Def - Farmer
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. 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
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 Sites.

Ticket Class

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

Delivery Date

Insert excerpt
Def - Transaction Class - General
Def - Transaction Class - General
nopaneltrue

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

Page Detail

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Date Control Text BoxDate Control Text BoxColumn Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
FarmerExcelDef - Farmer
Insert excerpt
Def - Farmer
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
This is a multi-select lookup that is not required to return results. It defaults as "All".Saved Searches
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Search Options for Framework 3.0 Group By Show/Hide - GlobalSearch Options for Framework 3.0
Group By Show/Hide - Global
nopaneltrue
SearchHelpSearch - Search Options
Insert excerpt
Search - Search Options
Help - Global 3.0
Help - Global 3.0
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
SitePrint
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Quick Column FilterInq - Site
Insert excerpt
Inq - Site
Quick Column Filter
Quick Column Filter
nopaneltrue
 It displays as [Site Name]. This is a multi-select lookup that is not required to return results. It defaults as "All". RefreshDef - Site
Insert excerpt
Def - Site
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue

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

Ticket ClassSaved LayoutsInq - Transaction Class
Insert excerpt
Inq - Transaction Class
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
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".Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue

Column Headers

DescriptionCheckboxToolbar IconsDescriptionColumn Filter Show/Hide Insert excerptColumn Filter Show/Hide - GlobalColumn Filter Show/Hide - GlobalnopaneltrueExcel Insert excerptExcel - LV 3.0Excel - LV 3.0nopaneltrueFavorites Insert excerptFavorites Add/Remove - GlobalFavorites Add/Remove - GlobalnopaneltrueGroup By Show/Hide Insert excerptGroup By Show/Hide - GlobalGroup By Show/Hide - GlobalnopaneltrueHelp Insert excerptHelp - Global 3.0Help - Global 3.0nopaneltruePrint Insert excerptPrint - LV 3.0Print - LV 3.0nopaneltrueQuick Column Filter Insert excerptQuick Column FilterQuick Column FilternopaneltrueRefresh Insert excerptRefresh - Global 3.0Refresh - Global 3.0nopaneltrueSaved layouts Insert excerptColumn Layouts for Framework 3.0 - GlobalColumn Layouts for Framework 3.0 - GlobalnopaneltrueSearch Options Insert excerptSearch Options - Inquiry Grid 3.0Search Options - Inquiry Grid 3.0nopaneltrue

Column Headers

DescriptionCheckbox Insert excerptCheckboxCheckboxnopaneltrueAccrualsDisplays 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.Def - Transaction Class - General
Insert excerpt
Def - Transaction Class - General
Checkbox
Checkbox
nopaneltrue

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

Version

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

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.

Farmer Class Class assigned to the Farmer on the ticket. This from the Farmer Master File. Farmer Class Farmer ClassLinked APVendorVendorClassSK Field FieldFieldSK This is required for the transaction to be approved or posted. It can be edited from the 'GL Date' field Hauler 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

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.

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

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.

CreatedCreated ByCrop
Insert excerpt
Def - CropDef - Crop
nopaneltrue
Delivery Date

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.Farmer
Insert excerpt
Def - FarmerDef - Farmer
nopaneltrue
 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.

FarmerSK

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

FieldHarvested

Identifies the

Field

date the ticket was harvested

from

. This can only

be edited when initially creating a ticket

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

GL Date
Insert excerpt
GL DateGL Date
nopaneltrue

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

GL PeriodLast Updated

Insert excerpt
GL PeriodGL Period
nopaneltrue
Item Last Updated (Date & Time)
Item Last Updated (Date & Time)
nopaneltrue

Database Field: ERPx_CPTicketHeader.LastUpdated

Last Updated ByGL Year

Insert excerpt

GL Year

Last Updated By
Last Updated By
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

true

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

Database Field: ERPx_CPTicketHeader.GrossWeight

Harvest Date

NetWeight

Paid Wt.

Identifies the

date the ticket was harvested. 

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.

Database Field: ERPx_CPTicketHeader.HarvestDate

Harvester

Database Field: ERPx_CPTicketHeader.HarvesterSK

Hauler

Database Field: ERPx_CPTicketHeader.HaulerSK

Last Updated

Database Field: ERPx_CPTicketHeader.LastUpdated

Last Updated By

Database Field: ERPx_CPTicketHeader.LastUser

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

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.

NetTicketAmount

PaidWeight

Net WeightPrice List

Identifies the

'Weight In' from the Ticket.

Price List associated with the Farmer on 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. 

only be edited by changing the price list assigned to the farmer.

Insert excerpt
Def -

Net Weight

Price List
Def -

Net Weight

Price List
nopaneltrue

Database Field: ERPx_CPTicketHeader.

NetWeight

PriceListSK

Paid WeightSample Size

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

yet been Approved or Posted

been Approved or Posted.

Database Field: ERPx_CPTicketHeader.SampleWeight

Site Name

Database Field: ERPx_CPTicketHeader.PriceListSK

Sample WeightDatabase Field:

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 -
Paid Weight
Site
Def -
Paid Weight
Site
nopaneltrue

(lightbulb) Note: Paid Weight is calculated for line-items with a non-zero Price. Items with a negative price are considered 'paid'.

Database FieldDatabase Fields: ERPx_CPTicketHeader.PaidWeight

Price List

MFSite.SiteName, ERPx_CPTicketHeader.

SampleWeight

SiteSK

SiteStatus

Insert excerpt
Site
Status
Site
Status
nopaneltrue
This comes from the 'SiteStatus' lookup on the 'Home' tab of the Ticket Record View. It is not editable. 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 -
Site
Status - Void
Def - Status -
Site
Void
nopaneltrue

Database FieldsField: ERPx_MFSiteCPTicketHeader.SiteNameTicketStatusSK, ERPx_CPTicketHeader.SiteSK

Status

Insert excerptStatusStatusnopaneltrueThis comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable.  ERPx_CPTicketStatus.StatusName

Ticket

Def - Status

Insert excerpt
Def - Status
Transaction ID
Transaction ID
nopaneltrue
 The Statuses that apply to transactions in this Inquiry include: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 ClassDef - Status - Posted

Insert excerpt

Def - Status - Posted

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 -

Status

Transaction Class -

Void

General
Def -

Status

Transaction Class -

Void

General
nopaneltrue

Database Field: ERPx_CPTicketHeader.

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

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 -
Transaction Class - General
Tare Weight
Def -
Transaction Class - General
Tare Weight
nopaneltrue

Database Field: ERPx_CPTicketHeader.TransactionClassSK

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

TicketVersion

Units

Unpaid WeightWt.

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

...