Adding customer phone number in invoice header table

Hi All,

Currently the invoice header does not have a customer telephone number. How can I create an UDF that grabs the customer's telephone number and add the udf inside of Invoice Header table?

Thanks.

Parents
  • 0

    Did you just include your answer in your question?  Go to Custom Office, create a UDF to the Invoice Header and the Invoice Works file and make the source the telephone number from the customer master file.

  • 0 in reply to BigLouie

    If you use Sales Orders, the customer data source might not trigger when invoicing an SO.  In that case, flow from customer to SO to invoice (and work tables).

    Also beware of multiple possible logical places to find the phone number (customer / ship-to address / confirm to contact...).  I always wondered about why Sage doesn't include a phone number for orders / invoices, but I guess the possible data sources are not simple to filter through.

Reply
  • 0 in reply to BigLouie

    If you use Sales Orders, the customer data source might not trigger when invoicing an SO.  In that case, flow from customer to SO to invoice (and work tables).

    Also beware of multiple possible logical places to find the phone number (customer / ship-to address / confirm to contact...).  I always wondered about why Sage doesn't include a phone number for orders / invoices, but I guess the possible data sources are not simple to filter through.

Children