...
- Ticket Status
...
- Reprice/Correct - This allows users to reprice or correct one or more posted tickets.
...
Columns
...
Column Headers
...
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
...
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
...
This column has not yet been added.
...
Database Field: ERPx_CPTicketHeader.CreatedDate
...
This column has not yet been added.
...
Insert excerpt
This list view 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.01.31 and newer
Table of Contents | ||||
---|---|---|---|---|
|
Page Header
...
Toolbar Icons
...
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
This list view 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 | ||||
---|---|---|---|---|
|
Page Header
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| ||||||||
Delete |
| ||||||||
Edit |
| ||||||||
Excel |
| ||||||||
Favorites |
| ||||||||
Group By Show/Hide |
| ||||||||
Help |
| ||||||||
Mass Update |
| ||||||||
More Actions |
| ||||||||
New |
| ||||||||
Notes |
| ||||||||
| |||||||||
Quick Column Filter |
| ||||||||
Refresh |
| ||||||||
Saved Layouts |
|
Columns
Column Headers | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Accruals |
Database Field: ERPx_CPTicketHeader.GrossAccrualsAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Charges |
Database Field: ERPx_CPTicketHeader.GrossChargesAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Created |
Database Field: ERPx_CPTicketHeader.CreatedDate | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Created By |
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.
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. |
Database Field: ERPx_CPTicketHeader.NetWeight | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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.
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. | CreatedByFarmerSK | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CropField | Identifies the Field the Crop that ticket was harvested from the Field assigned to the Ticket. This can only be edited when initially creating a ticket.
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 .FieldSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GL Date |
| yet been Approved or Posted | .Farmer | Identifies the Farmer that the ticket is assigned to. This can only be edited when initially creating a ticket.. Database Field: ERPx_CPTicketHeader.GLDate | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GL Period | Def - Farmer
| Def - Farmer |
| Farmer Class | Identifies the Class assigned to the Farmer on the ticket. This can only be edited from the Farmer Master File. 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 | Def - Farmer Class | Def - Farmer Class |
|
Linked Database Field: ERPx_APVendor.VendorClassSK
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.
Insert excerpt Def -
This is a calculated field that is only editable by changing the weights and/or prices of one or more ticket items.Ticket Gross (GA) Def - Ticket Gross (GA) nopanel true
Database Field: ERPx_CPTicketHeader.
GrossTicketAmount
Insert excerpt
Def - Gross Weight Def - Gross Weight nopanel true
This is a calculated field that cannot be edited unless either the 'Weight In' or 'Weight Out' amounts are edited.
Database Field: ERPx_CPTicketHeader.
GrossWeight
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
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 nopanel true
Database Field: ERPx_CPTicketHeader.HarvesterSK
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 nopanel true
Database Field: ERPx_CPTicketHeader.
HaulerSK
Identifies the
Hold Code that has been assigned to the ticket. 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 | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK
Insert excerpt
Last Updated Last Updated nopanel true
Database Field: ERPx_CPTicketHeader.
LastUpdated
Insert excerpt Last Updated By Last Updated By nopanel true
Database Field: ERPx_CPTicketHeader.
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 PostedLastUser
Insert excerpt
Def - Net Amount Ticket (GA) Def -
This is a calculated field and is not editable.Net Amount Ticket (GA) nopanel true
Database Field: ERPx_CPTicketHeader
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.NetTicketAmount
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 nopanel true
Database Field: ERPx_CPTicketHeader.HaulerSK
This column has not yet been added.
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
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.
Insert excerpt
Def - Price List Def - Price List nopanel true
Database Field: ERPx_CPTicketHeader.LastUser
Database Field: ERPx_CPTicketHeader.
PriceListSK
This is editable from the Home tab on the Ticket Record View for tickets that have not Insert excerpt Def - Sample Size (Ticket) Def - Sample Size (Ticket) nopanel true
been Approved or Posted
.
Database Field: ERPx_CPTicketHeader.SampleWeight
Def - Net Weight
Insert excerpt |
---|
|
Database Field: ERPx_CPTicketHeader.NetWeight
On HoldThis is not required and can be edited on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or PostedThis comes from the 'Site' lookup on the Ticket Record View. It is not editable.
Insert excerpt | ||
---|---|---|
|
|
|
Database
Field:Fields: ERPx_MFSite.SiteName, ERPx_
CPTicketHeaderHoldCPTicketHeader.
HoldCodeSKSiteSK
This comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable. Insert excerpt Status Status nopanel true
The Statuses that apply to transactions in this Inquiry include: Insert excerpt Def - Status Def - Status nopanel true
Insert excerpt Def - Status -
New Def - Status -
New nopanel true
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
This column has not yet been added.
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. Insert excerpt Def - Status - Received Def - Status - Received nopanel true
Insert excerpt Def - Status - Graded Def - Status - Graded nopanel true
Insert excerpt Def - Status -
Reviewed Def - Status -
Reviewed nopanel true
Database Field: ERPx_CPTicketHeader.PriceListSK
This column has not yet been added.
Identifies the weight of the delivery that was selected as a sample. This is required and can be edited from the 'Sample Size' field on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted. Insert excerpt Def - Status - Approved Def - Status - Approved nopanel true
Insert excerpt Def - Status - Ready to Post Def - Status - Ready to Post nopanel true
Database Field: ERPx_CPTicketHeader
.TicketStatusSK, ERPx_CPTicketStatus.StatusName
Insert excerpt
Transaction ID
This Transaction ID nopanel true
is a system assigned value and is not editable
. Clicking on this link opens the transaction record view.
Database Field: ERPx_CPTicketHeader.
TicketNumber
Insert excerpt |
---|
|
|
Transaction Class' value selected by the user when the transaction was created. It is not editable.
Insert excerpt | ||
---|---|---|
|
|
|
|
|
Received:
Graded:
Reviewed:
Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName
Database Field: ERPx_CPTicketHeader.TicketNumber
Insert excerpt
Database Field: ERPx_CPTicketHeader.TransactionClassSK
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 - Tare Weight Def - Tare Weight nopanel true
Database Field: ERPx_CPTicketHeader.ContainerTare
Identifies the # of containers the Ticket Item was delivered in. This is not required and is editable from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Posted.
Database Field: ERPx_CPTicketHeader.Units
Database Field: ERPx_CPTicketHeader.TicketVersion
Insert excerpt Def -
Unpaid Weight Def
Database Field: ERPx_CPTicketHeader.TransactionClassSK
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.
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.- Unpaid Weight nopanel true
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
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.
Insert excerpt | ||
---|---|---|
|
|
|
Database Field: ERPx_CPTicketHeader.
TicketVersion
Insert excerpt Def - Weight In
This can be edited from the 'Weight In' field on the Ticket Record View for tickets that have not yet been Approved or Posted.Def - Weight In nopanel true
Database Field: ERPx_CPTicketHeader.WeightIn
Insert excerpt Def - Weight
Out Def - Weight
Out nopanel true
This can be edited from the 'Weight Out' field on the Ticket Record View for tickets that have not yet been Approved or Posted.
Database Field: ERPx_CPTicketHeader.WeightOut
Related Topics
Expand | ||
---|---|---|
| ||
...