Grower Accounting Tickets record the purchase of crops or aquaculture harvests. The purpose of this inquiry is to display Ticket items for all Tickets that have been posted.
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
Page Header
Toolbar Icons | Description |
|---|---|
| Column Filter Show/Hide |
|
| Edit |
|
| Excel |
|
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| Group By Show/Hide |  Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
| Help |  Opens the online WIKI help page for the current page. |
| New |  Allows users to select the type of transaction or record they want to add. |
 Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. When clicked, all the Reports that launch from the Print Dialog that are assigned to this page, and that the user has rights to (if Report Data Access is enabled) are displayed. | |
| Quick Column Filter |  Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
| Refresh |  Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options.
|
| Saved Layouts |  Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
Columns
Column Headers | Description |
|---|---|
| Checkbox | Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete. |
| Accruals | |
| Charges | |
| Created | This column has not yet been added. Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_CPTicketHeader.CreatedDate |
| Created By | This column has not yet been added. Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. 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. Crops are used in Grower Accounting to identify the unique combination of Commodity and Variety. 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. A Farmer is an Account Type used to identify entities you purchase farmed products from. They are used in Grower Accounting master files and transactions. 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.Farmer Classes are used to identify default values that will be applied to new Farmer accounts and to group Farmers together for reporting purposes. 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. Fields represent the objects farmers grow crops in. A field is unique by combination of: [Field Name] + [Farmer Name] + [Crop] + [Growth Method]. For Example, you can have Field #1 for Farmer ABC and for Farmer XYZ. Fields are used in Grower Accounting master files and transactions. 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. Harvesters are used in Grower Accounting to identify the entity that harvested the crop being purchased. 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. Haulers are used in Grower Accounting to identify the entity that delivered the crop to the plant, cooler, or co-packer. Database Field: ERPx_CPTicketHeader.HaulerSK |
| Last Updated | This column has not yet been added. Identifies the Last Updated Date & Time of the line item on the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_CPTicketItem.LastUpdated |
| Last Updated By | This column has not yet been added. Identifies the name of the user that last updated the line item on the transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_CPTicketItem.LastUser |
| Item | Identifies the Item, displayed as Item ID: Item Description. 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. Error rendering macro 'excerpt-include' : No link could be created for 'Item Type: Grower Accounting'. 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. 'Paid Weight' describes the weight that was included in the 'Net Weight' that is being paid for or deducted (items with a non-zero price). [Delivered Weight] - [Unpaid Weight] = [Paid Weight].
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 | Error rendering macro 'excerpt-include' : No link could be created for 'Site'. This comes from the 'Site' lookup on the Ticket Record View. It is not editable. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK |
| Status | Identifies the Status of the transaction. This comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable. Status is used to identify where a transaction, Purchase Order, Price List, BOM, or Master File record is in its life cycle. Records start in a Status of 'New' and progress sequentially through additional statuses until they are 'Posted' or 'Closed'. The list of potential Statuses changes depending on the transaction type. The Statuses that apply to transactions in this Inquiry include: New: This is the default Status for all new Transactions. While in the Status of 'New' transactions are considered open and all editable fields are open for edit, no posting or approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will be assigned and a Journal Entry will exist. Received: Graded: Reviewed: Approved: Performs all the data validations required to post the transaction and applies to all Transactions. While in the Status of 'Approved' transactions are considered open but have limited fields open for edit. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled except for the Status lookup (and any fields that are always editable), journal entries are created/updated, journal ID's are assigned to the journal entry, and blank 'GL Dates' are assigned. Ready to Post: Runs the Approval validations and applies to all transactions. While in the Status of 'Ready to Post' transactions are considered closed and all the fields are disabled with the exception of a few fields that are always editable. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled with the exception any fields that are always editable and updates the Transaction Status to "Posted". Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName |
| Ticket | Identifies the unique Transaction ID for each transaction. 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 | The unique identifier of the Transaction Class. This comes from the 'Transaction Class' value selected by the user when the transaction was created. It is not editable. Transaction Classes are used to categorize transactions within transaction types and assign specific default values and business rules for each. 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. By default, a new transaction is set to Version 1. If the transaction has been voided, corrected or repriced, the version number will be incremented. In order for a transaction to have a version greater than 1 all the previous versions must be voided (a transaction can only have one active version). 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. The 'Unpaid Weight' describes the weight that was included in the 'Delivered Weight' that is not being paid for (items with a price of 0.00). This most often represents dockage/waste material that is being sorted out. [Delivered Weight] - [Unpaid Weight] = [Paid Weight].
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. Error rendering macro 'excerpt-include' : No link could be created for 'Def - Net Weight'. Database Field: ERPx_CPTicketItem.TotalWeight |
| Weight UOM |