Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Grower Accounting Tickets record the purchase of crops or aquaculture harvests. The purpose of this page is to 

(lightbulb) This record view also contains columns for each Attribute that is set up for the 'Grower Accounting Fields' attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout. Grower Accounting Field attributes are not included in the help documentation.

Software Version: 2022.04.22 and newer

Page Header

Toolbar IconsDescription
Go To TicketOpens the Grower Accounting Ticket Record View for the current transaction. 
FieldsDescription
Delivered

Identifies the date the Hauler delivered the crop. This is a date picker field that is required.  It defaults as the current date but can be changed to another date.  The Delivered date cannot be before the Harvested date else the message "Delivered date must be on or after the Harvested date." will be displayed when "Go To Ticket" is clicked, or an option from the grid is double clicked. 

Database Field: ERPx_CPTicketHeader.DeliveryDate

Delivered By

Identifies the name of the Hauler that delivered the crop. This is a single select lookup that is not required.  This defaults to "(Use Default)" which will load the Default Hauler (if one exists) that is assigned to the selected Field for the corresponding record. 

Haulers are used in Grower Accounting to identify the entity that delivered the crop to the plant, cooler, or co-packer.

The lookup contains a list of all active Haulers.

Database Fields: ERPx_CPHauler.HaulerName, ERPx_CPField.HaulerSK

Harvested

Identifies the date the crop was harvested. This is a date picker field that is required.  It defaults as the current date but can be changed to another date.  The Harvested date cannot be after the Delivered date else the message "Delivered date must be greater than or equal to Harvested date." will be displayed when "Go To Ticket" is clicked.

Database Fields: ERPx_CPTicketHeader.HarvestDate

Harvested By

Identifies the name of the Harvester that harvested the crop. This is a single select lookup that is not required.  This defaults to "(Use Default)" which will load the Default Harvester (if one exists) that is assigned to the selected Field for the corresponding record.

Harvesters are used in Grower Accounting to identify the entity that harvested the crop being purchased.

The lookup contains the current selected value and the list of all the 'Active' Harvesters in the Harvesters master file.

Database Field: ERPx_CPHarvester.HarvesterName, ERPx_CPField.HarvesterSK

Load Items From Price List

Allows the user to choose whether the Items on the Price List assigned to the Farmer on the corresponding ticket should be loaded automatically on the Ticket record or not.  This is a single select lookup that is required.  This defaults to "Yes" and is editable. If 'Yes' is selected the Items will load from the associated Price List, otherwise if 'No' is selected there will be no Items automatically added to the Ticket record. 

Site

Identifies the Site associated with the Field where the crop was harvested from. This defaults to "(Use Default)" which will load the Site (if one exists) that is assigned to the selected Field for the corresponding record.

Database Field: ERPx_MFSite.SiteName, ERPx_CPField.SiteSK

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances.

The lookup displays all 'Active' Sites that are not assigned as "In Transit".

Ticket Number

Identifies the unique number/ID for the corresponding ticket.  This is a text box that is required. It defaults with "(Use Next Trans. #)" and is always editable. If missing, the system will auto assign based on how the Transaction Class is configured.

Database Field: ERPx_CPTicketHeader.TicketNumber

Page Details 

Toolbar IconsDescription
Column Filter Show / Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Group By Show / Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Excel

 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, or excluded columns, only the contents in the grid will be exported. 

Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
Crop 

Displays the Crop (Commodity and Variety) associated with the corresponding Field and Farmer.  This is a non-editable textbox that is required.  It defaults to the Crop assigned to the Field for the corresponding record. 

Database Fields: ERPx_CPCrop.Crop, ERPx_CPField.CropSK

Default Harvester

Displays the name of the Harvester associated with the corresponding Field and Farmer.  This is a non-editable textbox that is not required.  It defaults to the Harvester assigned to the Field, if one exists, for the corresponding record, otherwise it is blank. 

Database Fields: ERPx_CPHauler.HarvesterName, ERPx_CPField.HarvesterSK

Default Hauler

Displays the name of the Hauler associated with the corresponding Field and Farmer.  This is a non-editable textbox that is not required.  It defaults to the Hauler assigned to the Field, if one exists, for the corresponding record, otherwise it is blank. 

Database Fields: ERPx_CPHauler.HaulerName, ERPx_CPField.HaulerSK

Farmer Name

Displays the name of the Farmer associated with the corresponding Field.  This is a non-editable textbox that is required.  It defaults to the name of the Farmer assigned to the Field for the corresponding record. 

Database Fields: ERPx_CPFarmer.FarmerName, ERPx_CPField.FarmerSK

Field Name

Displays the name of the Field associated with the Farmer. This is a non-editable textbox that is required.  It defaults to the name of the Field associated with the Farmer for the corresponding record. 

Database Field: ERPx_CPField.FieldName

Growth Method


Database Field: ERPx_CPField.CPGrowthMethodEN

Price List

Displays the Price List ID assigned to the corresponding Farmer.  This is a non-editable textbox that is not required.  It defaults to the Price List ID associated with the Farmer for the corresponding record. 

Database Fields: ERPx_MFPriceList.PriceListID, ERPx_CPFarmer.PriceListHeaderSK


Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details


Table Names:

Stored Procedures:

  • No labels