Invoice History and Sales Analysis Files

[Chris Kelleher]

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

 

[Chris Kelleher]

Brian,
Your user's are far ahead of time. 59 days more for the clock to change. Take it
easy. "Every road has an end".

When an Invoice is posted Sales Analysis tables are updated with the effective
date specified when posting the invoice.

The steps below should help:
1. First check that the shipment transaction effective date (3.21.13) is
October.
2. If the effective date in step 1 is correct, then write a simple Progress
program
to display the fields
[ih_ord_date, ih_inv_date, ih_ship_date]
for the particular Invoice number or Sale Order number; the date
ih_ord_date should display a date in 2009.
3. Once you confirm this, modify your program to assign ih_ord_date to the
actual date in October

"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."

You are right. Not just that alone, the transaction is sent to the GL, but
cannot be posted using 25.13.7. "Very close to the end of the road and turns you
back" This is not "tight coding".

Well QAD???

Bankole

 

[Chris Kelleher]

Bankole,

Your suggestion to change the ih_hist and idh_hist is what I had planned to
do when I realized that the utility rebuild function would not work
correctly if I did not take the approach of modifying the records directly
in Progress. Nice to see that someone agrees with me that it is odd to
allow half of the transaction to be check and validated against the G/L
calendar and ignore the second half (the invoice date). I'm a bit
surprised that no one from QAD responded with an explanation of why the
modules were written the way they are !

Thanks for your response.

Brian