MagarG
VIP Member
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
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