DATA IMPORT - AQ
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
Jonathan,
I think you did not understand what I mean. This is what you need to do.
First export P3 data including Act Id, resource, BQ, AQ, QAT & QTC. Then populate all fields using your own data then import back. This will update all fields that you required. If importing only AQ it may not update because QAT - QTC = AQ where QAT & QTC is exist on your P3 database which you need to replace also using your own populated data.
Thank you Rodel,
these figures that I need to import are Actuals - real numbers booked to activities so I need the AQ field populated from the import.
It is very strange as I can update the Es and EF and Activity Titles - just not the AQ??
any other ideas?
once again many thanks
Hi Jonathan,
Try to include QAC "Quantity At Completion" and QTC "Quantity to Complete". It dictates the update of AQ "Actual Quantity". If QAC = BQ then QAC-QTC = AQ.