x Want to participate? Join the group to interact
  • Replies 3 replies
  • Subscribers 133 subscribers
  • Views 2207 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
765
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
Jim Love

WARNING on 64-bit Excel with version 2022

Posted By

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.

Parents

  • I believe the problem is that the Accounts in question are not associated with an Account Group Code.  

    When running via Statement Designer, it runs the following Select Statement pertaining to Account Group Code

     AND (ACCTGRPCOD <= "ZZZZZZZZZZZZ")

    Whereas when run from Print Financial Statements it runs this:

    AND (ACCTGRPCOD >= "00")

    So if the Account Group Code is unassigned then it is a Blank record.. the first statement will return the account, whereas the second will omit it.. 

    Workaround is to just associate the Account with an Account Group.

    Issue has been reported to Development.. 

Reply

  • I believe the problem is that the Accounts in question are not associated with an Account Group Code.  

    When running via Statement Designer, it runs the following Select Statement pertaining to Account Group Code

     AND (ACCTGRPCOD <= "ZZZZZZZZZZZZ")

    Whereas when run from Print Financial Statements it runs this:

    AND (ACCTGRPCOD >= "00")

    So if the Account Group Code is unassigned then it is a Blank record.. the first statement will return the account, whereas the second will omit it.. 

    Workaround is to just associate the Account with an Account Group.

    Issue has been reported to Development.. 

Children
No Data

*Community Hub is the new name for Sage City