0 Replies Latest reply: Jun 17, 2016 2:40 PM by qvhelp please RSS

    data mapping

    qvhelp please

      i have transaction data where the total amount(excluding comps(discounts)) for the particular check(order) is calculated , i have another table with reasons for the comps and there ids , is there anyway i can figureout which comp is been used for which check ,and i want to have a flag for checks with comp and checks without comp.


      i think this can be done by checking the relation between comps ,ItemSales,Payment


      please find the attached excel with sample data and codes for comps.