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 

Page Header

Toolbar IconsDescription
Delete
Deletes the transaction or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

More Actions

 Displays a drop down menu of related actions. The list of options includes:

  • RV: Charges & Accruals - Opens the Charges & Accruals record view. 
  • RV: Journal Details - Opens the Journal Details window showing the Journal Entry for this transaction. 

    (lightbulb) Until the transaction Approved or Posted, this is a temporary journal entry so no Journal ID will be assigned. 

New
Allows users to select the class for the transaction they want to add. The list contains:
Notes
Opens the Notes dialog, filtered for the appropriate Note Type(s), allowing the user to enter Notes for the selected line item. From here, users can add, review, or edit Notes associated with the line item. If no line items are selected, entered Notes will apply to all line items and be appended to any existing Notes. This toolbar icon is always enabled. 
Print Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. 

When clicked, all the Reports that launch from the Print Dialog that are assigned to this page, and that the user has rights to (if Report Data Access is enabled) are displayed.

Save
Saves the changes made to the record. 

(lightbulb) It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

FieldsDescription
Accruals


Error rendering macro 'excerpt-include' : No link could be created for 'Def - Accrual - GA'.

Database Field: ERPx_CPTicketHeader.GrossAccrualsAmount

Charges


Error rendering macro 'excerpt-include' : No link could be created for 'Def - Charges (GA)'.

Database Field: ERPx_CPTicketHeader.GrossChargesAmount

Crop


Crops are used in Grower Accounting to identify the unique combination of Commodity and Variety.

Database Fields: ERPx_CPCrop.Crop, ERPx_CPTicketHeader.CropSK

Delivered 



Database Field: ERPx_CPTicketHeader.DeliveryDate

Field


Fields represent the objects farmers grow crops in. A field is unique by combination of: [Field Name] + [Farmer Name] + [Crop] + [Growth Method]. For Example, you can have Field #1 for Farmer ABC and for Farmer XYZ. Fields are used in Grower Accounting master files and transactions.

Database Fields: ERPx_CPField.FieldName, ERPx_CPTicketHeader.FieldSK

Gross Weight 


The 'Gross Weight' describes the total weight that was offloaded from the vehicle. It includes tare weights for things like packaging, containers, and pallets. It is calculated as [Weight In] - [Weight Out].

Database Field: ERPx_CPTicketHeader.GrossWeight

Harvested



Database Field: ERPx_CPTicketHeader.HarvestDate

Hold Code


Hold Codes are used to prevent a process from being performed or a transaction from being posted.

Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK

Net Weight 


Error rendering macro 'excerpt-include' : No link could be created for 'Def - Net Weight'.

Database Field: ERPx_CPTicketHeader.NetWeight

Paid Weight 


'Paid Weight' describes the weight that was included in the 'Net Weight' that is being paid for or deducted (items with a non-zero price). [Delivered Weight] - [Unpaid Weight] = [Paid Weight].

Database Field: ERPx_CPTicketHeader.PaidWeight

Price List


Price Lists are used to store a group of Items with pre-defined prices and effective dates.

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

Identifies the name of the Site (warehouse) the transaction, shipment, or master file is associated with. 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

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

Status is used to identify where a transaction, Purchase Order, Price List, BOM, or Master File record is in its life cycle. Records start in a Status of 'New' and progress sequentially through additional statuses until they are 'Posted' or 'Closed'. The list of potential Statuses changes depending on the transaction type.  The Statuses that apply to transactions in this Record View include:

  • New: This is the default Status for all new Transactions. While in the Status of 'New' transactions are considered open and all editable fields are open for edit, no posting or approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will be assigned and a Journal Entry will exist.  
  • Received
  • Graded
  • Reviewed
  • Approved
  • Ready To Post


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


A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketHeader.SampleUOMSK

Weight In


Database Field: ERPx_CPTicketHeader.WeightIn

Weight Out


Database Field: ERPx_CPTicketHeader.WeightOut

Properties Tab

Property NameDescription
Group Ticket
GL Date


Database Field: ERPx_CPTicketHeader.GLDate

Hauler


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

Database Fields: ERPx_CPHauler.HaulerName, ERPx_CPTicketHeader.HaulerSK

Harvester


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

Database Fields: ERPx_CPHarvester.HarvesterName, ERPx_CPTicketHeader.HarvesterSK

Ticket Version


By default, a new transaction is set to Version 1. If the transaction has been voided, corrected or repriced, the version number will be incremented. In order for a transaction to have a version greater than 1 all the previous versions must be voided (a transaction can only have one active version). 

Database Field: ERPx_CPTicketHeader.TicketVersion

Created

Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.

Database Field: ERPx_CPTicketHeader.CreatedDate

Created By

Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user.

Database Field: ERPx_CPTicketHeader.CreatedBy

Last Updated

Identifies the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.

Database Field: ERPx_CPTicketHeader.LastUpdated

Last Updated By

Identifies the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user.

Database Field: ERPx_CPTicketHeader.LastUser

Tare Tab

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

New Opens a new blank record for data entry.
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.
FieldsDescription
Container Tare


Database Field: ERPx_CPTicketContainer.ContainerTare

Containers Per Pallet


Database Field: ERPx_CPTicketContainer.ContainersPerPallet

Number of Containers 


Database Field: ERPx_CPTicketContainer.NumberofContainers

Number of Pallets


Database Field: ERPx_CPTicketContainer.NumberofPallets

Pallet Tare


Database Field: ERPx_CPTicketContainer.PalletTare

Total Container Tare



Total Pallet Tare



Total Tare


Database Field: ERPx_CPTicketContainer.TotalTare

Attributes Tab

FieldsDescription
Attributes

A non editable text box that shows the name of the Attribute. Attributes are user-definable fields that are used on master files and transactions and are editable from the Attributes List View. The Attribute will only be displayed if the Applies property on the Assign Attribute Rules by page is set to either "Yes - Required" or "Yes - Not Required". Attributes set to "No" will not be displayed. 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

Identifies the value assigned to the corresponding attribute.

Because Attributes are configurable as either Text, List, Date, or Date/Time the data entry is either a text box, lookup, or date picker. The value defaults to blank and is only required if the Attribute's 'Applies' property is set to "Yes - Required" in the Assign Attribute Rules page. Attribute Values for Master Flies are always editable. Attribute Values for transactions are always editable for unposted transactions.

 This is editable if the Transaction Class property 'Allow Attribute Edit After Approval' is set to "Yes".  

Page Details 

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
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. 

NotesOpens the Notes dialog, filtered for the appropriate Note Type(s), allowing the user to enter Notes for the selected line item. From here, users can add, review, or edit Notes associated with the line item. If no line items are selected, entered Notes will apply to all line items and be appended to any existing Notes. This toolbar icon is always enabled. 
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.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
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
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

Identifies the GL Account the purchase line will post to.

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

Sample Size


Database Field: ERPx_CPTicketItem.SampleWeight

Total Weight


Database Field: ERPx_CPTicketItem.TotalWeight

UOM


A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK


Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details


Table Names:

Stored Procedures:

  • No labels