Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 excerptDef - Grower TicketDef - Grower Ticketnopaneltrue The purpose of this page is to 

Software Version: 2022.04.22 and newer

Table of Contents
typeflat

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
Def - Grower Ticket
Def - Grower Ticket
nopaneltrue
 The purpose of this page is to 

Software Version: 2022.04.22 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Delete
Insert excerpt
Delete - RV Header 3.0
Delete - RV Header 3.0
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue

More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • RV: Charges & Accruals - Opens the Charges & Accruals record view. 
  • RV: Journal Details - 
    Insert excerpt
    Journal Details - RV Header
    Journal Details - RV Header
    nopaneltrue
New
Insert excerpt
New - Multi-Select Trans Type - Global 3.0
New - Multi-Select Trans Type - Global 3.0
nopaneltrue
Notes
Insert excerpt
Notes - RV Grid 3.0
Notes - RV Grid 3.0
nopaneltrue
Insert excerpt
Def - Notes
Def - Notes
nopaneltrue
Print
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Save
Insert excerpt
Save - RV Header 3.0
Save - RV Header 3.0
nopaneltrue
Save & Close
Insert excerpt
Save & Close - RV Header 3.0
Save & Close - RV Header 3.0
nopaneltrue

Home Tab

FieldsDescription
Accruals

Insert excerpt
Def - Accrual - GA
Def - Accrual - GA
nopaneltrue

Database Field: ERPx_CPTicketHeader.GrossAccrualsAmount

Charges

Insert excerpt
Def - Charges (GA)
Def - Charges (GA)
nopaneltrue

Database Field: ERPx_CPTicketHeader.GrossChargesAmount

Crop

Insert excerpt
Def - Crop
Def - Crop
nopaneltrue

Database Fields: ERPx_CPCrop.Crop, ERPx_CPTicketHeader.CropSK

DeliveredDatabase Field: ERPx_CPTicketHeader.DeliveryDate
Field

Insert excerpt
Def - Field
Def - Field
nopaneltrue

Database Fields: ERPx_CPField.FieldName, ERPx_CPTicketHeader.FieldSK

Gross Weight

Insert excerpt
Def - Gross Weight
Def - Gross Weight
nopaneltrue

Database Field: ERPx_CPTicketHeader.GrossWeight

HarvestedDatabase Field: ERPx_CPTicketHeader.HarvestDate
Hold Code

Insert excerpt
Def - Hold Code
Def - Hold Code
nopaneltrue

Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK

Net Weight


Insert excerpt
Def - Net Weight
Def - Net Weight
nopaneltrue

Database Field: ERPx_CPTicketHeader.NetWeight

Paid Weight

Insert excerpt
Def - Paid Weight
Def - Paid Weight
nopaneltrue

Database Field: ERPx_CPTicketHeader.PaidWeight

Price List

Insert excerpt
Def - Price List
Def - Price List
nopaneltrue

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

Insert excerpt
Site Name - LV
Site Name - LV
nopaneltrue
 This is a single select lookup that is required. The lookup contains the list of all active sites. 

Database Field: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

Status

Insert excerpt
Status
Status
nopaneltrue
 This is a single-select standard lookup that is required. It defaults as "New" and is always editable until the transaction is posted.

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 The Statuses that apply to transactions in this Record View include:

  • Insert excerpt
    Def - Status - New
    Def - Status - New
    nopaneltrue
  • Received
  • Graded
  • Reviewed
  • Approved
  • Ready To Post


Database Fields: ERPx_CPTicketStatus.StatusName, ERPx_CPTicketHeader.TicketStatusSK

Ticket GrossDatabase Field: ERPx_CPTicketHeader.GrossTicketAmount
Ticket NetDatabase Field: ERPx_CPTicketHeader.NetTicketAmount
Total TareDatabase Field: ERPx_CPTicketHeader.ContainerTare
Unpaid WeightDatabase Field: ERPx_CPTicketHeader.UnpaidWeight
UOM

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketHeader.SampleUOMSK

Weight InDatabase Field: ERPx_CPTicketHeader.WeightIn
Weight OutDatabase Field: ERPx_CPTicketHeader.WeightOut

