SBT PRO 5.0I P O Module, Print, transaction report OPEN ORDERS

[titoneon]

It is possible to link or obtain when running this report "OPEN ORDERS" from the Print menu on purchase order the" phone #" for each vendor in that report, from the table APVEND.DBF , I would like to print for each open order record in that report that have the vendno it is phone#, but i can't see how to do that, can you please advise me ? and thanks for the previous suggestions you gave.
Really well appreciated
Note> yes i have the source code and VFP 5.0
thanks a lot

 

[PBSVic]

The PO Open Orders report closes APVEND after Generating and before Printing/Previewing the report. APVEND is re-opened again later.

If you have source code, after the call to Procedure L_BLDTBL in POREPT.PRG, you can re-open APVEND yourself with:

= g_opnfl(gf_apvendf, "a_apvend", .f., .f., "vendno")

Then set additive relations to it.
The Phone Number and all other fields from the vendor file will then be available for fields in the report form. e.g. a_apvend->phone.

 

[titoneon]

Hi PBSVic,
I need to clarify something, you said
1-If you have source code, after the call to Procedure L_BLDTBL in POREPT.PRG, you can re-open APVEND yourself with:
= g_opnfl(gf_apvendf, "a_apvend", .f., .f., "vendno")

You meant to write the above code line after the procedure is ended, or you mean inside the procedure before it ends ?

2-set additive relations to it, you meant below the line
= g_opnfl(gf_apvendf, "a_apvend", .f., .f., "vendno")
I should write something like

"Set relation to vendno into a_apvend"
is that what i need ?
Thanks a lot a lot