• Replies 2 replies
  • Subscribers 415 subscribers
  • Views 91 views
  • Users 0 members are here
Related

Gift Certificates on Flex Headers

Amber Gale
$organization

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

Parents
  • $organization

    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

Reply
  • $organization

    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

Children