Properties Tab

Property NameDescription
Group: Ticket
GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
 This is a date picker that is required, defaults to blank and can be manually edited until the Ticket is in a Status of either Approved or Posted. If blank, when the Ticket is set to a Status of either 'Approved' or 'Ready to Post' it will be auto updated to match the Delivered date on the Home tab. In order to Approve or Post a ticket, the GL Date must fall within a Fiscal Period that open for Purchasing else the message "The Fiscal Period is not open." will be displayed. 

Database Field: ERPx_CPTicketHeader.GLDate

Ticket Version

Identifies the Version # of the Ticket. This is system assigned and is not editable.

Insert excerpt
Def - Version
Def - Version
nopaneltrue

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.

Insert excerpt
Def - Harvester
Def - Harvester
nopaneltrue

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.

Insert excerpt
Def - Hauler
Def - Hauler
nopaneltrue

Database Fields: ERPx_CPHauler.HaulerName, ERPx_CPTicketHeader.HaulerSK

Created Date

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_CPTicketHeader.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue

Database Field: ERPx_CPTicketHeader.CreatedBy

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue

Database Field: ERPx_CPTicketHeader.LastUser

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_CPTicketHeader.LastUpdated

Tare Tab

The Tare tab is used to store and calculate the 'Total Tare' for a Ticket. 

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Excel

Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue

New
Insert excerpt
New - Global 3.0
New - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox (Tag)- RV
Checkbox (Tag)- RV
nopaneltrue
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.

FieldsDescription
Attributes

Insert excerpt
Attribute - Attribute
Attribute - Attribute
nopaneltrue
 The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes →Grower Accounting).

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

Insert excerpt
Attribute - Value
Attribute - Value
nopaneltrue
 This is editable if the Transaction Class property 'Allow Attribute Edit After Approval' is set to "Yes".  

Page Details 

This grid shows each Ticket Item that is included on the Ticket. From Here, users can add, edit, or remove items.

Toolbar IconsDescription
Add Item
Insert excerpt
Add Item - RV Grid 3.0
Add Item - RV Grid 3.0
nopaneltrue
Column Filter Show / Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Group By Show / Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Excel

Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue

Notes
Insert excerpt
Notes - RV Grid 3.0
Notes - RV Grid 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Remove Items
Insert excerpt
Remove Items - RV Grid 3.0
Remove Items - RV Grid 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox

Insert excerpt
Checkbox (Tag)- RV
Checkbox (Tag)- RV
nopaneltrue

Accrual Amount

Insert excerpt
Def - Accrual Amount (GA)
Def - Accrual Amount (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.AccrualAmount

Charge Amount

Insert excerpt
Def - Charge Amount (GA)
Def - Charge Amount (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.ChargeAmount

Ext. Amount

Insert excerpt
Def - Ext Amount (GA)
Def - Ext Amount (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.GrossAmount

Item

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
 This is required and cannot be edited (it can only be removed). Items can default on new Tickets or can be added by clicking the 'Add Item' button on the Grid Toolbar. 

Database Fields: ERPx_CPItem.ItemID - ItemDescription, ERPx_CPTicketItem.ItemSK

Net Amount

Insert excerpt
Def - Net Amount (GA)
Def - Net Amount (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.NetAmount

Percent

Insert excerpt
Def - Percent (Sample Size)
Def - Percent (Sample Size)
nopaneltrue
 This is a 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

Price

Insert excerpt
Price
Price
nopaneltrue
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.

Database Field: ERPx_CPTicketItem.Price

Purchase Account

Insert excerpt
GL Account - Purchases (GA)
GL Account - Purchases (GA)
nopaneltrue
 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.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.AccountSK

Sample Size

Insert excerpt
Def - Sample Size (Ticket Item)
Def - Sample Size (Ticket Item)
nopaneltrue
 This defaults as 0.00 and can be edited to any numeric value. 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

Insert excerpt
Def - Total Weight (GA)
Def - Total Weight (GA)
nopaneltrue

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. 

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK



Related Topics



Expand
titlePage Definitions

Page Definitions


...