Invoice Reprint

[DaveBarber]

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

 

[pcaenaro]

Dave



I have checked V42565A on the system I currently use (B7334) and it is a
left outer join from F42565 to F4201, although in the BSVW design screen
F4201 is on the left.

So the arrow for the link is actually going from the right to the left.



If indeed your BSVW is from F4201 to F42565, then it might explain your
difficulty with the reprint (indeed, if there is no F4201 record then your
view will not select anything) and that might require a change being made to
the view, something you might want to take to Oracle.



Hope this helps



Philippe



_____

From: [email protected] [mailto:[email protected]] On
Behalf Of DaveBarber
Sent: Wednesday, August 23, 2006 10:33 PM
To: [email protected]
Subject: Invoice Reprint



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 busi! ness 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

_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.


Looking for a job? Check out the Job
forum


This is the JDELIST EnterpriseOne Developers Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwardsR.

To unsubscribe from this list via email, Click
<mailto: [email protected]?Subject=Unsubscribe&Body=Sirs,

P
lease remove this address from the JDELIST EnterpriseOne

 

[DaveBarber]

Re: RE: Invoice Reprint

Hi Philippe,

Thanks for the info on that.
Could you maybe send me a screen dump of your business view design of V42565A please so I can check it against mine?
many thanks

Dave