Commodity Freight

Add/Edit Freight Rates

The first screen in the Add/Edit Freight Tables series is the Customer Name ID screen. Freight tables are established and maintained for specific customers. The Customer Name ID field identifies the specific customer for this freight rate.
Image Added
The second screen in the Add/Edit Freight Rates series is divided into two sections. The upper section displays the name id description (account name) from NAM for verification of the selection. The lower section contains input fields to limit the freight rate. Freight rates are based on specific commodities for specific customers.
Image Added
The Location Code field identifies the specific accounting location where the commodity is maintained. To limit this freight rate to a specific location. This field may be left blank to include all locations.
Image Added
The Storage Facility input field identifies a specific storage facility, as specified in the AGRIS Storage Management System (BIN). To limit this freight rate for this customer and commodity to a specific storage facility, type a valid storage facility in the space provided. This field may also be left blank to include all storage facilities. Note: This field will not appear if the integration to the Storage Management System is turned off.
The Shipper Name ID field identifies a specific freight handler or shipper. If known, type the name ID of the shipper in the space provided. If unknown, press [Enter] to activate the alpha-search feature to locate or add a valid shipper. Note: a Shipper Name Id is not required.
Image Added
Type the number of cents per unit of measure (bushels in the example) to charge the customer for freight the Freight Rate field. Type the amount in whole cents in the format where 15.00000 equals 15 cents.
Type the amount in dollars in the format where 1.25 equals $1.25 in the Additional Freight field.
The amounts in these two input fields are displayed during the Freight/Misc. information section in Ticket Entry. These amount may be overridden, if necessary.
Image Added
If the freight rate does not exist, the message "You are adding this freight rate" is displayed at the bottom of the screen. If the freight rate already exists, then a message "You are editing this freight rate" is displayed.
Below is an example of the same table but without a Shipper Name Id.
Image Added
Below is an example of the first Rate Table for Webinar, delivering CN to Location 003 and Shipper Name Id of APACHE.
Image Added
Below is an example of the second Rate Table for Webinar, delivering CN to Location 003 without a Shipper Name Id.
Image Added

Below is an example of editing ticket 568 after entry. It does not matter which option is used in Editing the Ticket. Adding Apache as the Shipper Id does not update the freight rate assigned to the ticket.
Image Added
The tables work the same if maintained on the oneWeigh machines. Note: The File where the Freight Rate are maintained, HAULRATE, are not part of the DRS process. Updates can be passed to oneWeigh by copying the file or by the use of DTR.
Image Added

Anchor
_Toc19704411 _Toc19704411

Setup and use of FC (Freight Charge) for Freight Expense

This section is based on several recent support cases. In one instance the customer wanted to setup Discount Tables for FC (Freight Charge) so that they could pass freight charges at the ticket level to their Producers based on rates specified in their Contracts. In the other instance the Customer wanted their Scale Operators to be the ones that designated if the Freight was to be charged to the Customer.
In the first instance, where the contract was to dictate the freight charge, the solution for making this work requires that FC is one of the Flat Rate Discount Codes on the Commodity Code. You also want to make sure that there is not a default table that prohibits the contract freight tables from working. The FC Table on the Commodity Code Governs.
Image Added
In the second instance, where the scale operators were going to set the response the default is not an issue as it can be overridden at the scales.
Image Added
Setup of FC Tables: Below is an example of the setup of the Standard Type 4 Table where the Freight Expense is charged to the Customer.
Image Added
Image Added
Example of a Contract with the above Y table set to charge the customer the freight expense.
Image Added
Example of a ticket applied to this contract. Timing is important on this type of a table. Below is an example of the Freight Miscellaneous screen of the ticket prior to application. In this case there is a Shipper Name Id and Freight Expense.
Image Added
Example of Contract Application.
Image Added
Below is an example of a FC Table setup to set the freight expense and charge to the customer from the Contract.
Image Added

Example of Contract with both a Freight Rate and the FC Table.

...

Image Added
Example of ticket applied to the above Contract. Note that no freight rate was entered on the Freight Miscellaneous screen.
Image Added
At time of applying the ticket to the contract the freight, based on the freight charge table, is updated as both a charge to the customer and a freight expense on the ticket.
Image Added
Below is the Freight Miscellaneous screen of the ticket after application to the contract.
Image Added
Some things to be aware of when considering this approach to charging freight to the Customer.
All discount calculations (and possibly overriding) happens at the time of the application or if you specifically say to re-calculate.
If the freight gets entered later (or adjusted later) – then it is not an automatic thing to re-calculate.
The system doesn't know that you might have already communicated the final ticket info to the customer (or delivery sheet, etc. with the freight charge on it)
The ticket might already been settled by the time you put in or adjust the freight expense.
Typically – an estimated freight is added on the ticket (manually entered or pulled from the Contract as in this example) – in order to charge back to the customer. And then the actual could be entered later (resulting in a gain or loss on the pass-back to the customer)
The option is not intended to be an exact dollar-for-dollar when the final freight expense is entered.
The way we customarily suggest would be to always use option 2 that would be the Estimated Freight entered on the contract.
And as long as that is always a little higher than the actual freight – there will typically be a gain on the pass-back of the freight to the customer.

~Document Written by Phil Lehnhausen