Skip to Content
0
Former Member
Mar 20, 2012 at 02:09 AM

COPA Extraction

41 Views

Hi Experts,

I have a requirement to develop a P&L report Vs budget based on Profit Center, we already have P&L Actual Report by profit center for each activities. so now the requirementment is we need to place the Actual vs Budget for month wise

Jan- ActaulJan - BudgetFeb - ActualFeb - BudgetMarch -ActualMarch - Budgettotal Actaultotal budgettotal Actaultotal budgettotal Actaultotal budgettotal Actaultotal budgettotal Actaultotal budgettotal Actaultotal budgettotal Actaultotal budgettotal Actaultotal budgettotal Actaultotal budget

wise versa, I am loading Budget amount for each profitcenter from flat file, and actual is extracting from COPA, now in COPA data source which filed is the over all actual cost field? or how I can cummulate the fields to get Actual cost for each profit center, knd hlp me out pls. if you need more detail kndly let me know.