Gift card recipient balance report

(0) Share

Report

Posted on by WendyWino

We want to send an email to customers with outstanding gift card balances. Only gift card out of box reports shows customer purchaser name. I've searched many tables in table browser.

Need the following under Sales Line details in the order: Recipient name and recipient email

Form : SalesTable, control name GiftCardVirtual_GiftCardRecipientName

Table browser does not have this control name in the SalesTable

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

huijij 19,811 on at

Like (0)

Report

Hi WendyWino,

The name of control is usually not the same as the name of the field in the table, the control named GiftCardVirtual_GiftCardRecipientName is a field of GiftCardRecipientName from MCRSalesLine table in the salestable form.

Was this reply helpful? Yes No
WendyWino 5 on at

Like (0)

Report

FANTASTIC!!!!! Thank you so much! This is exactly what I need!

Was this reply helpful? Yes No