Commodity Setup

Information for each type of commodity being purchased, sold, and/or stored is entered here. This information is used throughout the Agvance Grain program as Scale Tickets are entered, commodities are received, and grain is shipped. Commodity specific factors may be established that affect the quantity and dollar value of the transaction (shrinkage and premium/discount factors).

If a commodity is handled at more than one location, it is only necessary to enter it once. It is then available at all locations.

Add various commodities at Setup / Commodities.

  • Commodity ID – This required field is the primary reference used to identify the commodity. The maximum number of characters allowed in the field is 6.
  • Name – Enter the name of the commodity. This name displays when selecting the commodity in list boxes. The maximum number of characters allowed in the field is 30.
    Note: For some reports it may help to keep the names as short as possible. For example, DPR and TPR.
  • Inactive – Select this option if the commodity is inactive. There must be no open activity to allow the Commodity to be saved as inactive. Marking a commodity as inactive removes it from all transaction selection windows and report selection options.
  • Unit of Measure – Enter the unit of measure to be used to inventory this commodity. Abbreviations are acceptable and encouraged. The maximum number of characters allowed in the field is 6.
  • Lbs/Unit – Enter the weight in pounds of one unit (of measure) of this commodity. This is often pounds/bushel.
  • Units/Metric Ton – Entering the units per metric ton in this area allows bushels to be converted to metric tons.
  • Decimals – This is the number of decimals the program uses to calculate and display quantity for this commodity. Although the quantity is stored as 4-decimals, this controls the display of the quantity with options 0-4 being the choices.
  • Min Price/Max Price – Optionally set the minimum and/or maximum prices that may be saved when entering prices on priced Scale Tickets and priced Settlements (Priced, Installment Sale, and Deferred Payment).
  • Commodity ID Cross Reference – These are four non-specified fields typically used as a cross reference for this commodity when interfacing with another application. One application that requires one of these fields is the e-ADM import.

Location Receiving Totals

This area of the commodity setup is location-specific and displays summarized receiving and shipping information for the commodity. Multi-location companies can view this information per location by selecting different locations from the drop-down box located directly under the Location Receiving Totals heading. Locations are setup in Accounting / Setup / Locations.

  • Location – Once a commodity is set up, it becomes available for use by all locations. Location-specific information about the commodity is available by selecting the location in the drop-down.
  • Print on DPR – Select this option to allow the commodity to print on DPR reports and the Grain View function.
  • Print on TPR – This option allows the commodity to print on the Trading Position report.
  • Agvance Product Linked to this Commodity/Location – Double-click in this field to link this commodity with a product set up in Agvance Accounting. This linked product is used when creating an Invoice from the Shipment.
    Note: The linked product must have the unit weight filled out appropriately for the inventory unit.
  • Agvance Grain Bank Product Linked to this Commodity/ Location – Select the product to be used in Accounting when Grain Bank grain is invoiced. This must not be the same product used to link the commodity/location which is used for local sales.
  • Patronage Category – Double-click on Category to select any appropriate patronage categories for the commodity. Also select if paying on Regular Settlements, Direct Shipments, or Both.
  • Tax Code – If there is a Settlement Deduction to be associated with this commodity/location, double-click and select the appropriate code.
  • Override Master Schedule – Enter the schedule to be used instead of the master for the commodity/location. This schedule overrides the master for any premium/discount, shrink, or dock tables set to this schedule.
  • Setup Charges – Set Settlement defaults and default product IDs for invoicing Storage/Service Charges per Commodity/Location.

  • DPR Category – This represents the ToDPR selected in the Source section of the Settlement screen.
  • Charge Schedule – Select the Charge Schedule to default when settling to the corresponding DPR Category. The default may be changed.
  • Settlement Action – This determines how the Accumulated Storage/Service Charges are handled on a Settlement.
  • Service Item – Select the product to use when service charges are invoiced.
  • Storage Item – Select the product to use when storage charges are invoiced.
    Note: Even if not invoicing Storage/Service Charges, these two items must be set up for running the Storage and Service Charges report.

Grade Factor Grid

  • Grade Factor – Double-click to add Grade Factors specifically associated with this commodity.
  • Min Value – Enter the minimum value for each grading factor. If there isn’t a minimum value, enter 0.
  • Max Value – Enter the maximum value for each grading factor. If there isn’t a maximum value, enter 999.
    Note: If used, these values act as the data entry validation ranges on the Scale Ticket and Settlement windows.
  • Allow Skip – Selecting this for a Grade Factor allows Scale Ticket information to be saved without entering a result for this Grade Factor.
  • Use Average – Select to average the result of the open Scale Tickets for this Grade Factor/Commodity.
  • Default Value – Enter the default value to populate on Scale Tickets being added in Agvance Grain and Agvance Grain Scale Interface.

Reshrink to Average Moisture

  • Require Prepare for Settlement – If selected, assemblies for the commodity are not available for settlement until Prepare for Settlement is selected on each Assembly.
  • Include Zero – Selecting this option includes moisture results of zero in the averaging.
  • Grade Factor – Select the Grade Factor to be averaged.
  • Assembly Average – This option allows all the Scale Tickets on the Assembly to be eligible for averaging.
  • Daily Ave. of – This option applies a daily average for Scale Tickets on Assemblies to the Grade Factor based on the specified range.
  • High/Low Divide – This is a set value at which a warning occurs if an Assembly has test results at or above this value which are too high to be averaged with other Scale Tickets on the Assembly. Scale Tickets with this value or higher should be put on a different Assembly.
  • Decimals – This sets the number of decimal places to be included in the averaging results.
  • Grades – This is the area where Warehouse Receipt Grades are defined by the test results of each Grade Factor that affects the grade for the commodity being edited.

  • Grade – Enter an ID for the grade.
  • Description – Enter a description for the grade.
  • Grade Factor – Select a Grade Factor from the list.
  • Minimum – Enter the minimum value for the Grade Factor.
  • Maximum – Enter the maximum value for the Grade Factor.
  • Check Grade Factor – Select if this is a Grade Factor to be used to determine this grade.
  • Classifications – Select a classification to be applied to the commodity.