Dear All
we need year wise opening balance and closing balance in one straight table ,for that purpose we have three separate tables one is master calendar and other one is transaction table_1 which has opening balance and table_2 which has closing balance now we want to pick approval year from master calendar opening from table_1 and closing from table_2 . master calendar has no link with any of transaction table
we have shared some sample data also .
can any one please solve this .