We recently upgraded a client using AP and GL only to version 2022.  Everything was fine.  Then they added a new Windows 10 workstation with 64-bit Excel.  (All previously existing workstations are running 32-bit Office.)  They ran an FR Balance Sheet on the new workstation, and it was out of balance.  They ran the same BS on a different workstation, and everything was there, balanced.  User login to Accpac made no difference.  I logged in remotely to verify - same FR form file run with the same parameters for the same period returned a statement with missing data, resulting in an out of balance statement.  We uninstalled Office and re-installed it as 32-bit.  Issue resolved.