Versions Compared

Key

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

Insert excerpt
Def - SiteGrower Ticket
Def - SiteGrower Ticket
nopaneltrue
 The purpose of this page is to add new Sites and/or update properties on existing Sites.to add, edit, remove, and post Grower Accounting Tickets. 

Software Version: 2023.03.17 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescriptionExcel
Toolbar IconsDescription
Delete
Insert excerpt
Delete - RV Header 3.0
Delete - RV Header 3.0
nopaneltrue
Grid LayoutHelpToolbar Icon - Grid
Insert excerpt
Toolbar Icon - Grid
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New

More Actions

Insert excerpt

New - RV HeaderNew - RV Headernopaneltrue
Notes
Insert excerptNotes - RV Grid

More Actions - Global 3.0

Notes

More Actions -

RV Grid

Global 3.0
nopaneltrue

Save

  • RV: Charges & Accruals - Opens the Charges & Accruals record view. 
  • RV: Journal Details - 
    Insert excerpt
Save
  • Journal Details - RV Header
Save
  • Journal Details - RV Header
    nopaneltrue
FieldsDescriptionSiteNew
Insert excerpt
Site Name - LVSite Name - LVnopaneltrue This is a single select lookup that is required. The lookup contains the list of all sites. Selecting a different Site, reloads the page with data for the selected Site.

Properties Tab

Excel - Global (old)
New - Multi-Select Trans Type - Global 3.0
New - Multi-Select Trans Type - Global 3.0
nopaneltrue
Notes
Insert excerpt
Excel - Global (old)
Notes - RV Grid 3.0
Notes - RV Grid 3.0
nopaneltrue
Property NameDescriptionAuto Generate Warehouse Lots ByAuto Generate Warehouse Lots on Transfer Receipts

Identifies whether or not the Warehouse Lot Numbers are auto-generated for applicable transfer line items. This is only visible for Sites where the 'Warehouse Lot Tracked' property is set to either: "Yes - Allow multiple items in single lots" or "Yes - Limit Warehouse Lots to single items". This value is required if the Site is warehouse lot tracked and there is a value in the "Auto Generate Warehouse Lots By" property. 

If these conditions are true and the value is missing, the message "Unable to set "Auto Generate Warehouse Lots By" if "Auto Generate Warehouse Lots on Transfer Receipts" is not enabled on Save.

When this feature is enabled for the 'To Site' (the receiving Site) on an inventory Transfer transaction, the system will automatically populate the warehouse lot values in the 'To Warehouse Lot' , on Save. The values will be populated as either:

  • INTR:[SiteID]:[Reference Number] - for example INTR:BCS:12345
  • [Item ID]-[Production Batch Date MM][Production Batch Date YY] - for example 10015-0519
  • [Production Batch Date MM][Production Batch Date YY]-[Item ID] - for example 0519-10015

Linked Database Field: ERPx_MFSite.AssignWarehouseLotsOnTransferReceipts

This lookup contains options for either "Yes" or "No". 

Default Via Site for Integrated TransfersInactiveIn Transit

A Yes/No lookup to identify whether or not the site is an "in transit" site. This defaults to "No", is required, and is always editable.

  • If "Yes', the site can be added as the "Ship Via" site on a two-part transfer and on other transactions.
  • If "No", the site will not be included in the "Ship Via" lookup on Transfer Transactions but can be assigned on other transactions.
Insert excerptDef - In Transit SiteDef - In Transit Sitenopaneltrue

Database Field: ERPx_MFSite.IsInTransit

Next Production Batch #Production Batch PrefixRegistrationSite ID Insert excerptSite IDSite IDnopaneltrue This is a text box that defaults as blank, is required, must be unique, and must be <= 25 characters. If missing, the message "Site ID is required." will be displayed on Save. If not unique the message "Duplicate Site ID's are not allowed." will be displayed on Save. This field is always editable. Insert excerptDef - SiteDef - Sitenopaneltrue

