Thursday 13 December 2012

Forecaster - Input Set Lock

To remove the input set lock, follow these steps.

Before you clear the lock, verify that no other users are logged on to the system. Otherwise, the user who is modifying the input set will lose their changes. To check for other users who are logged on, click View, and then click Current Users List.

  1. Click Tools, and then click Remove Input Lock.
  2. Click to select the input set that is locked, and then click Clear Lock.

Voila!

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!