âConnect. Innovate. Thrive. â
EDGE Grain Customer Portal – Lab Wednesday
2016 31st Annual National Conference & User Exchange
“Connect. Innovate. Thrive. “
AgVantage Software, Inc.
1
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
EXERCISE 1 – Add a new Purchase Contract Burt Baker wants to sell on a contract 5,000 bushels of #2 Yellow Corn for June 2016 delivered to Byron, MN. Today’s posted cash price is $3.70. The Basis is $ ‐ .25 with a Futures Price = $3.95 vs July 2016 CBOT. a)
Click New Control COMMENT BOX
to make a new Contract with the above information. Enter the description for the delivery period – JUNE 2016
COMMENTS TAB
Add special text under Contract Information.
Your Grain Department Manager wants to offer a premium to your customer if they defer payment until January 2017. Enter this sentence: ‘Grain is eligible for a $.04 per bushel premium if Deferred Payment until Jan 3, 2017.’
Click Save & Print
when complete.
For this training lab, all documents will be viewed as Adobe PDF. Use Print Spool to find the contract named File = U5PCR5. Click the magnifier glass
to create the report as PDF.
AgVantage Software, Inc.
2
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
EXERCISE 2 – Edit the existing Purchase Contract The contract was supposed to be for July 2016, not June 2016. The price will be different, also.
Click Action – View/Edit
to change these values:
To
JUNE 2016
JULY 2016
Delivery Begin Date
06/01/16
07/01/16
Delivery End Date
06/30/16
07/31/16
Basis
$ ‐ .25
$ ‐ .20
Contract Price
$3.70
$3.75
Comment
From
Use Print Spool to look at the reprinted contract named File = U5PCR5.
EXERCISE 3 – Add Immediate Settlement Burt Baker wants to sell Soybeans from Open Storage at today’s Cash Price = $10.00. Burt doesn’t know the exact bushels – just that the loads were on the WEST 40 FIELD 2. He knows that information was written somewhere on the scale ticket. a)
Use Open Loads to review loads on control
Click Action – Open Loads Report b) Add Immediate Settlement
Click Action – Settle Grain
to see if any loads have this detail.
.
Use Settlement location = Byron and Price = $10.00. Click Continue button to select loads. Check the two loads with the Reference number WEST 40 FIELD 2. Click Continue
AgVantage Software, Inc.
3
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
Burt says your Grain Department Manager wasn’t going to charge any hauling on those loads. c)
Refund Hauling Charges as a G/L Adjustments Type the Hauling deduction as a positive value in Amount. Enter the Description = Refund Hauling. Select the G/L account Hauling Expense – Location 2.
d) Add Another Payee He also needs one check written to Commodity Credit Corp for $10,000.00 – he gets the rest (kind of). Click
to insert another payee.
Search for the CCC customer account and insert $10,000.00 in Amount box only. Click Save Payee
e) Payment amount does not match amount of Checks to be written There is a message that the payment amount is invalid.
Use the Action
to correct Burt’s amount, then Click Save Payee
When ready, use Complete Immediate
.
button to write the checks.
f)
WRITE CHECKS & SETTLEMENT SHEET
Choose the Check Printer Location = Byron (Location 2), then Print Check Use Print Spool to find the checks named File = U5LSRCKOVL. Click on magnifier glass
to create the check as PDF.
Go back to ‘Did the checks print correctly?’ and click Send
to create the Settlement. Go back into Print Spool – refresh – and find the File = U5SER2. Click on magnifier glass
to create the settlement report as PDF.
AgVantage Software, Inc.
4
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
EXERCISE 4
Use Quick Settlements to add to today’s Batch of Settlement Payments
Burt called back – he would like payment for the grain he delivered but has not received the money. Use today’s date, and Settlement location = Byron (Location 2), to select all for Customer Burt Baker What was the price per bushel on the contracts to be submitted? to put controls into today’s Batch.
When ready, click Submit Settlements
EXERCISE 5
Process Settlement Payments
This option offers new flexibility to choose which Batched Settlements will be processed for payments as a Check, ACH, or Deferred Payment. a)
Process By User Profile
Choose Settlement user Choose Settlement Date
Click drop‐down by User – EDGEA, etc. blank – all dates
Click List Settlements Click Submit OR b) Process By Settlement Location Choose Settlement Date Settlement Locations Choose Settlement Location
Select only the Batched settlements for Burt Baker
blank – all dates Uncheck All Check Byron (location 2)
Click List Settlements
Select only the Batched settlements for Burt Baker
Click Submit
c)
WRITE CHECKS AND SETTLEMENT SHEETS
When ready, click Submit button to continue Process Settlement Payments Choose the Check Printer Location = Byron (Location 2), then Print Check
Use Print Spool to find the checks named File = U5LSRCKOVL. Click on magnifier glass
to create the check as PDF.
Go back to ‘Did the checks print correctly?’ and click Send to create the Settlement Go back into Print Spool – refresh – and find the File = U5SER2. Click on magnifier glass AgVantage Software, Inc.
to create the settlement report as PDF.
5
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
2016 31st Annual National Conference & User Exchange
“Connect. Innovate. Thrive. “
AgVantage Software, Inc.
1
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
EXERCISE 1 – Add a new Purchase Contract Burt Baker wants to sell on a contract 5,000 bushels of #2 Yellow Corn for June 2016 delivered to Byron, MN. Today’s posted cash price is $3.70. The Basis is $ ‐ .25 with a Futures Price = $3.95 vs July 2016 CBOT. a)
Click New Control COMMENT BOX
to make a new Contract with the above information. Enter the description for the delivery period – JUNE 2016
COMMENTS TAB
Add special text under Contract Information.
Your Grain Department Manager wants to offer a premium to your customer if they defer payment until January 2017. Enter this sentence: ‘Grain is eligible for a $.04 per bushel premium if Deferred Payment until Jan 3, 2017.’
Click Save & Print
when complete.
For this training lab, all documents will be viewed as Adobe PDF. Use Print Spool to find the contract named File = U5PCR5. Click the magnifier glass
to create the report as PDF.
AgVantage Software, Inc.
2
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
EXERCISE 2 – Edit the existing Purchase Contract The contract was supposed to be for July 2016, not June 2016. The price will be different, also.
Click Action – View/Edit
to change these values:
To
JUNE 2016
JULY 2016
Delivery Begin Date
06/01/16
07/01/16
Delivery End Date
06/30/16
07/31/16
Basis
$ ‐ .25
$ ‐ .20
Contract Price
$3.70
$3.75
Comment
From
Use Print Spool to look at the reprinted contract named File = U5PCR5.
EXERCISE 3 – Add Immediate Settlement Burt Baker wants to sell Soybeans from Open Storage at today’s Cash Price = $10.00. Burt doesn’t know the exact bushels – just that the loads were on the WEST 40 FIELD 2. He knows that information was written somewhere on the scale ticket. a)
Use Open Loads to review loads on control
Click Action – Open Loads Report b) Add Immediate Settlement
Click Action – Settle Grain
to see if any loads have this detail.
.
Use Settlement location = Byron and Price = $10.00. Click Continue button to select loads. Check the two loads with the Reference number WEST 40 FIELD 2. Click Continue
AgVantage Software, Inc.
3
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
Burt says your Grain Department Manager wasn’t going to charge any hauling on those loads. c)
Refund Hauling Charges as a G/L Adjustments Type the Hauling deduction as a positive value in Amount. Enter the Description = Refund Hauling. Select the G/L account Hauling Expense – Location 2.
d) Add Another Payee He also needs one check written to Commodity Credit Corp for $10,000.00 – he gets the rest (kind of). Click
to insert another payee.
Search for the CCC customer account and insert $10,000.00 in Amount box only. Click Save Payee
e) Payment amount does not match amount of Checks to be written There is a message that the payment amount is invalid.
Use the Action
to correct Burt’s amount, then Click Save Payee
When ready, use Complete Immediate
.
button to write the checks.
f)
WRITE CHECKS & SETTLEMENT SHEET
Choose the Check Printer Location = Byron (Location 2), then Print Check Use Print Spool to find the checks named File = U5LSRCKOVL. Click on magnifier glass
to create the check as PDF.
Go back to ‘Did the checks print correctly?’ and click Send
to create the Settlement. Go back into Print Spool – refresh – and find the File = U5SER2. Click on magnifier glass
to create the settlement report as PDF.
AgVantage Software, Inc.
4
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
EXERCISE 4
Use Quick Settlements to add to today’s Batch of Settlement Payments
Burt called back – he would like payment for the grain he delivered but has not received the money. Use today’s date, and Settlement location = Byron (Location 2), to select all for Customer Burt Baker What was the price per bushel on the contracts to be submitted? to put controls into today’s Batch.
When ready, click Submit Settlements
EXERCISE 5
Process Settlement Payments
This option offers new flexibility to choose which Batched Settlements will be processed for payments as a Check, ACH, or Deferred Payment. a)
Process By User Profile
Choose Settlement user Choose Settlement Date
Click drop‐down by User – EDGEA, etc. blank – all dates
Click List Settlements Click Submit OR b) Process By Settlement Location Choose Settlement Date Settlement Locations Choose Settlement Location
Select only the Batched settlements for Burt Baker
blank – all dates Uncheck All Check Byron (location 2)
Click List Settlements
Select only the Batched settlements for Burt Baker
Click Submit
c)
WRITE CHECKS AND SETTLEMENT SHEETS
When ready, click Submit button to continue Process Settlement Payments Choose the Check Printer Location = Byron (Location 2), then Print Check
Use Print Spool to find the checks named File = U5LSRCKOVL. Click on magnifier glass
to create the check as PDF.
Go back to ‘Did the checks print correctly?’ and click Send to create the Settlement Go back into Print Spool – refresh – and find the File = U5SER2. Click on magnifier glass AgVantage Software, Inc.
to create the settlement report as PDF.
5
UC 16 EDGE GRAIN Lab Exercises ‐ WED.docx
