Table of Contents
maxLevel 2

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. 

...

• 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)'
  • 'Enable Real Time Integration'

Understanding the data flow

A Commodity Ticket records purchases from farmers. When the transaction status is changed to “Ready to Post,” an AP Invoice will be sent to the host system for the AP Vendor associated with the Farmer on the Commodity Ticket. For positive items on the Commodity Ticket, the Crop's Purchase account will be debited for the amount of the item and the vendor's accounts payable account will be credited. For positive charges, the vendor's accounts payable account will be debited the amount of the charge and the credit account assigned to the charge will be credited. For positive accruals, the accrual's expense account will be debited for the amount of the accrual and the accruals' credit account will be credited. For negative values, these distributions will be opposite. 

Note: These integrations will only occur if the Commodity Procurement module preference for 'Enable Real Time Integration' is set to 'Yes'. 

Step 1: Selecting the Farmer, Field, and Crop

...

• 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 . However, this field is editable and can be greater than, less than, or equal to 0.
• 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. 

...

Once the header information is saved, the Charges grid tab will automatically refresh to display all charges assigned to the selected price list. These charges will display will with the following field values:

• Charge Item: This will display the name of the Charge Item.
• Calculated On: This will display the calculation method assigned to the Charge Item. This is determined on the Charge Charges list view and is not editable from the Commodity Ticket record view. 
  • $ Fixed Amount: The total charge amount will equal the rate entered, regardless of the item quantity.
  • % Gross $: The total charge amount will equal the percentage entered as the charge rate of the ticket's gross dollar amount.
  • Delivered Weight: The total charge amount will equal the product of the charge rate times the total delivered weight, which equals the sum of the paid and unpaid weight.
  • Paid Weight:The total charge amount will equal the product of the charge rate times the total paid weight, which is the sum of the total weight of all items with a price other than $0.
  • Unpaid Weight: The total charge amount will equal the product of the charge rate times the total unpaid weight, which is the sum of the total weight of all items with a $0 price.
• Settle Method: This will display the settle method assigned to the Charge Item. This is determined on the Charge Charges list view and is not editable from the Commodity Ticket record view. 
  • AP Invoice: Upon posting the Commodity Ticket, a separate AP Invoice will be created for the AP Vendor assigned to the Charge Item. If the amount of the charge is positive, the invoice will debit the vendor's accounts payable account for the amount of the charge and will credit the expense account assigned to the charge. If the amount of the charge is negative, the invoice will debit the expense account assigned to the charge and will credit the vendor's accounts payable account. 
  • GL Accrual: Upon posting the Commodity Ticket, two additional distributions will be included on the AP Invoice sent to the host system for the Commodity Ticket. If the amount of the charge is positive, the additional distributions will be a debit to the vendor's accounts payable account for the amount of the charge and a credit to the expense account assigned to the charge. If the amount of the charge is negative, the additional distributions will be a debit to the expense account assigned to the charge and a credit to the vendor's accounts payable account. 
• Applies to Item(s): This will display the items to which the Charge Item applies. This is determined on the price list and is not editable from the Commodity Ticket record view. 
• Rate: This will display the rate assigned to the Charge on the price list. However, this is editable . and can be greater than, less than, or equal to 0.
• UOM: This will display the UOM on which the calculation of the charge is based. This is determined on the Charge Charges list view and is not editable from the Commodity Ticket record view. 
• Amount: This will default to 0 but will auto-calculate on save to display the amount of the charge. 

Step 7: Adding Commodity Ticket Accruals

To view a description of each of the Commodity Ticket Accruals Grid Tab fields, click here.

Once the header information is saved, the Accruals grid tab will automatically refresh to display all accruals assigned to the selected price list. These accruals will display with the following field values:

• Accrual Item: This will display the name of the Accrual Item. 
• Calculated On: This will display the calculation method assigned to the Accrual Item. This is determined on the Accruals list view and is not editable from the Commodity Ticket record view.
  • % Gross $: The total accrual amount will equal the percentage entered as the accrual rate of the ticket's gross dollar amount.
  • Delivered Weight: The total accrual amount will equal the product of the accrual rate times the total delivered weight, which equals the sum of the paid and unpaid weight.
  • Paid Weight:The total accrual amount will equal the product of the accrual rate times the total paid weight, which is the sum of the total weight of all items with a price other than $0.
• Settle Method: This will display the settle method assigned to the Accrual Item. This is determined on the Accruals list view and is not editable from the Commodity Ticket record view.
  • AP Invoice: Upon posting the Commodity Ticket, a separate AP Invoice will be created for the AP Vendor assigned to the Accrual Item. If the amount of the accrual is positive, the invoice will debit the expense account assigned to the accrual for the amount of the charge and will credit the accrual account assigned to the accrual. If the amount of the accrual is negative, the invoice will debit the accrual account assigned to the accrual and will credit the expense account assigned to the accrual. 
  • GL Accrual: Upon posting the Commodity Ticket, two additional distributions will be included on the AP Invoice sent to the host system for the Commodity Ticket. If the amount of the accrual is positive, the additional distributions will be a debit to the expense account assigned to the accrual for the amount of the accrual and a credit to the accrual account assigned to the accrual. If the amount of the accrual is negative, the additional distributions will be a debit to the accrual account assigned to the accrual and a credit to the expense account assigned to the accrual. 
