Upgrade from 1.3 to 1.4 imports department ID into control code (differs from project, breaks AP/AR screens)

[craigwebster]

Doing my upgrade path, from 1.2 to 1.3, then immediately to 1.4.20, I found that department and project were handled differently in being imported into the new business unit (reporting unit) structure -- Ie. Department ID was made the control code (even though it is I think necessarily an auto-generated number), while Project Number became the control code (which is user-definable and was the dropdown text).

I think probably the import should function by taking column department.description for the control code, since that was the previous dropdown.

I hacked this temporarily by changing AR and AP to show both control code and description for business/reporting units, but this is poor for various reasons. (See diff file aa.pl.diff.txt.)

A better post facto workaround is probably to move all the department descriptions into department control code with the extremely simple SQL:

UPDATE BUSINESS_UNIT
SET CONTROL_CODE = DESCRIPTION
WHERE CLASS_ID = 1;

If for some reason you had duplicate department names, you'd have to fix that of course.