Tying Agvance Inventory Item to Grain Commodity

Overview

If you sell grain to farmers (like for feed or seed), a commodity must be set up in an Accounting non-inventoried department. If multiple locations store and sell the commodity as feed or seed, a commodity must be setup once for each location / commodity.

Setup

Tying an Inventory Item from Accounting

Inventory Units can be anything, but Unit Weight is critical information.

Commodity units in Agvance Grain are in Bu.  The Unit Weight is used to convey the quantity and/or adjustment to the DPR.

Select the commodity/location to tie this product to.  A commodity/location can be tied to multiple products.  

This account below should be the same as the sales account for the commodity/location in Grain.  The account can be found at Grain/Setup/Grain Ledger Accounts.

With the Agvance Inventory item ‘Corn’ tied to the Grain commodity, an invoice for Corn from Agvance Accounting will adjusts the grain inventory and DPR correctly.

Tying an Inventory Item from Grain

Select the product to tie to the commodity/location.  This setup is only used when creating an invoice from a shipment.

Grain Screenings or Feed ‘Manufactured’ for Sale

Use manufactured inventory, invoice or blend to stock to do this. With raw ingredient setup in Accounting Inventory, create the Finished Good. This finished product may (or may not) be inventoried depending on if they truly inventory it or not.

Invoicing the feed or manufacturing through manufacture inventory or blend to stock will correctly affect the DPR inventory of corn if tied to the commodity.

The unit cost will be used to create a journal entry to move the cost of Corn to the Custom Mix--Beef.