<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Good Morning!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I had twelve districts respond with helpdesk tickets. So, I decided to respond to all. Here are some possible short cuts for Classic software users.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Attached is a spreadsheet template for adding vendors using USALOAD/VENLOAD. Users must have group manager privileges to execute this program. You can hover over the column header on the VENLOAD spreadsheet to see the comment with the
valid responses. If you already have a spreadsheet with the vendor information, just change the headers on your existing spreadsheet and add any field that is missing. You may get this information from the building or department staff. If you don’t have
the vendor information in spreadsheet format, you can enter it on the attached spreadsheet and use the Excel functions to fill down to increment the vendor number. Save the spreadsheet as a csv and use the file transfer (flying paper) to transfer it to the
host. Go to USALOAD and select VENLOAD. <o:p></o:p></p>
<p class="MsoNormal"> <img width="696" height="217" style="width:7.25in;height:2.2604in" id="Picture_x0020_1" src="cid:image003.jpg@01D61306.92A5F6D0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Run VENLOAD as a Report first to check for any errors. If you don’t have errors, run the Update option. If there was a partial import, create a new spreadsheet with the corrections needed.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The AUTOPOST_OTHER template is also attached. There is a worksheet for Refund of Receipt with the needed column headers. If you are using a point-of-sale software, you may be able to get a report in csv format with the needed fields.
Change the column headers and test it using AUTOPOST/OTHER. <b>The leading zeros are required for the account codes!</b> <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Another option to finding the receipts that need to be refunded is to query receipts using Safari ODBC and filter by a specific description or receipt account code to get a listing. Use the filtered spreadsheet to create the refund. Use
the fill down function in Excel to complete the refund load sheet. You may only need to manually enter the amount and vendor number.
<b>The leading zeros are required for the account codes!</b> Save a working spreadsheet as xlxs and then save the spreadsheet as a csv. Once you have a spreadsheet with the column headers, transfer it to the host. Execute AUTOPOST OTHER option.
<o:p></o:p></p>
<p class="MsoNormal"><img width="741" height="452" style="width:7.7187in;height:4.7083in" id="Picture_x0020_2" src="cid:image004.png@01D61301.C319A0A0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Like other AUTOPOST options, go down to the Files to process prompt and hit F7 to see the list of files available for import. You may see transaction numbers auto-populated on the option page. Remove those numbers since the transaction
numbers are on your spreadsheet. You can change the posting date and allow negative balances, if needed. Run it as a Validate first. Make any corrections on your xlxs spreadsheet and then save as csv. Once you resolve any errors, run AUTOPOST as Actual.
View AUTOPOST_OTHER.TXT to confirm the correct totals.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please respond to this email if you want a demo to test the spreadsheet loads.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you to Miami Trace, Blanchester and Yellow Springs for explaining your process. I found that receipts for student activities are posted many different ways.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I hope this helps and please send me any feedback. Particularly, if you have a better solution!!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Deb Dinnen<o:p></o:p></p>
<p class="MsoNormal">937-767-1468 x3113<o:p></o:p></p>
<p class="MsoNormal">MVECA<o:p></o:p></p>
<p class="MsoNormal">330 E Enon Rd<o:p></o:p></p>
<p class="MsoNormal">Yellow Springs, OH 45387<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>