Database Field: ERPx_MFSite.SiteID

Site Name Insert excerptSite Name - LVSite Name - LVnopaneltrue This is a text box that defaults as blank, is required, and must be <= 35 characters. If missing, the message "Site Name is required." will be displayed on Save. This field is always editable.

Database Field: ERPx_MFSite.SiteName

VendorVisible to Logistics

A Yes/No lookup to identify whether or not the site is visible in the "Load Management" functional Area. This defaults to "No", is required, and is always editable.

  • If "Yes', transactions shipping from the Site (that are also being shipped by a Carrier that is Visible to Logistics) will be visible to the "Build Loads" process in Load Management.
  • If "No', transactions shipping from the Site the Site will be visible/accessible in Load Management

(lightbulb) The list of Sites also exists in the Load Management functional area, allowing users to determine whether or not a Site is available to them for placement on Loads. Because of this, the Site record view Visible to Logistics field corresponds with the Logistics Sites list view Visible to Logistics checkbox. Therefore, if the Site's visibility to logistics is edited from either location, the site will be updated in both locations.

Database Field: ERPx_MFSite.IsVisibleToLogistics

Visible to Sales

A Yes/No lookup to identify whether or not the site is visible for use on Sales Orders, Price Adjustment, and Return transactions. This defaults to "No", is required, and is always editable.

  • If "Yes', the Site will be included in the Site lookups on Sales Orders, Price Adjustment, and Return transactions.
  • If "No', the Site will not be included in the Site lookups on Sales Orders, Price Adjustment, and Return transactions.

Database Field: ERPx_MFSite.IsVisibleToSales

Visible to WMS

A Yes/No lookup to identify whether or not transactions shipping for the site are visible to a 3rd party Warehouse Management system. This defaults to "No", is required, and is always editable.

  • If "Yes', transactions shipping from the Site (for each Item that is also visible to WMS) will be visible/accessible to the Warehouse Management system.
  • If "No', transactions shipping from the Site will not be visible/accessible to the Warehouse Management system.

(lightbulb) This setting is only applicable for NorthScope installations that are integrated with a Warehouse Management system. 

Database Field: ERPx_MFSite.IsVisibleToWMS

Warehouse Lot Tracked

This is a single select lookup to Identify whether or not the Site manages 'Warehouse Lots' and if so, do you allow multiple Item IDs to be stored within the same 'Warehouse Lot'. This defaults to "No", is required, and is always editable. The lookup contains the following values:

  • No. Used for Sites that do not track/store Warehouse Lots. The Warehouse Lot property is disabled for all Items and/or Lots within the Site.
  • Yes - Allow multiple items in single lots. Used for Sites that track/store Warehouse Lots and that you allow Warehouse Lots that contain multiple Item IDs. 
  • Yes - Limit Warehouse Lots to single items. Used for Sites that track/store Warehouse Lots that are limited to a single Item ID. This is a default for all Warehouse Lots for this Site, but it can be overridden on specific Warehouse Lots in the Warehouse Lots LV.

(lightbulb) If this property is changed from 'No' either of the Yes options on a Site that contains Item/Lot history, a new Warehouse Lot will be auto created (as [SiteID]-Default) and assigned to all Inventory Lots for the Site and the message "The Warehouse Lot ID on all existing transactions for this Site has been updated to SITEID-Default" will be displayed on Save

Insert excerptDef - Warehouse LotDef - Warehouse Lotnopaneltrue

Database Field: ERPx_MFSite.IsSiteWarehouseLotTracked

Grid: Properties Tab Properties

...

Identifies how Warehouse Lot Numbers are auto-generated for applicable transfer line items. This is not visible for new Sites and is only required and editable for Sites where the following conditions are both true:

  • The 'Warehouse Lot Tracked' property is set to either: "Yes - Allow multiple items in single lots" or "Yes - Limit Warehouse Lots to single items"
  • The 'Auto Generate Warehouse Lots on Transfer Receipts' property is set to Yes

