It is often a requirement to establish the outstanding liability a retail store has in relation to Gift Certificates/Gift Vouchers.
This requirement is addressed in FlexQuery through the AUDIT -> Receipts -> Gift Certificates (Vouchers) source query. Running the query and layout out the view as shown in the image below will produce a quick report of all Gift Certificate transactions with their associated amounts. Subtotalling these then quickly shows which Gift Certificates still have an un-redeemed amount, which have been redeemed fully, and which have been over-redeemed.
The grouping of the layout will need to be based, at a minimum, on DOC_NO which represents the Gift Certificate number.
By layout out the view in this manner you can drill down to individual invoices. When you sell a gift certificate, it is treated as ‘Change’ Tender’ So selling a gift certificate gives you a negative value in the AMT column. If the subtotal is:
- greater than $0.00, the Gift Certificate has been over-redeemed.
- $0.00, the Gift Certificate has been fully redeemed.
- less than $0.00, the Gift Certificate has not yet been fully redeemed – this represents the retailer’s liability.
Once the layout has been created, it can be saved (along with a predefined filter) and added to My FlexQuery for easy retrieval at a later time.