Skip to Content
Apr 10, 2014 at 10:46 AM

Help in designing a Query


Hello Everyone,

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 below

Account 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