• Applies to Item(s): This will display the items to which the Accrual Item applies. This is determined on the price list and is not editable from the Commodity Ticket record view. 
• Rate: This will display the rate assigned to the Accrual on the price list. However, this is editable and must be greater than or equal to 0.
• UOM: This will display the UOM on which the calculation of the accrual is based. This is determined on the Accruals list view and is not editable from the Commodity Ticket record view. 
• Amount: This will default to 0 but will auto-calculate on save to display the amount of the accrual. 

Step 8: Finalizing the Transaction in NorthScope

Changes can be made to a transaction until it is finalized. To finalize a transaction, the user will need to change the status to “Ready to Post”. In some companies, posting is a two-step process where the transaction(s) are approved by one person, and posted by another.

Approving the transaction

This step is optional and is used for companies that require a two-step process where the person who approves the transaction cannot be the same person that posts the transaction.

To approve a transaction, open it from the list view, change the status to “Approved”, and click the “Save” icon on the header toolbar. In addition to the validations performed each time the “Save” icon is clicked, the following validations are also performed:

• Ensures the Delivered Date resides within an open fiscal period. 
• Ensures all required user-defined fields have been entered or selected.
• Ensures the Net Weight equals the sum of the Items Total Weight column

If any of the GL Accounts cannot be assigned, a message will appear.

Once the status has been successfully updated to “Approved”, all editable fields, with the exception of Status, will be disabled.

Finalizing the transaction 

When the transaction is ready to be finalized, open it and change the status to “Ready to Post” and save the transaction. Setting the transaction to “Ready to Post” does the following:

• Validates the same conditions as the approval status
• Locks down all editable fields, including Status
• Creates an un-posted AP Invoice transaction in the host system for the Commodity Ticket if the farmer has a settle method of AP Invoice
• Creates an unposted NorthScope journal entry for the Commodity Ticket if the farmer has a settle method of GL Accrual
  • This journal entry will automatically integrate to the host system as an unposted Transaction Entry in the Financial module
• Creates an additional un-posted AP Invoice transaction in the host system for any Charges or Accruals with a settle method of AP Invoice

Prior to this, the host system does not know about the transaction.

Step 9: Posting the Commodity Ticket's components in the host system.

For every Commodity Ticket in NorthScope, either a journal entry or an AP Invoice will be sent to the host system. This is determined by the Farmer selected on the Commodity Ticket. Each farmer in NorthScope is assigned a Settle Method. If the farmer's settle method is 'AP Invoice', the farmer's Commodity Tickets will send AP Invoices to the host system upon posting. If the farmer's settle method is 'GL Accrual', the farmer's Commodity Tickets will create NorthScope journal entries that will be sent to the host system. 

In addition, for every charge accrual assigned to a Commodity Ticket, either distributions will be included on the Ticket's journal entry or AP Invoice to account for the charge(s) and/or accrual(s) or a separate AP Invoice will be created for each charge and/or accrual for the AP Vendor assigned to the corresponding charge/accrual. This is determined by the charge/accrual setup. Each charge/accrual in NorthScope is assigned a Settle Method. If the charge's/accrual's settle method is 'AP Invoice', an AP Invoice, separate from the Commodity Ticket, will be sent to the host system for the AP Vendor assigned to the charge/accrual. If the charge's/accrual's settle method is 'GL Accural', additional distributions will be included on the Commodity Ticket's AP Invoice or journal entry to account for the charge/accrual.

Any AP Invoices that integrate will be sent to the host system in a batch within the host system's Purchasing module. Any journal entries that integrate will be sent to the host system in a batch within the host system's Financial module.

Regardless of the transaction type that is integrated, the distributions will be as follows:

Commodity Ticket Items Distributions

Positive Items

Negative Items

Commodity Ticket Charges Distributions

Positive Charges

Negative Charges

Commodity Ticket Accruals Distributions

Positive Accruals

Negative Accruals

Once the user is satisfied that all distributions are correct, the user can post the batch(es) in the host system.

Note: Although this step is required, it does not need to be done for each transaction. Posting can be done nightly or as needed.

Step 10: Reviewing in NorthScope

Whether or not Step 9 is complete, the following will occur in NorthScope if the Commodity Ticket Farmer has a settle method of GL Accrual:

• The Commodity Ticket will update from 'Ready to Post' to 'Posted' and will no longer be visible in the Commodity Procurement Tickets list view. 
• A journal entry will be created in NorthScope's Financial module with a status of 'Ready to Post'

Once Step 9 is complete, the following events will happen in NorthScope:

• The NorthScope journal entry (if applicable) will update from 'Ready to Post' to 'Posted' and will no longer be visible in the Financial Journal Entries list view.
• The Commodity Ticket will update from 'Ready to Post' to 'Posted' and will no longer be visible in the Commodity Procurement Tickets list view.