Adding a table to Sales Order Acknowledgement

The problem with linking the Customer table to the Order Header table
is that the CustNum field in the OrderHed.dbf file is a text field and
the CustNum field in the Customer table is a number field. The work
around is to create a sub report. Put the Customer table in the
subreport. Create a formula to change the custnum field to text, the
link the subreport to the main report with the formula field. I
believe there is documentation to explain this further on Epicor's web-
site.

HTH,

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Abe Klassen" <ak@m...> wrote:
> Good afternoon,
>
> I'm trying to add the customers phone and fax number to our the
canned Sales Order Acknowledgement. In order to do this I need to add
the Customer table to the report but I don't know how do this. Adding
it through ODBC does not work.
> I would really appreciate some direction on this. I called support
but they were of no help whatsoever.
>
> Thank you,
> Abe Klassen
>
> [Non-text portions of this message have been removed]
Good afternoon,

I'm trying to add the customers phone and fax number to our the canned Sales Order Acknowledgement. In order to do this I need to add the Customer table to the report but I don't know how do this. Adding it through ODBC does not work.
I would really appreciate some direction on this. I called support but they were of no help whatsoever.

Thank you,
Abe Klassen

[Non-text portions of this message have been removed]