• Sage300 2023 installed on W2022 OS stanadard edition - 64 bit office 365

    Is there a plan to get the sage 300 macros to run in 64 bit excel? If someone has them running in 64 bit, what was your solutions? I find the macros will only run in 32 bit and cannot get the out of box macros to run in 64 bit. Also Sage intelligence…
  • CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …
  • Order Entry Macro, how to get the order number once posted?

    I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro? I want to put it in the message box for the user.
  • composing views

    I am trying to compose the views using the .NET library in VBA but having issues as I believe it is just a syntax issue, which I can't figure this part out ' TODO: To increase efficiency, comment out any unused DB links. Dim mDBLinkCmpRW As ACCPAC_Advantage…
  • Looking for a Sage 300 Macro/VBA Expert.

    Please contact me if you are interested in partnering up. We've been a Sage VAR on the east coast since 2006, and are looking to add more VBA and macro experts to our team. Thanks very much! Kellie Pitt, ERP Practice Manager Brainsell Technologies…
  • Post OE SH Invoice

    Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…