What/How it runs
cron monthly 1st day of month at 6:45AM
/lawson/law/prod/usrscripts/foodchrg.pl
have to direct to correct output file in cmd
     /lawson/law/prod/usrscripts/foodcharge.pl > /lawson/law/prod/work/foodchrg/foodchrg.csv


Parent process
GemPay2008 server produces a file /ImportExport/FoodChrg.txt on first day of month around 5:45AM
MoveIt GemPay monthly dept food charges
       moves the file to Lawson /lawson/law/prod/work/foodchrg/FoodChrg.txt at 6:00-6:30AM on 1st day of month
       also archives it into foodchg_files dir on GemPay2008 server
Kronos WIM, GemPayDeptCharge.KNI (GemPayDeptCharges.KNX, sendamailGemPayDeptCharges.bat) runs 1st day of each month at 6:40AM
       pulls totals from GemPay dbase and emails to finance and LawCallGroup to balance


Child process
Finance manually runs GL165s to balance and then process


Input system/files
input file is from moveit /lawson/law/prod/work/foodchrg/FoodChrg.txt
then output file which is what is loaded into dbase gltransrel table is specified in cmd parm /lawson/law/prod/work/foodchrg/foodchrg.csv
/lawson/law/prod/usrscripts/foodchrg.pl > /lawson/law/prod/work/foodchrg/foodchrg.csv 2> /tmp/foodchrg.err


Output system/files
specified in cmd parm /lawson/law/prod/work/foodchrg/foodchrg.csv
deletes input file /lawson/law/prod/work/foodchrg/FoodChrg.txt


Automation
emails LawCallGroup, Lori McMullan and Kristie Holland


Hard Coding
tons of account numbers, dept nums, and descriptions at the top
emails addresses Lori McMullan and Kristie Holland at the bottom


Contacts
Jonas Bull who doesn't work here anymore, so Ruth
Lawson Team


DOWNTIME
run manually after GemPay produces file on 1st at 5:45AM. (but you have to run the moveit first)
can run later or days later(used to run on 3rd)
do NOT run multiple times as it loads records into gltransrel


notes:
finally got it to work without all the hard coding - and corrected the importdb path!
my $path="/lawson/law/prod/work/foodchrg/"'
my $importcmd="su - lawson -c importdb -ad prod gltransrel /lawson/law/prod/work
   /foodchrg.csv";