P6 Not Exporting Full Cost Account ID

I am trying to export the entire cost account ID into excel. It appears as if primavera only takes the end value of the ID. So if I have a cost acount ID 00A.01 it will only export 01. Is there any way around this? 

Z
Zhang Haixiang 👤 Member for 21 years 1 month

 

you can try report. 

* create a "activity resource and role assignments" report to include the cost account column

* run the report and save to an ASCII Text File

* import the file into Excel

C
Coy Laughlin 👤 Member for 6 years 6 months

Yes. The cost account ID only exports the end value so 316.0.10.4 will only export .4
I dont know how to format the cost account ID to get a successful re-import. I am exporting to excel.

Z
Zoltan Palffy 👤 Member for 16 years 10 months

so you are exporting Resources and Resource assignments ?

then you are exporting resource id and and cost account id ?

and resource type ?

D
David Kelly 👤 Member for 21 years 7 months

I have a few versions of P6 on different machines, but none as old as 7.0

I would advise downloading an evaluation of version 18 PPM, and checking it with an import of your project.

C
Coy Laughlin 👤 Member for 6 years 6 months

I checked the admin preferences and both items you specified were set to the maximum. Also, I am using version 7.0.

Z
Zoltan Palffy 👤 Member for 16 years 10 months

do you have the rights to do this ?

what version of p6 are you using ? 

in the data limits what are your cost account tree maximim level set to  ?

in your ID Lenghts what are your cout account ID maximim characters set to  ? The maximum is 20 make sure that is set to that

 

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts