Versions Compared

Key

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

...

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.

...

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. 
  • 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. This field will default from the Default Site preference. 
  • 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. 

...

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

To add items not assigned to the selected Price List, click the New grid toolbar icon. This will display five blank lines for data entry, allowing the user to select any item. 

Note: Regardless of the item, the Default Account will always be the selected Crop's Purchase Account. 

Step 6: Adding Commodity Ticket Charges

...

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

...

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

...

Commodity Ticket Items Distributions

Positive Items

DebitPurchase Account Assigned to the Commodity Ticket's Crop
CreditVendor's Accounts Payable Account

Negative Items

DebitVendor's Accounts Payable Account
CreditPurchase Account Assigned to the Commodity Ticket's Crop

Commodity Ticket Charges Distributions

Positive Charges

DebitCP Ticket Vendor's Accounts Payable Account
CreditCredit Account Assigned to the Charge

Negative Charges

DebitCredit Account Assigned to the Charge
CreditCP Ticket Vendor's Accounts Payable Account


Commodity Ticket Accruals Distributions

Positive Accruals

DebitExpense Account Assigned to the Accrual
CreditAccrual Account Assigned to the Accrual

Negative Accruals

DebitAccrual Account Assigned to the Accrual
CreditExpense Account Assigned to the Accrual


For Commodity Ticket Charges with a Settle Method of AP Invoice, the following distributions will be created on the charge's AP Invoice that is sent in addition to the Commodity Ticket's transaction:

Positive Charges

DebitCredit Account Assigned to the Charge
CreditCharge Vendor's Accounts Payable Account

Negative Charges

DebitCharge Vendor's Accounts Payable Account
CreditCredit Account Assigned to the Charge


For Commodity Ticket Accruals with a Settle Method of AP Invoice, the following distributions will be created on the accrual's AP Invoice that is sent in addition to the Commodity Ticket's transaction:

Positive Accruals

DebitAccrual Account Assigned to the Accrual
CreditAccrual Vendor's Accounts Payable Account

Negative Accruals

DebitAccrual Vendor's Accounts Payable Account
CreditAccrual Account Assigned to the Accrual

Note: If any charges and accruals on a Commodity Ticket are assigned the same AP Vendor and are both set to a settle method of AP Invoice, they will create a single AP Invoice for their charges and accruals distributions. 


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

...