cron.scripts/fifo.daily.sh

diff --git a/cron.scripts/fifo.daily.sh b/cron.scripts/fifo.daily.sh
index af7d891..34aa022 100755 (executable)
--- a/cron.scripts/fifo.daily.sh
+++ b/cron.scripts/fifo.daily.sh
@@ -10,11 +10,11 @@ echo "Database prefix  = $4"
 
 
 /usr/bin/php ${1}${2}.php Xtuple/Fifo/ProcessValues --send-to ${3} >> /tmp/fifovalues.${USER}.${2}
-/usr/bin/psql -Uadmin xtuple${2} -c 'select invfifo_hourly()' >> /tmp/fifovalues.${USER}.${2}
-/usr/bin/psql -Uadmin xtuple${2} -c "SELECT invfifo_apply_gl_adjust_all();" >> /tmp/fifovalues.${USER}.${2}
-/usr/bin/psql -Uadmin xtuple${2} -c 'SELECT invfifo_apply_gl_cmhead_all(); ' >> /tmp/fifovalues.${USER}.${2}
-/usr/bin/psql -Uadmin xtuple${2} -c 'SELECT invfifo_apply_gl_invchead_all();' >> /tmp/fifovalues.${USER}.${2}
-/usr/bin/psql -Uadmin xtuple${2} -c 'SELECT invfifo_apply_gl_cohead_all();' >> /tmp/fifovalues.${USER}.${2}
+/usr/bin/psql -Uadmin ${4}${2} -c 'select invfifo_hourly()' >> /tmp/fifovalues.${USER}.${2}
+/usr/bin/psql -Uadmin ${4}${2} -c "SELECT invfifo_apply_gl_adjust_all();" >> /tmp/fifovalues.${USER}.${2}
+/usr/bin/psql -Uadmin ${4}${2} -c 'SELECT invfifo_apply_gl_cmhead_all(); ' >> /tmp/fifovalues.${USER}.${2}
+/usr/bin/psql -Uadmin ${4}${2} -c 'SELECT invfifo_apply_gl_invchead_all();' >> /tmp/fifovalues.${USER}.${2}
+/usr/bin/psql -Uadmin ${4}${2} -c 'SELECT invfifo_apply_gl_cohead_all();' >> /tmp/fifovalues.${USER}.${2}
 
 
 #report current situation to..