Versions Compared

Old Version 1

changes.mady.by.user Tom Williams

Saved on

compared with

New Version 2

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 Ticket items for all Tickets that have been posted.

(lightbulb) 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)
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".
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
  • Ticket Item Description
  • Ticket Item ID 
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.

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

Toolbar Icons

Description
Column Filter Show/Hide

Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue

Edit

Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
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
New
Insert excerpt
New - Multi-Select Trans Type - Global 3.0
New - Multi-Select Trans Type - 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

...

Column Headers

Description
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Accruals
Charges
Created

This column has not yet been added.

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_CPTicketHeader.CreatedDate

Created By

This column has not yet been added.

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

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

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

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.

Insert excerpt
Def - Harvester
Def - Harvester
nopaneltrue

Database Field: ERPx_CPTicketHeader.HarvesterSK

Hauler

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.

Insert excerpt
Def - Hauler
Def - Hauler
nopaneltrue

Database Field: ERPx_CPTicketHeader.HaulerSK

Last Updated

This column has not yet been added.

Insert excerpt
Item Last Updated (Date & Time)
Item Last Updated (Date & Time)
nopaneltrue

Database Field: ERPx_CPTicketItem.LastUpdated

Last Updated By

This column has not yet been added.

Insert excerpt
Item Last Updated By
Item Last Updated By
nopaneltrue

Database Field: ERPx_CPTicketItem.LastUser

Item

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
 This is required.

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

Insert excerpt
Item Type : Grower Accounting(GA)
Item Type : Grower Accounting(GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN

Row Type
Paid Weight

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

Price

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

Sample Percent

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

Sample 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

Site Name

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 - New
Def - Status - New
nopaneltrue

Received:

Graded:

Reviewed:

Insert excerpt
Def - Status - Approved
Def - Status - Approved
nopaneltrue

Insert excerpt
Def - Status - Ready to Post
Def - Status - Ready to Post
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. Clicking on this link opens the transaction record view. 

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

Ticket Version

This column has not yet been added.

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

Unpaid Weight

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

Weight

Identifies the Net Weight of the line item. This can only be edited 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_CPTicketItem.TotalWeight

Weight UOM

...