DaveBarber
Active Member
This post is a repeat of one I sent earlier which I am not sure has been processed.
My problem is with the invoice print R42565. I am on a new site which has recently archived all its sales orders for the first time to F42019/F42119.
The invoice print is now failing to reprint any invoices that are not in the sales files F4201/F4211. This seems odd as I always thought that the Invoice print worked on reprint even if the sales were archived. There is a comment in the Detail line one do section as follows:
// This section has (left outer) joint view between F42565 and F4201. So, evenif
// the F4201 records are purged to F42019, the records from F42565 are fetched
// and processed and the F42019 fields are fetched using the Table I/O and
// populated as if they are fetched from F4201 by the business view when the
// Order Number of F4201 is zero. SAR # 1272729
I have 2 questions with this:
1) The business view V42565A actually is a left outer join between F4201 and F42565 (not the other way round as per the the JDE comment) so how does this retreive records from history? Surely the F4201 will not pick up a corresponding F42565 record so will never process history?
2) Is anyone aware of a known problem with reprinting invoices that have been archived?
many thanks in advance
Dave
OW B7333 XE sp22 on Oracle
My problem is with the invoice print R42565. I am on a new site which has recently archived all its sales orders for the first time to F42019/F42119.
The invoice print is now failing to reprint any invoices that are not in the sales files F4201/F4211. This seems odd as I always thought that the Invoice print worked on reprint even if the sales were archived. There is a comment in the Detail line one do section as follows:
// This section has (left outer) joint view between F42565 and F4201. So, evenif
// the F4201 records are purged to F42019, the records from F42565 are fetched
// and processed and the F42019 fields are fetched using the Table I/O and
// populated as if they are fetched from F4201 by the business view when the
// Order Number of F4201 is zero. SAR # 1272729
I have 2 questions with this:
1) The business view V42565A actually is a left outer join between F4201 and F42565 (not the other way round as per the the JDE comment) so how does this retreive records from history? Surely the F4201 will not pick up a corresponding F42565 record so will never process history?
2) Is anyone aware of a known problem with reprinting invoices that have been archived?
many thanks in advance
Dave
OW B7333 XE sp22 on Oracle