Grain Freight

Overview

Adding Grain Freight charges on multiple Grain documents and reconciling using the Reconcile Grain Freight utility.

Setup

Add Freight on Scale Tickets

At Grain / Operations / Scale Tickets, add or edit a Scale Ticket.  Double-click in the Freight Vendor field and select the Vendor. Select the Charges button. On the Freight Charges window, select the Add Charge button. Edit the quantity and rate. Select Apply.

Add Freight on a Shipment

At Grain / Operations / Shipments, add or edit a Shipment. Double-click in the Freight Vendor field and select the vendor. Select the Charges button. On the Freight Charges window, select the Add Charge button. Edit the quantity and rate. Select Apply.

Add Freight on a Commodity Transfer

At Grain / Operations / Commodity Transfers, add or edit a Commodity Transfer.  Double-click in the Freight Vendor field and select the vendor. Select the Charges button. On the Freight Charges window, select the Add Charge button. Edit the quantity and rate. Select Apply.

Add Freight on a Grain Bank Shipment

At Grain / Operations / Grain Bank Shipment, add or edit a Commodity Transfer.  Double-click in the Freight Vendor field and select the vendor. Select the Charges button. On the Freight Charges window, select the Add Charge button. Edit the quantity and rate. Select Apply.

Add Freight on the Scale Interface

At Grain / Operations / Agvance Grain Scale Interface / Operations / Scale Ticket, double-click in the Freight Vendor field and select the Vendor. Select the Charges button. On the Freight Charges window, select the Add Charge button. Edit the quantity and rate. Select Apply

At the Scale Interface, the Use Gross Units option is automatically checked.  If Net is desired, enter the quantity manually and uncheck the Use Gross Units option.

Reconcile Grain Freight

At Grain / Utilities / Reconcile Grain Freight, select the Vendor.  On the Grain Freight Reconciliation window, mark the check boxes in the grid to select the Source items to reconcile.  Verify the reconcile Actual $ are correct.  In the Post AP Bill for Freight Amount section, add the Invoice # and select Apply.

In the Filter - Include section, choose to set a variety of Source grid filters to simplify the reconciliation.  G/L Accounts populate in the grid as determined by the Filters section. 

With first time use of the Grain Freight Reconciliation, setup default accounts. (See the Grain Ledger GL Posting Accounts section of this document.)

Select Print to print the grid and then Post.

NOTE: 

  1. If the Source selection box is unchecked in error and the user checks it again, the Post AP Bill must also be checked again if wanting to create an AP Bill in Accounting. 
  2. To reconcile freight already paid through Accounting or entered in error, check the Source selection box and uncheck the Post AP Bill.  This reconciles the item without creating an AP Bill. 
  3. If, in error, a Source is reconciled without the Post AP Bill checked, a manual AP Bill can be created in Accounting.  A Source cannot be un-reconciled.

Grain Ledger GL Posting Accounts

At Grain / Setup / Grain Ledger GL Posting Accounts designate a default Grain Freight Account for each location.  Select a Location from the G/L Accounts for Location drop down list. Double-click the Grain Freight Account field and select an account from the Select a G/L Account window. Click Select. Click Save on the Grain Ledger G/L Posting Accounts window.  Repeat for additional locations as needed.

Reports

To run a report of all details of Freight Purchase paid accounts, at Grain / Grain Reports / Freight Purchases / Freight Reconciliation select Criteria. Choose a vendor by clicking Select in the Select Vendor field, select the Reconciled Date option and enter a Start Date and End Date.  Click OK.

The report can be sent with the AP Check to the vendor.

To run a report of freight accrual balances for month end journal entries, set Select Vendors, Select Commodity, and Select Location to All, select all dates, and set the Reconciled option to No. Click OK.