Accpac version 6.1.
When getting sales total from sales statistics: SELECT SUM(INVAMTF)FROM OESTATS
When getting Invoice Totals from invoice total: SELECT SUM(INVITMTOT+INVETAXTOT+INVMISC)FROM OEINVH
I got major variance from the 2 queries.
At what point does OESTATS gets updated?
Thanks
When getting sales total from sales statistics: SELECT SUM(INVAMTF)FROM OESTATS
When getting Invoice Totals from invoice total: SELECT SUM(INVITMTOT+INVETAXTOT+INVMISC)FROM OEINVH
I got major variance from the 2 queries.
At what point does OESTATS gets updated?
Thanks