Grain Balance Detail Report

Overview

The Grain Balance Detail report provides a customer analysis of grain by contract and price. 

Setup

At Grain / Setup / Grain Ledger Accounts, establish the Grain Ledger Accounts for each Commodity per Location to display grain balances on the Grain Balance Detail report. The report pulls default prices from the Grain Ledger Accounts.

Running the Report

  1. At Grain / Grain Reports / Customer Analysis select Grain Balance Detail.
  2. Use the Select or Classifications buttons to choose specific customers or classifications of customers.
  3. In the Sort Contract By section, designate a Primary sort option from the drop-down list and optionally select a Secondary sort or Secondary defaults to None.
  4. In the Price Details section, select an option. Data is drawn from the prices on Grain Ledger account for commodities by location.
    1. No Price - Prices do not display.
    2. Gross Price – The non-priced commodity balances display.  Or, if priced and multiple prices are available, the average commodity price displays. 
    3. Discount Price –The price less the discount applied to the balance displays. Non-priced commodities do not display. 
    4. Current PriceEdit Current Prices by selecting the button. On the Grain Balance Detail Prices window, enter the commodity Current Prices in the grid.  Select Done.
  5. Print options include Print Customer Address, Print Detail and Exclude Closed Contracts.  With the Print Detail option, source details are included for each of the inventoried balances on the report.
  6. Choose to Print or Preview. Select OK.