Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Software Version: 2022.0607.3001 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 |
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.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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
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 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' Haulers. 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. 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 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 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. 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 | 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 Container 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 | An editable text box to identify the quantity of Pallets that are of the same Pallet Type / Weight. 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 as [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. 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 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 Amt. |
Database Field: ERPx_CPTicketItem.AccrualAmount | ||||||||
Charge Amt. |
Database Field: ERPx_CPTicketItem.ChargeAmount | ||||||||
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 Amt. |
Database Field: ERPx_CPTicketItem.NetAmount | ||||||||
Price |
Database Field: ERPx_CPTicketItem.Price | ||||||||
Price UOM | 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.
Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK | ||||||||
Purchase GL Account |
Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.AccountSK | ||||||||
Sample |
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 | ||||||||
Sample Pct. |
Database Field: ERPx_CPTicketItem.SampleWeightPercent | ||||||||
Units | 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 |
...