how to get a column showing cost in cost loading r

S
Sajid Mohd 👤 Member for 22 years 6 months
M
Michael Byrne 👤 Member for 22 years 7 months

Sajid,

Just to eliminate the obvious, under the "Format" tab of the cost loading report, be sure that the "summary report" checkbox is off. If this does not sor out your problem, please describe the colums & layout of the csv file that is being generated.

Good Luck,



Michael.

M
Michael Byrne 👤 Member for 22 years 7 months

Sajid,



Sorry for the late reply, christmas parties have kept me out of the office for the last few days.



What you are doing seems fine to me. I think the problem must lie in how your costs are set up.

Is each activity cost loaded individually?

Are you assigning costs to activities based upon resource costs are by using cost accounts?

I use cost accounts and the method you described, works for me.

F
Forum Guest 👤 Member for 17 years 4 months

michale,

Thanks for ur reply. i followed the steps and got the report in excel but still i’m missing a column which shows cost of each activity. let me explain my question to further level.

Preparing Cost Loading Report in CSV Format.......

Under the Format i have chosen the following:

1)export report in csv file

2)Organize by Area

3)group By None

4) summary check marked and rest of the format options r as it is

UNDER the Time scle i have chosen the following:

1) the time range validate the project period.

2) display unit is set to weekly

UNDER Resource selection and the seclection box i have chosen nothing and i think i ’m making some mistake in these areas, thats why i’m not getting a column which shows the cost value of each activity. please reply me if u c my question. thanks!

M
Michael Byrne 👤 Member for 22 years 7 months

Sajid,

If I am reading your question correctly, simply go: Tools - Tabuluar Reports - Cost - Loading. Then "add" your own report. Under the "format" tab, click " Export report in CSV format, and beneath this organise your activities as you want. Be sure that the timescales are set to suit the project. When the CSV file is generated, simply save it down as an excel file. I hope I’ve interpreted your question correctly. Let me know if this works for you.



Michael

Forum Sponsor

Top Posters

MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
Hunais M J
0 posts