...
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.
...
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 today's sessionthis 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