| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
| 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. [Ticket Net] = [Ticket Gross] - [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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 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 Weight |
Database Field: ERPx_CPTicketHeader.NetWeight | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 |
Database Field: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Status |
Database Fields: ERPx_CPTicketStatus.StatusName, ERPx_CPTicketHeader.TicketStatusSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Ticket Gross |
Database Field: ERPx_CPTicketHeader.GrossTicketAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Ticket Net |
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| UOM | Identifies the Weight UOM for the Ticket. This is required and defaults from the 'Scale Weight UOM' preference. This is not editable.
Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketHeader.SampleUOMSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 |
Note: Unpaid Weight is only calculated for line-items with a 0.00 Price. Items with a negative price are not considered 'Unpaid'....
| 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' 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 Ticket is Approved 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 is used with the 'Pallet Tare' to 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 0as [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 Amount |
Database Field: ERPx_CPTicketItem.AccrualAmount | |||||||||||||||||
| Charge Amount |
Database Field: ERPx_CPTicketItem.ChargeAmount | |||||||||||||||||
| Ext. Amount |
Database Field: ERPx_CPTicketItem.GrossAmount | |||||||||||||||||
| Item |
Database Fields: ERPx_CPItem.ItemID - ItemDescription, ERPx_CPTicketItem.ItemSK | |||||||||||||||||
| Net Amount |
Database Field: ERPx_CPTicketItem.NetAmount | |||||||||||||||||
| PercentPrice | Def - Percent (Sample Size) Def - Percent (Sample Size) |
Database Field: ERPx_CPTicketItem.SampleWeightPercentPrice | ||||||||||||||||
| Purchase Account | Price Price |
Database Field:Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.PriceAccountSK | ||||||||||||||||
| Sample Percent |
calculated field that can only be edited by changing either the Ticket Item's 'Sample Size' or one of the Ticket Header Properties that impact the Ticket's Net Weight or Ticket's Sample Size. Database Field: ERPx_CPTicketItem.SampleWeightPercent | |||||||||||||||||
| Sample Size |
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 |
Database Field: ERPx_CPTicketItem.TotalWeight | |||||||||||||||||
| 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 | |||||||||||||||||
| UOM | 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.
Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK |
...