...
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).
...
Page Details
...
Database Field: ERPx_CPTicketItem.AccrualAmount
...
Database Field: ERPx_CPTicketItem.ChargeAmount
...
Database Field: ERPx_CPTicketItem.GrossAmount
...
Database Fields: ERPx_CPItem.ItemID - ItemDescription, ERPx_CPTicketItem.ItemSK
...
Database Field: ERPx_CPTicketItem.NetAmount
...
Database Field: ERPx_CPTicketItem.SampleWeightPercent
...
Database Field: ERPx_CPTicketItem.Price
...
Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.AccountSK
...
Database Field: ERPx_CPTicketItem.SampleWeight
...
Database Field: ERPx_CPTicketItem.TotalWeight
...
Insert excerpt
Software Version: 2022.04.22 and newer
Table of Contents | ||
---|---|---|
|
Page Header
...
More Actions
...
Database Field: ERPx_CPTicketHeader.GrossAccrualsAmount
...
Database Field: ERPx_CPTicketHeader.GrossChargesAmount
...
Database Fields: ERPx_CPCrop.Crop, ERPx_CPTicketHeader.CropSK
...
Database Field: ERPx_CPTicketHeader.DeliveryDate
...
Database Fields: ERPx_CPField.FieldName, ERPx_CPTicketHeader.FieldSK
...
Database Field: ERPx_CPTicketHeader.GrossWeight
...
Database Field: ERPx_CPTicketHeader.HarvestDate
...
Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK
...
Database Field: ERPx_CPTicketHeader.NetWeight
...
Database Field: ERPx_CPTicketHeader.PaidWeight
...
Database Fields: ERPx_CPPriceListHeader.PriceListName, ERPx_CPTicketHeader.PriceListSK
...
Need to add this info: Sample Size will follow the Net Weight value if one isn't specified. For example, if Net Weight = 400 lbs, Sample Size will populate with 400lbs. If Net Weight is then updated to 500lbs and the user hasn't manually updated Sample Size, then Sample Size value will be updated to 500lbs. However, if the user has specified a Sample Size it will not be updated even when Net Weight is changed.
Database Field: ERPx_CPTicketHeader.SampleWeight
...
Database Field: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK
...
Database Fields: ERPx_CPTicketStatus.StatusName, ERPx_CPTicketHeader.TicketStatusSK
...
Database Field: ERPx_CPTicketHeader.GrossTicketAmount
...
Database Field: ERPx_CPTicketHeader.NetTicketAmount
...
Database Field: ERPx_CPTicketHeader.ContainerTare
...
Database Field: ERPx_CPTicketHeader.UnpaidWeight
...
Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketHeader.SampleUOMSK
...
Database Field: ERPx_CPTicketHeader.WeightIn
...
Database Field: ERPx_CPTicketHeader.WeightOut
Properties Tab
...
Database Field: ERPx_CPTicketHeader.GLDate
...
Database Fields: ERPx_CPHauler.HaulerName, ERPx_CPTicketHeader.HaulerSK
...
Database Fields: ERPx_CPHarvester.HarvesterName, ERPx_CPTicketHeader.HarvesterSK
...
Database Field: ERPx_CPTicketHeader.TicketVersion
...
Database Field: ERPx_CPTicketHeader.CreatedDate
...
Database Field: ERPx_CPTicketHeader.CreatedBy
...
Database Field: ERPx_CPTicketHeader.LastUpdated
...
Database Field: ERPx_CPTicketHeader.LastUser
Tare Tab
...
INSERT EXCERPT HERE. This is an editable numeric textbox that is required to calculate Total Container Tare. This value is used to multiply by the Number of Containers to get the Total Container Tare value.
Database Field: ERPx_CPTicketContainer.ContainerTare
...
INSERT EXCERPT HERE. This is an editable numeric textbox that is required to calculate the Number of Containers. This value is used to multiply by the Number of Pallets to get the Number of Containers.
Database Field: ERPx_CPTicketContainer.ContainersPerPallet
...
INSERT EXCERPT HERE. This is an editable textbox that is required to calculate the Total Container Tare.
Database Field: ERPx_CPTicketContainer.NumberofContainers
...
INSERT EXCERPT HERE. This is
Database Field: ERPx_CPTicketContainer.NumberofPallets
...
Database Field: ERPx_CPTicketContainer.PalletTare
...
Database Field: ERPx_CPTicketContainer.TotalTare
Attributes Tab
...
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Software Version: 2022.04.22 and newer
Table of Contents | ||
---|---|---|
|
Page Header
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||||||||||
Help |
| ||||||||||||||||
More Actions |
| ||||||||||||||||
New |
| ||||||||||||||||
Notes |
| ||||||||||||||||
| |||||||||||||||||
Save |
| ||||||||||||||||
Save & Close |
|
Home Tab
Fields | Description | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accruals |
Database Field: ERPx_CPTicketHeader.GrossAccrualsAmount | ||||||||||||||||||||||||
Charges |
Database Field: ERPx_CPTicketHeader.GrossChargesAmount | ||||||||||||||||||||||||
Crop |
Database Fields: ERPx_CPCrop.Crop, ERPx_CPTicketHeader.CropSK | ||||||||||||||||||||||||
Delivered | Database Field: ERPx_CPTicketHeader.DeliveryDate | ||||||||||||||||||||||||
Field |
Database Fields: ERPx_CPField.FieldName, ERPx_CPTicketHeader.FieldSK | ||||||||||||||||||||||||
Gross Weight |
Database Field: ERPx_CPTicketHeader.GrossWeight | ||||||||||||||||||||||||
Harvested | Database Field: ERPx_CPTicketHeader.HarvestDate | ||||||||||||||||||||||||
Hold Code |
Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK | ||||||||||||||||||||||||
Net Weight |
Database Field: ERPx_CPTicketHeader.NetWeight | ||||||||||||||||||||||||
Paid Weight |
Database Field: ERPx_CPTicketHeader.PaidWeight | ||||||||||||||||||||||||
Price List |
Database Fields: ERPx_CPPriceListHeader.PriceListName, ERPx_CPTicketHeader.PriceListSK | ||||||||||||||||||||||||
Sample Size | Need to add this info: Sample Size will follow the Net Weight value if one isn't specified. For example, if Net Weight = 400 lbs, Sample Size will populate with 400lbs. If Net Weight is then updated to 500lbs and the user hasn't manually updated Sample Size, then Sample Size value will be updated to 500lbs. However, if the user has specified a Sample Size it will not be updated even when Net Weight is changed. 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 | Database Field: ERPx_CPTicketHeader.ContainerTare | ||||||||||||||||||||||||
Unpaid Weight | Database Field: ERPx_CPTicketHeader.UnpaidWeight | ||||||||||||||||||||||||
UOM |
Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketHeader.SampleUOMSK | ||||||||||||||||||||||||
Weight In | Database Field: ERPx_CPTicketHeader.WeightIn | ||||||||||||||||||||||||
Weight Out | 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 '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 list of all 'Active' Hauler. 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 |
Tare Tab
The Tare tab is used to store and calculate the 'Total Tare' for a Ticket.
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 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 or Posted. Database Field: ERPx_CPTicketContainer.ContainerTare | ||||||||
Containers Per Pallet | An optional field that is 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 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 '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 entered. This is editable until the Ticket is Approved or Posted. Database Field: ERPx_CPTicketContainer.NumberofContainers | ||||||||
Number of Pallets | Identifies the quantity of Pallets that are of the same Pallet Type / Weight. If entered, 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 0. 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 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 0. 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 |
Attributes Tab
The Attributes tab is where Ticket Attributes are assigned to specific Ticket. If any required attributes are missing the Ticket cannot be Approved or Posted.
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 | ||||||||
Percent |
Database Field: ERPx_CPTicketItem.SampleWeightPercent | ||||||||
Price |
Database Field: ERPx_CPTicketItem.Price | ||||||||
Purchase Account |
Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.AccountSK | ||||||||
Sample Size |
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 |
Related Topics
Expand | ||
---|---|---|
| ||
Page Definitions |
...