Report fetching of data not in business view

[MagarG]

We modified the Purchase Order Print (R43500) report to format it the
way we want it. We now want to add the phone and fax number under the
Order From fields. The report uses two tables, the PO Header and
Detail. The PO Header has the address number. The event rules use
functions to get the address but not the phone numbers. We want to use
this address number to look up the phone and fax number in the F0115
table. The phone numbers are coded with a blank and the faxes are coded
with an 'F' record type.

Does anyone know the function name and parameters to retreive this
based on the Address Number, is there such a function? Grant.

ENT: AS400 V4R5 Xe SP16.1
DEP: NT 6a SQL 7 SP3



AS400 V4R5 Coexist CO-NT Xe SP16.1
Websphere 3.5.4 on AS400 JAS SP16.1

 

[Sef]

Hi Grant,

The easiest way to accomplish this is to use a F0115.Select (pass in AN8 and PHTP) followed by a F0115.Fetch Next (fetch AR1 and PH1) and move to report variables.

If the retrieval of Additional address book data (eg ex F0115, F0116, F0111) is something you need to do on a multitude of commercial documents (eg also Sales Invoice, A/R Invoice, Remittance advice etc.) you may want to consider writing a small NER BSFN to retrieve this data (as one of my clients have done).

Rgds,


Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT

 

[Christian Audet]

Hi Grant,

I you absolutly look for a business function then you can use B0100004 (F0115 Get Phone Number), It's not as flexible a fetch single but it's working OK to retreive two phone number (ex: Business and Fax) at the same time.

Christian Audet

*** SHARED KNOWLEDGE = BETTER KNOWLEDGE ***

Implementing B7333 (Xe) SP16.1, SQL
(Support B732, B7331 and B7332)

 

[MagarG]

Great! This pointed us in the right direction. gm.

Hi Grant,

I you absolutly look for a business function then you can use B0100004
(F0115 Get Phone Number), It's not as flexible a fetch single but it's
working OK to retreive two phone number (ex: Business and Fax) at the
same time.

Christian Audet

*** SHARED KNOWLEDGE = BETTER KNOWLEDGE ***

Implementing B7333 (Xe) SP16.1, SQL
(Support B732, B7331 and B7332)
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=25623

+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World« / XE mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards«

+ - - - - - - - - - - - - - - - - - - - - - - - -+



AS400 V4R5 Coexist CO-NT Xe SP16.1
Websphere 3.5.4 on AS400 JAS SP16.1

 

[kmahony]

Sounds like a useful business function to use when going out at night.


Sorry but i couldnt help myself
Cheers
Kieran




I you absolutly look for a business function then you can use B0100004
(F0115 Get Phone Number), It's not as flexible a fetch single but it's
working OK to retreive two phone number (ex: Business and Fax) at the
same time.





CONFIDENTIALITY : This e-mail and any attachments are confidential and may be
privileged. If you are not a named recipient, please notify the sender
immediately and do not disclose the contents to another person, use it for any
purpose or store or copy the information in any medium.