Versions Compared

Old Version 8

changes.mady.by.user Tom Williams

Saved on

compared with

New Version 9

changes.mady.by.user Tom Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

...

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

Delivery Date
Insert excerpt
Date Control Text Box
Date Control Text Box
nopaneltrue
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".
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 'Active' 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".

Insert excerpt
Def - Transaction Class - General
Def - Transaction Class - General
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.

...

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Print
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue

Column Headers

Description
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Accruals
Charges
Crop
Delivery Date

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

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

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

Linked Database Field: ERPx_APVendor.VendorClassSK

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

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 Weight

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

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

Net Amount

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 Weight

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 - Net Weight
Def - Net Weight
nopaneltrue

Database Field: 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. 

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

Site

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

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

Status

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

Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName

Ticket

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
This is a system assigned value and is not editable.

Database Field: ERPx_CPTicketHeader.TicketNumber

Ticket Class

Insert excerpt
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 - Transaction Class - General
Def - Transaction Class - General
nopaneltrue

Database Field: ERPx_CPTicketHeader.TransactionClassSK

Unpaid Weight

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

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

...