x Want to participate? Join the group to interact
  • Replies 2 replies
  • Subscribers 116 subscribers
  • Views 897 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
756
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
408
replies
murni

Financial Report UI is different between Microsoft 365 and older version of Office Excel

Posted By

Hi all, 

my customer is generating financial report from Sage 300 web app as excel file and open it on Microsoft 365. However, the alignment is wrong. All the debit values in red color appears in Credit column.

When opening it on old version of Office Excel ie  2016, the debit values appears correctly.

Is there anyway to fix this? We cannot ask the user to workaround or purchase old version of Microsoft Office. 

As of now, we have found this issue in GL Transactions Listing Report and Trial Balance Report

  • Could it be that one was exported in a formatted style and one exported as data only

  • This report is a crystal report (not from the GL Financial Reporter).

    I assume on the print preview screen it shows correctly.

    As Anthony said, it is the export to Excel that is the issue. Test using different versions of Excel in the export :

    Also test changing the Export Options - especially the Column Width - try 'Details' first

*Community Hub is the new name for Sage City