Business Portal Requisition accounts not showing correct description

Client called with a problem in Business Portal - when the Requisition Creators are adding Items to their Requisitions, the account list shows the same account description for any account listed.  This client uses Account Level Security in GP to limit user account selections in Portal.


As MS Support pointed out this was due to the account description in the GL00100F1 table not correlating to the actual account description in GL00100.  No way of telling how this happened but an easy fix if you need it.


Execute the following script against the GP company database:


update a
set a.ACTDESCR = b.ACTDESCR
from GL00100F1 a
join GL00100 b
on a.ACTINDX = b.ACTINDX


If you have sub-levels of account security, our client does not, you may need to execute the same against GL00100F2.