Grain Live and Sales Live

1. Grain Live and Sales Live including End of Month Reporting Multiple Customer Invoicing and Price Levels from Accounts Receivable

2. Grain & Sales Live • Grain Bank from Counter Invoicing • Local Sales from Counter Invoicing • Invoicing from another Customer’s Grain Bank Control • Sales Controls apply from Counter Invoicing local sales • Sales Controls using price levels • Copy Grain Files for End of Month Reporting

3. Grain Live ON • Creates Grain Bank out-loads to Purchase Control from A/R invoice. • Creates position transactions to DPR when grain product is sold. • Grain related products updates the corresponding crop at the time the invoice prints verses waiting for an A/R merge.

4. Grain Live PRIOR TO SETUP • Create all Interface batches in A/R and merge. SETUP • U4MEN9-OPTION 15 Activate Optional Features • Invoice Entry: • Optional: Only show contracts in date range Y/N • This also applies to Prepays and Booking • Work Orders: • Optional: Workorders-update inventory Y/N • This affects all inventory • Grain: • Update Grain live during A/R Invoicing? Y/N • Optional: Override unit price on Grain local sale Y/N • A/R setup required for price levels

5. Grain Live • You may want to change ‘Allow overdraw of Grain Bank = N’ in U5MNST-OPTION 1. Constants Information.

6. Processing Grain Bank & Local Sales Transactions • The following example shows • Invoicing a customer’s grain bank • Charging the balance as a local sale. • Create PC 40 = Grain Bank • U5MNPU-1. Purchase Contract / Control Info. Maintenance • auto-apply = ‘Y’

7. Processing Grain Bank & Local Sales Transactions Auto Apply flag set to ‘Y’

8. Processing Grain Bank & Local Sales Transactions • Invoice item in A/R Counter Invoicing and Work Orders/Feed

9. Processing Grain Bank & Local Sales Transactions Invoice of 2000#, apply 1000# to GB Control 188 • Select Purchase Control F12 Cancel to charge balance as a local sale or select control again to overdraw grain bank if allowed.

10. Processing Grain Bank & Local Sales Transactions 1000# balance - F12 & Invoice as a local sale item

11. Processing Grain Bank & Local Sales Transactions • Change item number to local sale item.

12. Processing Grain Bank & Local Sales Transactions • Item displays and ‘G’ Code

13. Affects to Grain • Purchase Controls received units are reduced

14. Affects to Grain • Daily Position Transactions

15. Grain Bank Open Loads Reports • Grain Management – Open Loads Grain Bank Control U5MNMG - Grain Management Menu - 1. Customer Information

16. Grain Bank Out Load from Open Loads

17. Share Grain Bank Controls • Invoicing using Multi-Customer: • This feature allows the invoicing customer to use the primary customer’s grain bank control. See A/R Multi-Customer document. • Customer (A) is the invoicing customer • Customer (B) is the primary customer • From this Grain Bank Application Screen below my options are: • A –Select invoicing customer’s zero balance grain bank control causing the control balance to go negative • B –Select the primary customers control • Or • F12 cancel out of Grain Bank Application Screen and charge as a local sale item at retail price.

18. Share Grain Bank Controls • Counter Application Screen

19. Share Controls/Contracts Setup • Applies to Grain Bank Controls & Sales Live • U4MEN9-26 (also used for Prepay & Bookings)

20. Share Controls/Contracts Setup • Setup Screen

21. Share Controls/Contracts Setup • Add a share

22. Sales Live • Updates the Sales Contract units from A/R Invoice and uses the contract price. • A/R creates position transactions to DPR when grain product is sold. • No booking contract is required for pricing. • A/R updates grain once the invoice is printed, not waiting for an A/R merge.

23. Prior to Sales Live Setup • PRIOR TO SETUP: • Create all Interface batches in A/R and merge. • Update applied bushels with current booking balances. • U4MEN5-OPTION 12- Remove a Selected Customer’s booking that match Grain Sales Contracts.

24. Sales Live Setup SETUP • U4MEN9- OPTION 15 Activate Optional Features • Accounts Receivable • Invoice Entry: • Only show contracts in date range . . . Y • Grain: • Update Grain live during A/R Invoicing? . Y

25. Processing Sales Live • Sales Contract – U5MNSL option 1

26. Processing Sales Live • The Sales Contract acts the same as Bookings and Prepay transactions.

27. Processing Sales Live • The Sales Contract acts the same as Bookings and Prepay transactions.

28. Processing Sales Live Item displays and ‘S’ Code

29. Updates the contracted units by 1000 from an entry to a local sale item Affects to Grain

30. Affects to Grain • Daily Position Transactions Position Year Units Reference • 10 1000.00- LOC SALE • 230 1000.00- LOC SALE • 410 2009 1000.00- LOC SALE

31. Sales Reports • 4. Control Balances with Shipment Detail

32. Sales Reports • 8. Contracts by Delivery Date

33. Grain Bank, Local Sales & Sales Live • A/R updates Grain when the invoice is printed. • Changes, deleted grain items and deleted invoices will change Grain once the invoice is reprinted or deleted. • The date on you A/R invoice is the date of the grain bank load and position adjustments. • Recommendations: No reopening an A/R Batch that’s been merged. Delete A/R invoices and batches using the menu options only. No back dating of invoices after Grain runs Captured Files option.

34. Multi Customers Accounts • Grain Bank has the ability to use the primary account’s Grain Bank Control. • The Grain Bank selection screen will display when the balance is zero allowing you to decide how to handle the remaining balance. • Local Sales has the ability to use the primary account’s Sales Contract. • You will not be allowed to overdraw a Sales Contract. The balance will go out with the current retail price on the item.

35. End Of Month Reporting STOP THE TRAIN!!!

36. End Of MonthCapture • Allows entry of daily activity for new month to continue even though EOM reports have not been run. • Minimizes EOM down time between entering EOM prices, reports and next month’s activity

37. End Of MonthCapture • Captures different files in COxYYYYMM library

38. End Of MonthCapture • Copies data for the month & year selected: • Purchase • Loads • Contract • Settlements • Pricings • Advances • Co Transfers • Sales • Contracts • Shipments

39. End Of MonthCapture • Things to AVOID doing in the new month until files have been captured: • Change & Delete Loads • Transfers between customers • Reshrink on a control • Update Discounts • Split Transfers • Lot Maintenance • Deferred Payment Checks • Averaging • Accrued Storage • Sales settlements

40. End Of MonthCapture Commonly used reports available from Captured Files • Contracts to Market valuation – Cash Price or Basis • Purchase Control reports by Control, Customer Name, Crop, Loc • Purchase & Sales Contract Delivery Reports Priced, Unpriced, Pricing detail w/Weighted Average • Purchase & Sales Contract Pricing by Customer • Purchase & Sales Advances • Shipments Intransit • Sales Control Current Balances • Sales Control Balances with Shipment Detail

41. End Of MonthCapture • Merge A/R Invoices with Grain Transactions • Local Sales and Grain Bank withdrawals • Complete Grain Activities • Inbound Purchases • Outbound Sales • Management • Grain charges to AR • Storage, drying, etc • Grain End of Day • Run AR Statements & Sales Reports • Maintain Board of Trade Prices using current files • Capture Files • Run grain reports

42. Questions Let’s Talk! Check our On-lineTraining at www.agvantage.com

43. Grain Live Thanks for Attending