AnsweredAssumed Answered

actauls per line item in cost plan detail

Question asked by leo.j.beck on Dec 30, 2014
Latest reply on Dec 30, 2014 by navzjoshi00

All, I am trying to get actuals per each line item in cost plan detail and i was wondering if anybody has done this before. the requirement is to display each cost plan details line item with planned to date amount and actuals to date amount. I am doing this as NSQL portlet and tried to see if there is any slice table i can use but it seems i couldn't find it. Then i tried to join fin_cost_plan_details table to ppa_wip with grouping attributes but having hard time doing it as they don't have same grouping attributes for each cost plan. if you have done this or seen this before, please share how you did this. any help or input will be greatly appreciated. i am working on 13.2.

Outcomes