Basic setups needed prior to entering discount tables.
Ensure Discount Code has been entered. Grain > Commodity Tables > Discount Codes
Determine if you want your Discount Tables to be different for each Location, Commodity Code, State/County Code, Variety Class, Unit of Measure.
Determine what Discount Codes you want to see, by Commodity, by Location on every ticket, contract, delivery sheet & settlement. Grain > Commodity Tables > Commodity Code
Here is an example of a Discount Code setup screen:
Assign the Discount Codes to the commodity, in the order that you want to enter the grades. Each commodity can have up to 32 factors where you enter a numeric grade, and 8 additional factors intended to be Y/N factors, like Musty, Sour, Freight Charges, etc.
Also note the order on the right-hand side of the Discount Code setup screen. This order is important in ensuring your discounts are calculated properly based on gross or net bushels. If you have factors that are going to reduce the weight of the ticket, like Dockage or Moisture Shrink, you would want to make those factors be first in the sort order, so that the Dockage or Shrink is deducted before any Discount Factors that are monetary Discounts based on Net Bushels. If you have both Moisture Shrink & Dockage, you will need to determine which should be deducted 1st, then should the 2nd item be deducted from the net of the 1st calculation or still off of gross. Depending on what you decide can make a few bushels difference in arriving at the final net bushel you will be paying for.
Building Discount Tables
To build Discount Tables go to Grain > Commodity Tables > Discount Tables > Add New Discount Table
Enter Discount Code
Enter Commodity Code and/or Location, State/County, Variety Class, UOM depending on how you set your Discount Code.
Determine the table code. This code can be up to 3 characters. It can be alpha, numeric or combination of both.
Establish the Effective Date of the table. This date determines what tickets and contracts can use this table. Tickets with a shipment date earlier than this date, and contracts with a contract date earlier than this date will not have access to this table. Only shipment & contract dates on this date & forward will use this table. The Effective Date can be back dated if needed. It also can be a date in the future, if you know your rates are changing on a specific date in the future, you can enter the table ahead of time to be ready for the rate change.
Determine the Rate Method, there are 4 choices, Flat Fee, Maximum Allowed, Rate for Each Grade, or Freight Expense Amount.
Determine if you want the effective date entered in step 4 to be based on the Shipment Date of tickets or the Contract Date.
Tables can be set to only be used when certain conditions apply. The question Use This Table Only When: allows you to setup a table to only be used if another grade factor is equal to, greater than or less than a certain factor. An example might be, give Protein premium only if TW is over 60 #. Then the Protein scales you build in this table would only apply if the TW is over 60#.
Last thing on this page is a table description. I always recommend trying to put a description that gives the user some sort of idea what the discount scale is. So, if a user is picking discount tables from a drop down box they have an idea if it's going to discount the way they intended.
Decide if you need to enter each grade at a time or if you can enter ranges of grades. A range of grades will be much faster than enter 1 factor at a time.
If you selected Multiple Grades, determine what the beginning factor is. Keep in mind, your table does not have to include just factors that are discounted or giving a premium. It should also include the factors that are at a zero rate. Example: Corn Moisture shrink starts at 15.6. Enter as low as you think you will get moisture, or you can even start at .1 up to 15.5 with a zero rate. This ensures that when applying tickets with low moisture, you don't get a popup message of Discount Table Not Found.
Note, even though the rates are zero, you still need to enter a Rate Type. Since the discount table portion of my table will be a % of Gross Bu that is the rate type I chose to keep it consistent. But it doesn't really matter what you use. After clicking OK, you see a summary of what you created.Click Ok & select Multiple Grades again to build the next increment needed. Note that the screen retains the last entries you made. Just enter over them for your new selections.
Start with the next increment from where you ended the last time. This example 15.6 is where we will start discounting.
For the Rate field, enter the rate amount for the grade factor entered under Beginning Grade. This example is 1.5% shrink.
Next you determine at what point in the grade factor range does the increments change? Does the factor increments change every .1 of a point, every .5 point, or every 1.0, etc.? This example the grade increment changes every ½ % or .5 points.
Next determine what is the rate increment change, at each grade factor increments? In this example the rate increment starts out increasing an additional 1.5% each .5 point, but it doesn't stay consistent all the way to the end of the table. So we have to break this up into 2 attempts at building the table. So for the Rate Increment we enter 1.5. The 2 boxes of Increments are stating, for every .5% of moisture increase the shrink an additional 1.5%.
Next you enter the Ending grade factor where the grade increment & rate increments are still the same increments. In this example, after 18.5 the rate increment changes to 2.0% each .5 points, so we have to end this run at 18.5.
Determine the Rate Type method. A listing is provided on the screen so you can select the appropriate choice for the type of discount/premium. This example is shrink, so select #1=Percent of Gross Bu.
Finally select whether it's a Discount or Premium.
Click Ok to verify what you have entered its correct
Click Ok & select #2 Multiple Grades again & repeat steps A – G as many times as needed for each grade increment change or rate increment change. Always starting with the next factor from where you left off on the prior screen. We'll start at 18.6 as the Beginning grade. But for the rate you must incorporate the rate you had already built up to, plus whatever the rate increase is changing to. So prior, we build up to 18.5 moisture for a 9% shrink, and now our shrink factor is changing 2% every .5 points, so we need to add the 9% +the 2% increase to enter 11% for the rate of discount for a 18.6 grade factor.
The Grade factor increment does not change in this case, it's still .5, but the Rate increment does change as now we want to increase the shrink by 2% for every .5 points of moisture. So we enter 2.0 as the Rate increment.
Lastly enter the Grade factor that you want to end the table. Either the ending factor where the Grade & Rate increments are the same or the highest Grade level you would accept for that grade factor. This example I'm ending at 20.0, but most likely you would want your table to go much higher.
The Rate Type & the Discount/Premium fields will be filled in from the prior screen. Your screen should look something like this before you hit OK.
After clicking OK, you can view & verify that everything was entered correctly. 
After clicking OK the submenu comes up again. At this point you can either select to Save/Exit or you can take the opportunity to Display All Grades to see the whole table come together to ensure there are no missing factors or rates.
We can now see the whole table. Any grade factor entered from .1 - 20.0 the system will now know what rate to shrink or not. Tables do display a little oddly for each increment break. Each time there is an increment break you get 2 lines at the last rate. But this is ok, it has the correct rates for every factor. There is not a way to avoid this. You may not be able to see the whole table on 1 screen. The system will prompt you through each screen needed to see the whole table if you keep clicking ok.
After clicking Ok & you get the submenu, make sure you select #4 Save/Exit to save the new table. And it brings you back to allow entering additional tables, either for this same Discount Code or you can enter a different Discount Code & start another new table.
There is a great feature within Discount tables if you have created a table, but need to replicate that table for another Commodity, Location, State/County, Variety Class, or UOM. We have the ability to Default, a new table or edit an existing table, from an already existing table. This saves so much time when having to do numerous tables at a time.
Start by Adding a New Discount table (same steps apply if you use View/Edit an Existing Table).
Enter the Discount Code.
Enter Commodity Code and/or Location, State/County, Variety Class, UOM depending on how you set your Discount Code.
Enter the Discount Table Code & Effective Date.
Change your table description.
Click the Default button at the bottom of the screen.
This brings up a list of all the tables for that Discount Code. Highlight the table that has the same discount rates that you want to create, and hit Select. This will bring in all of the same Grade Factors & Rates. You can Edit if you need to change any rate or add more. Or you can Display All Grades to view that it brought all the factors & rates in you intended. Or you can Save/Exit & the new table is built.
Editing Discount Tables
I do not usually recommend editing Discount Tables unless it is to correct something you just accidentally added wrong in the table, & you know the table hasn't been used yet. Editing a table that has been used distorts your history. It doesn't change anything on a ticket that has been settled, but when you look at an old settlement & try to compare to the table, they will no longer match.
When your discount rates change, I recommend entering a new table with the same table code but with a new effective date. This method allows you to see what the table looked like before the change & then any new tickets entered from the effective date forward will use the newer table. This also saves time in having to update the default tables, if you use the same table code.
If you do need to edit a table, the process is very similar to entering new. You again have the choice of Add/Edit One Grade or you can do ranges with Multiple Grades using the same methodology as step 11 above.
Updating Default Discount Tables
After you have all of the Discount Tables built for all the factors assigned to the Commodity Codes, you will want to update the Default Discount Tables. This ensures that the correct tables are used when you write a new contract or apply tickets. Here are the steps needed.
Grain > Commodity Tables > Discount Tables > #5 Default Discount Tables
Enter the Commodity & Location needed.
Next you will see a grid of all the Application Types possible. This includes system default types like Open Storage, Delayed Price (referred to often as little dp), Grain Bank, Warehouse Receipt, Hold, Transfers & Client Loadouts. It also includes an In & Out Application Type for each of the Contract Types you have in your dataset.
You can highlight & select any application type individually, or if you hit Select All, it will cycle you through each Application Type, 1 at a time, allowing you to update & save each type.
As you enter through each Application Type, you do not have to use the same Discount Table Code for each type. This gives you the flexibility to have different tables, with different rates, for different Application Types. A common example is sometimes Moisture discounts will be tougher on grain applied to Open Storage than grain applied to a Priced Contract. And you may have different tables from Inbound tickets vs Outbound tickets.
As you complete a page for an Application Type & click OK to save, system will ask Do You Want These Changes To Affect All Locations? By answering Yes the tables you added will update the defaults for all locations that have the same Commodity Code setup. Note*** If you answer Yes to all Locations & your Discount Tables are setup by Location & you've not actually entered a Discount Table with the Table Code for a Location, the system will not know what to do. You will still get a popup message when applying tickets of Discount Table Not Found. The system will allow you to enter a Discount Table Code even if that table doesn't exist. So be aware of what the valid tables are for each location when updating these default tables.
Exporting & Importing of Discount Tables & Default Tables
Agris does provide the ability to export Discount Tables into a spreadsheet, make any changes needed & re-import them back in. Same with Default Tables.
We will not cover that in this document, but wanted to make users aware this option does exist. It's done through Advanced Reports. I recommend contacting Customer Support for further info on doing this process. Depending on our involvement in the process this could be a billable action. Examples of Discount Scales we will build:
Corn TW Discounts
54 or above .00 cents
53.9 - 53.0 .01 cents
52.9 - 52.0 .02 cents
51.9 - 51.0 .03 cents
50.9 - 50.0 .04 cents
49.9 - 49.0 .05 cents
48.9 - 48.0 .06 cents
47.9 - 47.0 .08 cents
46.9 - 46.0 .10 cents
45.9 - 45.0 .12 cents
44.9 - 44.0 .14 cents
43.9 - 43.0 .16 cents
42.9 - 42.0 .18 cents
41.9 - 41.0 .20 cents
Corn Moisture Discounts – Shrink
15.5 or below 0%
15.6 - 16.0 1.50%
16.1 - 16.5 3.00%
16.6 - 17.0 4.50%
17.1 - 17.5 6.00%
17.6 - 18.0 7.50%
18.1 - 18.5 9.00%
18.6 - 19.0 11.00%
19.1 - 19.5 13.00%
19.6 - 20.0 15.00%
Wheat Dockage
100% Dockage deducted from gross weight
Wheat TW Discounts
58# or above .00 cents
57.9 - 57.5 .08 cents
57.4 - 57.0 .12 cents
56.9 - 56.5 .16 cents
56.4 - 56.0 .20 cents
55.9 - 55.5 .24 cents
55.4 - 55.0 .28 cents
54.9 - 54.5 .32 cents
54.4 - 54.0 .36 cents
53.9 - 53.5 .46 cents
53.4 - 53.0 .56 cents
52.9 - 52.5 .66 cents
52.4 - 52.0 .76 cents
51.9 - 51.5 .86 cents
Corn Moisture Discounts – Money
15.5 or below .00 cents
15.6 - 16.0 .02 cents
16.1 - 16.5 .04 cents
16.6 - 17.0 .06 cents
17.1 - 17.5 .08 cents
17.6 - 18.0 .11 cents
18.1 - 18.5 .14 cents
18.6 - 19.0 .17 cents
19.1 - 19.5 .20 cents
19.6 - 20.0 .23 cents
Musty
Flat .10/bushel any load with musty odor
~Document written by Arlena Bannon
