| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
| 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 | excerpt-includeThis is 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 | 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 |
| . . This is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted. 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 |
...
| 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 |
...
| 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 |
...