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

    Master calendar using two dates in two tables?

      Hi all,



      Material    PaidDate    PaidAmount     BU    customer




      Supplier   SpendDate      SpendAmount  




      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