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.

       

      gwassenaarswuehlkush141087maxgrorwunderlichstalwar1sorrakis01anonymousmbaeyens