OIS180/OIS196 Reset and Re-trigger Invoice update to Finance

Modified on Fri, 6 Nov, 2020 at 10:47 AM

When a OIS196 / OIS180 job was deleted from GLS037 erroneous jobs so invoices needed to be retriggered to be transferred again. Below are the SQL statements used to reset invoicing file status so that OIS196 could be re-run and update AR & GL.

select * from mvxcdtpro.oinvoh
where uhcono = 8
and uhdivi = '099'
and uhivno between '120002980'and '120002995'

select * from mvxcdtpro.oinacc
where utcono = 8
and utdivi = '099'
and utcino between '120002980'and '120002995'


update mvxcdtpro.oinvoh
set uhinst = 90
where uhcono = 8
and uhdivi = '099'
and uhivno between '120002980'and '120002995'
and uhinst = 95


update mvxcdtpro.oinacc
set utinst = 10
where utcono = 8
and utdivi = '099'
and utcino between '120002980'and '120002995'
and utinst = 80