Am using gift certifiacte since few years , never needed a report of when they redeemed, recently a customer bought 300 GC, redeemed 5 times partly , now he thinks more money left , i need a report when and howmuch he redeemed and ticket number so i can reprint them . searched forum cant find report , only have gc balance report thank you
Can you share names Account → Transaction Types you are using for your implementation of Gift Certificates?
thank you @Posflow am using GC Purchase Transaction, GC Redemption Transaction, GC Credit Transcation, GC Debit Transaction
Can you share a screenshot of each, I need to know names of source and target accounts
GC.pdf (416.7 KB)
[Certificate Redemptions:1, 1, 1, 1]
{ACCOUNT TRANSACTION DETAILS:GC Redemption Transaction:Receivables}
TOTAL||{ACCOUNT TRANSACTION TOTAL:GC Redemption Transaction:Receivables}
1 Like
@Posflow great thank you appreciate quick help, can i add ticket number ? also can i sort by particular GC card ? this works fine but if i add those would be really great
I think youll have to use {REPORT TICKET DETAILS:}
Can you share Entity Type detail of your vouchers and payment type details for the voucher?
What results you get out of this?
[Outlets - ACCOUNT NAME:1,1,1.5, 2, 1]
>DATE|TIME|TNO|ACCOUNT|TOTAL
@{REPORT ORDER DETAILS:T.TicketType::{0}:,}
@{REPORT PAYMENT DETAILS:P.Type::{0}:,}
>◬ $1||||{REPORT PAYMENT DETAILS:P.Amount.sum:(TY=$1)}
{REPORT PAYMENT DETAILS:T.Date,FT([T.Time],'hh\\\:mm'),T.TicketNumber,P.Name,P.Amount.sum.desc:(TY=$1) AND (PT=$2):{0}|{1}|{2}|{3}|{4}}
>TOTAL||||{REPORT PAYMENT DETAILS:P.Amount.sum}
Can you select a date/time range where you have Gift Certificate payments?
Yes thank you , it showing all payment types and all tickets for the range