Hello All,
I see that we can add the on account funds to the Flex header, but has anyone done this with gift certificates, and if so, would you be kind enough to share your Sql Code with me?
Thank you!Amber Gale
Hi Amber,
If you are just looking for the balance remaining amount you can try this:
Select SUM(a.pmt_amt)*-1 From (Select a.payment_no From dbo.T_PAYMENT a JOIN dbo.TR_PAYMENT_METHOD b on a.pmt_method = b.id Where a.customer_no = @customer_no and b.pmt_type = 8 and a.pmt_amt < 0) as x JOIN dbo.T_PAYMENT a on x.payment_no = a.payment_no
Jared
Thanks for this!