|
Group: Forum Members
Last Active: Tue 31 Mar 2015
Posts: 68,
Visits: 185
|
We are using the invoice feature to print off a copy of the order, but require the customer email details to be included.
Can anyone post the suitable code to amend the Invoice.asp file
|
|
Group: Forum Members
Last Active: Fri 27 Apr 2018
Posts: 9,
Visits: 29
|
You will probably have to edit the spKartrisCustomer_GetInvoice to add the u_emailaddress field from tblKartrisUsers.
Example:
SELECT O.O_BillingAddress, O.O_ShippingAddress, O.O_PurchaseOrderNo, U.U_CardholderEUVATNum, O.O_Date, O.O_CurrencyID, O.O_CurrencyIDGateway, O.O_TotalPriceGateway, O.O_LanguageID, O.O_Comments, U.U_EmailAddress
Then you can add it to a control on your invoice.ascx form by setting the text value to tblInvoice.Rows(0).Item("U_EmailAddress")
|