Overview
Commodity Tickets are used to record the purchasing of commodity items from farmers. This transaction does not use inventory items or integrate with NorthScope’s Inventory module.
Prerequisites
Required Prerequisites
Before entering a commodity ticket transaction, users must complete the following:
- Crops Setup
- Commodity Items Setup
- Farmers Setup
- Fields Setup
- Financial Account setup
- Set the Commodity Procurement preference for 'Scale Weight UOM'
Optional Prerequisites
The following prerequisites are not required, but users are encouraged to set them up:
- Charges Setup
- Accruals Setup
- Price Lists Setup
- Haulers Setup
- Harvesters Setup
- Set the Commodity Procurement preference for:
- 'Default Site'
- 'Invoice Prefix'
- 'Decimal Places Prices (0-5)'
- 'Decimal Places Quantities (0-5)'
Understanding the data flow
Step 1: Selecting the Farmer, Field, and Crop
Entering a new commodity ticket
From NorthScope, expand the Commodity Procurement module on the navigation menu and select “Tickets”. This will open the Tickets List View, which displays all commodity tickets with a status of New, Received, Quality Check, Approved, or Ready to Post.
Click the “New” icon in the header toolbar and select the type of commodity ticket to be created from the "New" drop-down menu. The "New" drop-down menu will include a list of all Commodity Procurement Ticket Classes.
Selecting a Ticket Class from the New drop-down menu will open the New Commodity Ticket window.
Selecting the farmer, field, and crop combination
When the “New Commodity Ticket” page opens the user can:
- Manually input the Commodity Ticket number or leave it as '(Use Next Number)' to use the next available number
- Enter the delivery date
- Enter the hauler
- Enter the harvest date
- Enter the harvester
- Select the farmer, field, crop, and price list
In order to select the farmer, field, and crop combination, the user is presented with a list of fields that are assigned crops that are applicable to the delivery ticket type being created, complete with the farmer, crop, default harvester, and default hauler assigned to the field as well as the price list assigned to the corresponding farmer.
To select a farmer, field, and crop combination, select the row that displays the correct combination. The values in the row selected will default to the commodity ticket record view as follows:
- Farmer Name: This field will default to the Farmer header field and will not be editable.
- Field Name: This field will default to the Field header field and will not be editable.
- Crop: This field will default to the Crop header field and will not be editable.
- Default Harvester: This field will default to the harvester header field if the Harvested By header field on the New Commodity Ticket window is set to '(Use Default)'. This field will be editable.
- Default Hauler: This field will default to the hauler header field if the Delivered By header field on the New Commodity Ticket window is set to '(Use Default)'. This field will be editable.
- Price List: This field will default to the price list header field and will be editable.
Once the user has selected the correct combination, click the “Save” icon to open the new commodity ticket.
Step 2: Completing the Commodity Ticket: Home Tab Fields
The Commodity Ticket record view has three header tabs, the first of which is the Home tab. To view a description of each of the Commodity Ticket Home tab header fields, click here.
- Class: This will default from the selected Ticket Class.
- Crop: This will default from the New Commodity Ticket window and is not editable.
- Delivered: Enter the delivery date of the commodity items. This will default from the New Commodity Ticket window but is editable.
- Farmer: This will default from the New Commodity Ticket window and is not editable.
- Field: This will default from the New Commodity Ticket window and is not editable.
- Gross Weight: This field will auto-calculate the sum of the weight in less the weight out and is not editable.
- Harvested: Enter the harvested date of the commodity items. This will default from the New Commodity Ticket window but is editable.
- Harvester: Select the harvester that harvested the commodity items. This will default from the New Commodity Ticket window but is editable.
- Hauler: Select the hauler that delivered the commodity items. This will default from the New Commodity Ticket window but is editable.
- Method: Select the harvest method used.
- Net Weight: This field will auto-calculate the sum of the gross weight less the total tare.
- Price List: This will default from the New Commodity Ticket window.
- Sample Size: Enter the sample size taken of the commodity items.
- Site: Select the Site for which the commodity items were purchased.
- Status: Select the status to save the ticket in.
- Ticket: This will default from the New Commodity Ticket window.
- Total Tare: Enter the total tare weight of the commodity items' delivery. This can also be managed from the Tare tab.
- Weight In: Enter the weight of the commodity items' delivery as it came in.
- Weight In UOM: Select the unit of measure in which the weight is recorded. This will default to the preference setting for 'Scale Weight UOM'. This value will be inherited by the line items.
- Weight Out: Enter the weight of the commodity items' delivery as it left.
Step 3: Completing the Commodity Ticket: Tare Tab Fields (Optional)
The Commodity Ticket record view has three header tabs, the second of which is the Tare tab. To view a description of each of the Commodity Ticket Tare tab header fields, click here.
- Containers Per Pallet
- Container Tare
- Number of Pallets
- Pallet Tare
- Total Container Tare
- Total Pallet Tare
- Total Tare
If the Tare tab fields are filled out, the Total Tare header field on the Home tab will automatically calculate based on the Tare tab's values and will become disabled.
Note: To create additional pallets, click the New header toolbar icon. This will open an additional two pallet line items for data entry.
Step 4: Completing the Commodity Ticket: User-Defined Tab Fields (Optional)
The User-Defined tab on the Commodity Ticket transaction will include all User-Defined Attributes assigned to the Commodity Procurement - Commodity Ticket transaction.
To setup User-Defined Attributes available to the Commodity Procurement module, navigate to Company→User-Defined Attributes→Commodity Procurement→Add/Edit.
To setup User-Defined Attributes for the Commodity Ticket transaction, navigate to Company→User-Defined Attributes→Commodity Procurement→Transactions→Commodity Ticket.
The user-defined attributes assigned to the Commodity Ticket transaction will display on the User-Defined tab of the Commodity Ticket record view. Enter or select the values to assign to each attribute. Any attribute setup as required will be validated on a status of 'Approved'.
Step 5: Adding Commodity Ticket Items
To view a description of each of the Commodity Ticket Items Grid Tab fields, click here.
Once the header information is saved, the Items grid tab will automatically refresh to display all items assigned to the selected price list. These items will display will the following field values:
- Item: This will display the Item and Item Description of the Commodity Item.
- Sample Size: This will default to 0 and will display the number of decimals setup for the 'Decimal Places Sample Size'. Enter the amount of the corresponding line item that made up the sample size.
- Percent: This field will default to 0% but will automatically calculate on save to display the percentage of the sample size that is attributed to the line item. This field is not editable by the user.
- Total Weight: This field will default to 0 but will automatically calculate on save to display the total weight of the item by taking the item's percent and applying that to the header Net Weight.
- Price: This field will default to the item's price as setup on the price list but is editable.
- UOM: This field will default from the Weight In UOM in the header.
- Amount: This field will default to 0 but will update on save to calculate the total amount for the line item by multiplying the Total Weight by the Price.
- Default Account: This field will default to the Purchase Account assigned to the Crop selected in the header.