How did the cache get out of sync?
The cache can get out of sync if changes are made using the standard windows on a workstation that does not have Omni Tools installed, or even if Omni Tools was installed, but the Synchronisation option had been turned off. Also, if using a Ctree cache under Great Plains SQL versions, if more than one location for the tables has been specified, the cache could be updated for one workstation but not for another.