x Want to participate? Join the group to interact
Options
  • Replies 17 replies
  • Subscribers 137 subscribers
  • Users 0 members are here
  • Views 3897 views
Browse Forums
Announcements
237
topics
260
replies
Databases and Operating Systems
682
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
8k
replies
Operational Suite
813
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
803
topics
2k
replies
Sage CRM for Sage 300
166
topics
707
replies
jwckauman

Office 64-bit Integration & Support?

Posted By

What's the latest word on Sage 300 and Office integration?  Today we are running Sage 300 2018 and we are currently limited to Office 2019 32-bit.  We are upgrading to Sage 300 2021 this spring but it doesn't appear that Sage 300 2021 supports 64-bit Office.  Is that right?   

Has there been any discussion about supporting 64-bit Office? or any options for those companies that don't have a choice due to other requirements in their infrastructure?  Maybe workarounds or optional configurations?  

Finally, is Office 365 supported?  We dont use that flavor of Office, but are looking at possibly going that route...

Parents

  • Sage 300 is a 32 bit application, it will never talk to Office 64 bit. Not unless Sage 300 is rewritten in 64 bit, but that is not going to happen. With that said.... you can export/import data no matter which Office 32/64 bit you have installed, you just cannot run FR and some other integrations that require both applications to be 32 bit.

  • in reply to Ettienne Schwagele Acumen

    It was straightforward to get 32-bit apps to talk to 64-bit Office.

  • in reply to R.J. Dunnill

    This post hasn't aged well, my comments are now wrong.

    I can confirm that on 2022 PU4, you can run 64-bit office, not only with Financial Reporter, but with custom VBA programming.  We upgraded one of our big clients last week, and they're happy that 64-bit Excel finally runs.

    The only issue I had was with VBA forms that had a Fieldedit control and a Datasource.  The Datasource control is not currently available in 64-bit.  The KISS solution for my client was to abandon the pretty finder and use a simple text field for them to type in the vendor number.

Reply
  • in reply to R.J. Dunnill

    This post hasn't aged well, my comments are now wrong.

    I can confirm that on 2022 PU4, you can run 64-bit office, not only with Financial Reporter, but with custom VBA programming.  We upgraded one of our big clients last week, and they're happy that 64-bit Excel finally runs.

    The only issue I had was with VBA forms that had a Fieldedit control and a Datasource.  The Datasource control is not currently available in 64-bit.  The KISS solution for my client was to abandon the pretty finder and use a simple text field for them to type in the vendor number.

Children
No Data