Wednesday, 12 December 2012

GP Budget Import Error

Trying to import budget from excel to GP.

SCENARIO:
Trying to import budget from excel to GP although you have exported the sample from GP and used that as your basis and put your figures in the spreadsheet generated by GP. Then you proceed to import and get an error.

ERROR:
"The number of periods for the budget does not match the number of columns in Excel. Import will not be able to complete."

RESOLUTION:
Change column headers from date type to text by putting apostrophe (') in front the date fields.

Voila!


No comments:

Post a Comment