If these conditions are true and the value is missing, the message "[SiteID] has the "Auto Generate Warehouse Lots on Transfer Receipts" option turned on but is missing a selection for "Auto Generate Warehouse Lots by"" will be displayed on Save.

When this feature is enabled for the 'To Site' (the receiving Site) on an inventory Transfer transaction, the system will automatically populate the warehouse lot values in the 'To Warehouse Lot' , on Save. The values will be populated as either:

  • INTR:[SiteID]:[Reference Number] - for example INTR:BCS:12345
  • [Item ID]-[Production Batch Date MM][Production Batch Date YY] - for example 10015-0519
  • [Production Batch Date MM][Production Batch Date YY]-[Item ID] - for example 0519-10015

Linked Database Field: ERPx_MFSite.WarehouseLotTemplate

This lookup contains all the values in the WarehouseLotTemplateEN Enumeration Class.

...

This field displays a text box for the user to enter the registration number for the site. This field defaults to blank and is not required. This field is always editable.

...

This field displays a drop-down menu of all active vendors for the user to identify a specific vendor the site belongs to. This field defaults to blank and is not required. This field is always editable.

Address Tab

...

This field displays a text box for the user to enter the first address line for the Site. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.AddressLine1

...

This field displays a text box for the user to enter the second address line for the Site. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.AddressLine2

...

This field displays a text box for the user to enter the city in which the Site is located. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.City

...

Database Field: ERPx_MFSite.Country

...

Database Field: ERPx_MFSite.Email

...

Database Field: ERPx_MFSite.Fax

...

This field displays a text box for the user to enter the phone number of the Site. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.Phone1

...

This field displays a text box for the user to enter the state in which the Site is located. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.State

...

This field displays a text box for the user to enter the zip code in which the Site is located. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.Zip

Contacts Tab

...

This field displays the contact type. The default Contact Type is Shipping and it cannot be edited.

Database Field: ERPx_MFSiteContact.ContactTypeSK

...

This field displays the email address of the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Email

...

This field displays the fax number of the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Fax

...

This field displays the name of the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Name

...

This field displays a note added to the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Note

...

This field displays the phone number of the contact. This field defaults to blank and is not required. 

Database Field: ERPx_MFSiteContact.Phone

Lines Tab

...

This field displays a text box for the user to enter the line name for the site. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteLine.SiteLineName

Shifts Tab

...

This field displays a text box for the user to enter the shift name for the Site.

Database Field: ERPx_MFSiteShift.SiteShiftName

Certifications Tab

...

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. 

...

Displays the read-only name of the valid certifications to assign to the Site. Eligible certifications to assign to the site are those marked as Site Only or Item & Site in the Lot Certifications list view. To assign a certification to a site, simply check the certifications select box and save. All assigned certifications will filter to the top of the certifications list.

Related Sites Tab

...

Database Field: ERPx_MFSite.AddressLine1

...

Database Field: ERPx_MFSite.AddressLine2

...

Database Field: ERPx_MFSite.City

...

Database Field: ERPx_MFSite.Country

...

Database Field: ERPx_MFSite.SiteID

...

Database Field: ERPx_MFSite.SiteName

...

Database Field: ERPx_MFSite.State

...

Database Field: ERPx_MFSite.Zip

...

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

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

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



Related Topics



Expand
titlePage Definitions

Page Definitions


...

Expand
titleTechnical Details

Technical Details


dbo.ERPx_MFSiteContact
Table Names:
dbo.ERPx_MFSite
dbo.ERPx_MFSiteLine
dbo.ERPx_MFSiteShift


dbo.SPx_MFSEL_SiteProperties
Stored Procedures:
dbo.SPx_MFUPD_Site
dbo.SPx_MFSEL_SiteAddress
dbo.SPx_MFSEL_SiteCertificationList
dbo.SPx_MFSEL_SiteContactList
dbo.SPx_MFSEL_SiteLine