2007 Aug 14 10:48 AM
Hi All,
I am new to FICO. In my place there is no FICO Consultant. I need to
develop one report as follows . This one is Budget releted monthly
report. If anyone hep me to find out the Field and table names or
send code will be appreciated .
Report look like this :
CLIENT SERVICES -
> Dept Name ( Need Dept wise total)
Title
Expenditure C.MON.Actual YTD.Actual YTDTOTAL BUD.UTL(%), App.Bud
1. EOM 1 5,044 42,516 42,516 13.9% 304,000
2. Direct ooE 12,000 12,000 12,000 10% 2040000
Books 12 12 21 5%
Coprate - - -
Course fee - - - - -
3. CF/RF Expenditure
Total
Pls anyone help me will be appreciated.
Thanks
Rathnam
Hi All,
I am new to FICO. In my place there is no FICO Consultant. I need to
develop one report as follows . This one is Budget releted monthly
report. If anyone hep me to find out the Field and table names or
send code will be appreciated .
Report look like this :
CLIENT SERVICES -
> Dept Name ( Need Dept wise total)
Title
Expenditure C.MON.Actual YTD.Actual YTDTOTAL BUD.UTL(%), App.Bud
1. EOM 1 5,044 42,516 42,516 13.9% 304,000
2. Direct ooE 12,000 12,000 12,000 10% 2040000
Books 12 12 21 5%
Coprate - - -
Course fee - - - - -
3. CF/RF Expenditure
Total
Pls anyone help me will be appreciated.
Thanks
Rathnam
2007 Aug 15 9:22 AM
Hi Stalin ?
which standard tcode are u ref'ing ? , can u fetch data based on the G/L accounts ?
regards
Peram
2007 Aug 15 3:00 PM
Hi Prem,
Thanks for your reply.
Just they given me the output format in Excel sheet. I don't know how to get all the field and calculation. There is no standard Transaction . Monthly genereate this report. If you provide your email id , I will forward to you.
Requirement is as follwos
EXPENDITURE Curr.MON.ACTUAL YTD ACUTUAL YTDTOTAL BUDUTL % Approved Budget.
This report generate based on Divison or Department wise.
Thanks
Rathnam
2007 Aug 15 3:03 PM
Hi Stalin,
Have you posted your query in FICO forum. I think you will get fast response there.
Regards,
Atish