Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Software Version: 20222023.0403.2217 and newer
Table of Contents | ||
---|---|---|
|
...
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||||||||||
Help |
| ||||||||||||||||
More Actions |
| ||||||||||||||||
New |
| ||||||||||||||||
Notes |
| ||||||||||||||||
| |||||||||||||||||
Save |
| ||||||||||||||||
Save & Close |
|
Home Tab
Fields | Description | ||||
---|---|---|---|---|---|
Accruals | A calculated field that equals the sum of the 'Accruals' associated with all the Ticket Items.
|
|
Database Field: ERPx_CPTicketHeader.GrossAccrualsAmount | ||||
Charges | A calculated field that equals the sum of the 'Charges' associated with all the Ticket Items. [ |
Net Amount] = [ |
Gross Amount] - [Charges]
|
|
Database Field: ERPx_CPTicketHeader.GrossChargesAmount | |||||||||
Crop | A single select lookup to identify the 'Crop' on the Ticket. This is required and defaults from the Crop selected on the New Ticket Page. This is not editable after the initial save from the New Ticket page.
Database Fields: ERPx_CPCrop.Crop, ERPx_CPTicketHeader.CropSK | ||||||||
Delivered | A date picker to identify the date the Ticket was delivered to the 'Site'. This is required and defaults from the Delivered date entered on the New Ticket Page. This is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted. Database Field: ERPx_CPTicketHeader.DeliveryDate |
Delivered Weight |
Database Field: ERPx_CPTicketHeader.NetWeight | ||||||||
Field | A single select lookup to identify the 'Field' where the product came from. This is required and defaults from the Field selected on the New Ticket Page. This is not editable after the initial save from the New Ticket page.
Database Fields: ERPx_CPField.FieldName, ERPx_CPTicketHeader.FieldSK | ||||||||
Gross |
Amount |
|
|
|
is only editable by changing the weights and/or prices of one or more ticket items. Database Field: ERPx_CPTicketHeader. |
GrossTicketAmount | |||||||||
Gross Weight |
Database Field: ERPx_CPTicketHeader.GrossWeight | ||||||||
Harvested | A date picker to identify the date the contents of the Ticket were harvested. This is required and defaults from the Harvested date entered on the New Ticket Page. This is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted. Database Field: ERPx_CPTicketHeader.HarvestDate | ||||||||
Hold Code | A single select lookup to assign a 'Hold Code' to a Ticket. This defaults to blank and is not required. The lookup contains a list of all the Grower Accounting Hold Codes. This is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted.
Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK | ||||||||
Net |
Amount |
|
|
Database Field: ERPx_CPTicketHeader.NetWeight
|
Database Field: ERPx_CPTicketHeader.NetTicketAmount | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Paid Weight |
Database Field: ERPx_CPTicketHeader.PaidWeight | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Price List | A single select lookup to identify the 'Price List' on the Ticket. This is not required and defaults from the Price List assigned to the Farmer. This is not editable after the initial save from the New Ticket page.
Database Fields: ERPx_CPPriceListHeader.PriceListName, ERPx_CPTicketHeader.PriceListSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Size | A text box to record the Sample Size that was taken. This defaults from the 'Net Weight' but can be edited to any value <= the 'Net Weight' else the message "Sample Size cannot be greater than Net Weight" will be displayed on Save. Unless a user manually enters a 'Sample Size', it will always update from the 'Net Weight'. This is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted.
Database Field: ERPx_CPTicketHeader.SampleWeight | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Site Name |
Database Field: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Status |
Database Fields: ERPx_CPTicketStatus.StatusName, ERPx_CPTicketHeader.TicketStatusSK |
Database Field: ERPx_CPTicketHeader.GrossTicketAmount
Database Field: ERPx_CPTicketHeader.NetTicketAmount
Total Tare | An editable text box to record the 'Total Tare' weight of delivery. This defaults to 0.00 and is not required. This is editable from either the 'Total Tare' field on the Home tab or by editing the details on the Tare tab.
|
Database Field: ERPx_CPTicketHeader.ContainerTare | |||||||||
Unpaid Weight |
|
Database Field: ERPx_CPTicketHeader.UnpaidWeight
Identifies the Weight UOM for the Ticket. This is required and defaults from the 'Scale Weight UOM' preference. This is not editable.
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. 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 | An editable text box to record the inbound weight of the delivery. This defaults to 0.00 but must be >0 to approve or post a Ticket. This is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted.
Database Field: ERPx_CPTicketHeader.WeightIn | ||||||||
Weight Out | An editable text box to record the outbound weight of the delivery vehicle. This defaults to 0.00 and is not required. This is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted.
Database Field: ERPx_CPTicketHeader.WeightOut |
Properties Tab
Property Name | Description | ||||||||
Group: Ticket | |||||||||
GL Date |
Database Field: ERPx_CPTicketHeader.GLDate | ||||||||
Ticket Version | Identifies the Version # of the Ticket. This is system assigned and is not editable.
Database Field: ERPx_CPTicketHeader.TicketVersion | ||||||||
Harvester | Identifies the 'Harvester' of the Ticket. This is not required and defaults from the New Ticket page. The lookup contains a list of all 'blank value, the current assigned value, and a list of all 'Active' Harvesters. This can be edited until the Ticket is in a Status of either Approved or Posted.
Database Fields: ERPx_CPHarvester.HarvesterName, ERPx_CPTicketHeader.HarvesterSK | ||||||||
Hauler | Identifies the 'Hauler' of the Ticket. This is not required and defaults from the New Ticket page. The lookup contains a blank value, the current assigned value, and a list of all 'Active' HaulerHaulers. This can be edited until the Ticket is in a Status of either Approved or Posted.
Database Fields: ERPx_CPHauler.HaulerName, ERPx_CPTicketHeader.HaulerSK | ||||||||
Created Date |
Database Field: ERPx_CPTicketHeader.CreatedDate | ||||||||
Created By |
Database Field: ERPx_CPTicketHeader.CreatedBy | ||||||||
Last Updated By |
Database Field: ERPx_CPTicketHeader.LastUser | ||||||||
Last Updated |
Database Field: ERPx_CPTicketHeader.LastUpdated |
...
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||||||||||
Excel |
| ||||||||||||||||
New |
| Quick Column Filter |
| ||||||||||||||
Fields | Description | ||||||||||||||||
Checkbox |
| ||||||||||||||||
Container Tare | Identifies the empty container weight for containers that are of the same Container Type / Weight. If entered, this This is not required and defaults to 0.00. This is used with the 'Number of Containers' to calculate the 'Total Container Tare' for each Container Type . This is not required but if entered must be >=0. If this is entered, either the 'Containers Per Pallet' or the 'Number of Containers' must also be entered otherwise on Save they will both be set to 0. This is editable until the as [Number of Containers] * [Container Tare] = [Total Container Tare]. This is editable until the Ticket is Approved or Posted. Database Field: ERPx_CPTicketContainer.ContainerTare | ||||||||||||||||
Containers Per Pallet | An optional field that is editable text box that can be optionally used to compute the 'Number of Containers' for each Pallet Type. For example, if each pallet contains 48 containers and there are 15 pallets, a user could enter '48' in the 'Containers Per Pallet' field and the system would compute '720' and put that value in the 'Number of Containers' field. If This defaults to 0 and can be edited to any whole number that is >=0. If the user already knows the number of containers, they could leave this blank and enter the total in the 'Number of Containers' field. This is editable until the Ticket is Approved or Posted. Database Field: ERPx_CPTicketContainer.ContainersPerPallet | ||||||||||||||||
Number of Containers | INSERT EXCERPT HERE. This is an editable textbox that is required to calculate the Total Container Tare. An optional field used to compute the 'An editable text box to identify the quantity of Containers that are of the same Container Type / Weight. This defaults to 0 and can be edited to any whole number that is >=0. This is used with the 'Container Tare' to calculate the 'Total Container Tare' for each Pallet Type. This can be auto populated by entering a value in both the 'Number of Pallets' and 'Containers per Pallet' fields or can be manually enteredContainer Type as [Number of Containers] * [Container Tare] = [Total Container Tare]. This is editable until the Ticket is Approved or Posted. Database Field: ERPx_CPTicketContainer.NumberofContainers | ||||||||||||||||
Number of Pallets | Identifies An editable text box to identify the quantity of Pallets that are of the same Pallet Type / Weight. If entered, this . This defaults to 0 and can be edited to any whole number that is >=0. This is used with the 'Pallet Tare' to calculate the 'Total Pallet Tare' for each Pallet Type . This is not required but if entered must be >=0. If this is entered, a 'Pallet Tare' must also be entered otherwise on Save they will both be set to 0as [Number of Pallets] * [Pallets Tare] = [Total Pallets Tare]. This is editable until the Ticket is Approved or Posted. Database Field: ERPx_CPTicketContainer.NumberofPallets | ||||||||||||||||
Pallet Tare | Identifies the empty pallet weight for Pallets that are of the same Pallet Type / Weight. If entered, this . This is not required and defaults to 0.00. This is used with the 'Number of Pallets' to calculate the 'Total Pallet Tare' for each Pallet Type. This is not required but if entered must be >=0. If this is entered, a 'Number of Pallets' must also be entered otherwise on Save they will both be set to 0Tare' for each Pallet Type as [Number of Pallets] * [Pallets Tare] = [Total Pallets Tare]. This is editable until the Ticket is Approved or Posted. Database Field: ERPx_CPTicketContainer.PalletTare | ||||||||||||||||
Total Container Tare | A calculated field that identifies the total tare weight from the containers. This is calculated as ([Number of Containers] * [Container Tare]). To be calculated, both the 'Number of Containers' and 'Container Tare' fields are required to have values >0. | ||||||||||||||||
Total Pallet Tare | A calculated field that identifies the total tare weight from the pallets. This is calculated as ([Number of Pallets] * [Pallet Tare]). To be calculated, both the 'Number of Pallets' and 'Pallet Tare' fields are required to have values >0. | ||||||||||||||||
Total Tare | A calculated field that identifies the total tare weight from the Pallets and Containers. If one or more rows in the Tare gid has a 'Total Tare' value >0, then the 'Total Tare' for all the rows will be used as the Ticket Header's 'Total Tare'. Database Field: ERPx_CPTicketContainer.TotalTare |
...
Fields | Description | ||||||||
Attributes |
| ||||||||
Required | A non-editable text box that shows whether the Attribute Value is required or not. If the Attribute Value is required, it will display "Yes". If it is optional, it will display as blank. This value is only editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → Grower Accounting → Transactions hyperlink). | ||||||||
Value |
|
Page Details
This grid shows each Ticket Item that is included on the Ticket. From Here, users can add, edit, or remove items.
Toolbar Icons | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Add Item |
| ||||||||||||
Column Filter Show / Hide |
| ||||||||||||
Group By Show / Hide |
| ||||||||||||
Excel |
| ||||||||||||
Notes |
| ||||||||||||
Quick Column Filter |
| ||||||||||||
Remove Items |
| ||||||||||||
Saved Layouts |
| ||||||||||||
Fields | Description | ||||||||||||
Checkbox |
| ||||||||||||
Accrual AmountAmt. |
Database Field: ERPx_CPTicketItem.AccrualAmount | ||||||||||||
Charge AmountAmt. |
Database Field: ERPx_CPTicketItem.ChargeAmount Ext. Amount | ||||||||||||
Delivered Wt. |
Database Field: ERPx_CPTicketItem.TotalWeight | ||||||||||||
Gross Amt. |
Database Field: ERPx_CPTicketItem.GrossAmount | ||||||||||||
Item |
Database Fields: ERPx_CPItem.ItemID - ItemDescription, ERPx_CPTicketItem.ItemSK | ||||||||||||
Net AmountAmt. |
| Def - Net Amount (GA) | |||||||||||
nopanel | true | Percent | Insert excerpt | | Def - Percent (Sample Size) | Def - Percent (Sample Size) | |||||||
nopanel | true |
|
Database Field: ERPx_CPTicketItem.
SampleWeightPercentNetAmount
This is a numeric text box that is required. It defaults from the Price List assigned to the Ticket but can be edited until the Ticket is Approved or Posted. Insert excerpt Price Price nopanel true
Database Field: ERPx ERPx_CPTicketItem.Price
Identifies the Price UOM for the Ticket Item. This is required and defaults from the 'Scale Weight UOM' preference. This cannot be edited from here.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.PriceUOMSK
This is a single-select lookup that defaults from the 'Purchase GL Account' assigned to the Ticket Item. This is required for any Ticket Item that has a Net Amount <> 0.00. This is editable until the Ticket is Approved or Posted. Insert excerpt GL Account - Purchases (GA) GL Account - Purchases (GA) nopanel true
Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.AccountSK
Insert excerpt | ||
---|---|---|
|
|
|
The Ticket Items Sample Size is used to calculate the Ticket Items Net Weight. This is editable until the Ticket is Approved or Posted.
Database Field: ERPx_CPTicketItem.SampleWeight
Total Weight
Total Weight (GA) Insert excerpt Def - Sample Pct Def -
|
Database Field: ERPx_CPTicketItem.TotalWeightSampleWeightPercent
Identifies the # of containers the Ticket Item was delivered in. This defaults as blank and is not required. If entered, it must be >=0. Units are saved to two decimal places. For example, if Strawberries were delivered in Freezer Trays this is where you would enter the count of Freezer Trays if it was important to retain. This is editable until the Ticket is Approved or Posted.
Database Field: ERPx_CPTicketItem.Units
Identifies the Weight UOM for the Ticket Item. This is required and defaults from the 'Scale Weight UOM' preference. This cannot be edited from here.
Related Topics
Expand | ||
---|---|---|
| ||
Page Definitions |
...