I want you help in designing a query that involve OACT,OJDT,JDT1,OBGT and BGT1
Actually I want a report that shows accounts Budget quarterly and its expenditure quarterly as well..
Like shown belowAccount Name Budget from Jan to March Budget from April to June Budget from July to Sept Budget from Oct to Dec Expenditure from Jan to Mar Expenditure from Apr to June Expenditure from July to Sept Expenditure from Oct to Dec
Parameters would be Fiscal Year and Date range and Account name
Can anyone please help me out in that one
Thanks in advance