2 Replies Latest reply: Mar 16, 2016 1:18 PM by Prashanth Reddy Nasi RSS

    Master calendar using two dates in two tables?

    Prashanth Reddy Nasi

      Hi all,

       

      Table1:

      Material    PaidDate    PaidAmount     BU    customer

       

       

      Table2:

      Supplier   SpendDate      SpendAmount  

       

       

      Table3:

      Material    Supplier


      I have these three tables to use.

      I have to make association between two these tables based on Date in first 2 tables and then with third table.

      The problem I am facing here is how to use the two date columns (PaidDate and SpendDate) in master calendar .

      (Spend is in one month and paid is in different month)

      How can I achieve this ?


      Thanks and regards

      Prashanth.