Versions Compared

Key

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

Insert excerpt
Def - Grower Ticket
Def - Grower Ticket
nopaneltrue
 The purpose of this page is to add, edit, remove, and post Grower Accounting Tickets. 

Software Version: 2022.0607.3001 and newer

Table of Contents
typeflat

...

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

A calculated field that equals the sum of the 'Accruals' associated with all the Ticket Items. 

Insert excerpt
Def - Program Type - GA Accrual
Def - Program Type - GA Accrual
nopaneltrue

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]

Insert excerpt
Def - Program Type - GA Charges
Def - Program Type - GA Charges
nopaneltrue

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. 

Insert excerpt
Def - Crop
Def - Crop
nopaneltrue

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

Insert excerpt
Def - Net Weight
Def - Net Weight
nopaneltrue
 This is a calculated field that cannot be edited unless either the 'Weight In', 'Weight Out', or 'Total Tare' amounts are edited.

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. 

Insert excerpt
Def - Field
Def - Field
nopaneltrue

Database Fields: ERPx_CPField.FieldName, ERPx_CPTicketHeader.FieldSK

Gross Amount

Insert excerpt
Def - Ticket Gross (GA)
Def - Ticket Gross (GA)
nopaneltrue
 This is a calculated field that is only editable by changing the weights and/or prices of one or more ticket items.

Database Field: ERPx_CPTicketHeader.GrossTicketAmount

Gross Weight

Insert excerpt
Def - Gross Weight
Def - Gross Weight
nopaneltrue
 This is a calculated field that cannot be edited unless either the 'Weight In' or 'Weight Out' amounts are edited.

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.

Insert excerpt
Def - Hold Code
Def - Hold Code
nopaneltrue

Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK

Net Amount

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

Database Field: ERPx_CPTicketHeader.NetTicketAmount

Paid Weight

Insert excerpt
Def - Paid Weight
Def - Paid Weight
nopaneltrue

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. 

Insert excerpt
Def - Price List
Def - Price List
nopaneltrue

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.

Insert excerpt
Def - Sample Size (Ticket)
Def - Sample Size (Ticket)
nopaneltrue

Database Field: ERPx_CPTicketHeader.SampleWeight

Site Name

Insert excerpt
Site Name - LV
Site Name - LV
nopaneltrue
 This is a single select lookup that is required. This defaults from the sequence of 1) the Site selected on the New Ticket Page, 2) the Site setup as the 'Site Name' on the Field master file, or 3) the Site setup as the 'Default Site' on the Preferences page. The lookup contains the list of all active sites. 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

Insert excerpt
Status
Status
nopaneltrue
 This is a single-select 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
  • Insert excerpt
    Def - Status - Received
    Def - Status - Received
    nopaneltrue
  • Insert excerpt
    Def - Status - Graded
    Def - Status - Graded
    nopaneltrue
  • Insert excerpt
    Def - Status - Reviewed
    Def - Status - Reviewed
    nopaneltrue
  • Insert excerpt
    Def - Status - Approved
    Def - Status - Approved
    nopaneltrue
  • Insert excerpt
    Def - Status - Ready to Post
    Def - Status - Ready to Post
    nopaneltrue

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.

  • If the Tare is entered on the Tare tab, this field will populate from the detail totals and be disabled.
  • If the Tare is being managed from the Home tab, it is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted.

Insert excerpt
Def - Tare Weight
Def - Tare Weight
nopaneltrue

Database Field: ERPx_CPTicketHeader.ContainerTare

Unpaid Weight

Insert excerpt
Def - Unpaid Weight
Def - Unpaid Weight
nopaneltrue
 This can only be edited by editing the 'Price' of a ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted.

(lightbulb) 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.

Insert excerpt
Def - Weight In
Def - Weight In
nopaneltrue

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.

Insert excerpt
Def - Weight Out
Def - Weight Out
nopaneltrue

Database 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 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.

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 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.

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

...

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. 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

...

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 Amt.

Insert excerpt
Def - Accrual Amt. (GA)
Def - Accrual Amt. (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.AccrualAmount

Charge Amt.

Insert excerpt
Def - Charge Amt. (GA)
Def - Charge Amt. (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.ChargeAmount

Delivered Wt.

Insert excerpt
Def - Delivered Wt. (GA)
Def - Delivered Wt. (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.TotalWeight

Gross Amt.

Insert excerpt
Def - Gross Amt. (GA)
Def - Gross Amt. (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 Amt.

Insert excerpt
Def - Net Amt. (GA)
Def - Net Amt. (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.NetAmount

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

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. 

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK

Purchase GL 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

Insert excerpt
Def - Sample (Ticket Item)
Def - Sample (Ticket Item)
nopaneltrue
 This defaults as 0.00 and can be edited to any numeric value. If entered as a positive value, the value for 'Units' must be >=0. If entered as a negative value, the value for 'Units' must be <=0.

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.

Insert excerpt
Def - Sample Pct
Def - Sample Pct
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

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

...