Environment: MFG/PRO 8.5G, Progress 8.3B, Unix 10.20
Hello Peggers:
Help ! !
One of our users recently printed and posted an invoice in October 1999
with an invoice date in 2009 ! Although QAD did/does check at the point a
shipper is confirmed that the Effective Date of the transaction is within a
G/L period that is open - QAD does Not enforce this logic on the date you
select for the Invoice (Invoice Date). So what I currently have is an
invoice that hit our G/L in October 1999, but has an Invoice Date in 2009.
When I look at the Sales Analysis Tables, I am confused as to which date
the system uses when it is writing these tables. Does anyone know what
date QAD uses when writing information to the 4 sales analysis tables
[pth_hist, cph_hist, sph_hist, cmh_hist]? [The effective date of the
invoice or the invoice date]?
If it is in fact the effective date of the transaction, then what happens
when the sales analysis rebuild utility (utsabild.p) is run to re-create
these tables from invoice history and the effective date of the invoice is
Not stored in the ih_hist and idh_hist tables (as far as I can tell)?
Am I just confused or what? Also curious is anyone else see this as an
issue that QAD allows an invoice date to be used for a period that is not
open even though the effective date can be in another period.
TIA
Brian
Hello Peggers:
Help ! !
One of our users recently printed and posted an invoice in October 1999
with an invoice date in 2009 ! Although QAD did/does check at the point a
shipper is confirmed that the Effective Date of the transaction is within a
G/L period that is open - QAD does Not enforce this logic on the date you
select for the Invoice (Invoice Date). So what I currently have is an
invoice that hit our G/L in October 1999, but has an Invoice Date in 2009.
When I look at the Sales Analysis Tables, I am confused as to which date
the system uses when it is writing these tables. Does anyone know what
date QAD uses when writing information to the 4 sales analysis tables
[pth_hist, cph_hist, sph_hist, cmh_hist]? [The effective date of the
invoice or the invoice date]?
If it is in fact the effective date of the transaction, then what happens
when the sales analysis rebuild utility (utsabild.p) is run to re-create
these tables from invoice history and the effective date of the invoice is
Not stored in the ih_hist and idh_hist tables (as far as I can tell)?
Am I just confused or what? Also curious is anyone else see this as an
issue that QAD allows an invoice date to be used for a period that is not
open even though the effective date can be in another period.
TIA
Brian