• Reasons a macro would suddenly quit working on some Windows 10 devices and not others.

    What are some reasons a Sage 300 macro would suddenly quit working in Windows 10? We have five Windows 10 clients, and the macro has quit working on four of the five clients. Sage 300 itself still works fine. We don't know when it broke given, we only…
  • VB.Net report printing is not happy with a sage 300 session created by the program

    I have a Sage 300 program, developed in VB.Net, that generates crystal report PDFs. When I run the program from the Sage 300 desktop on my client's server, it works just fine by passing the session token as a parameter. It also works fine running…
  • Error: Class does not support Automation or does not support expected interface VBA

    Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH") On "OnUIAppOpened()" Public WithEvents dsGLJEH As ACCPACDSControl Private…
  • 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.
  • Create Customized Table in Sage 300

    Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…
  • Macro icon order

    Hi, I have created an icon in O/E Transactions folder, but this icon is placed as the last icon in the folder. How to put this icon as the first or second icon ? Thank you.
  • Customer Invoice Printing Macro

    Ever wanted to print out a Customer's invoices without having to do it one at a time? We've just had a great macro uploaded to The Report Store. You might want to take a look and see if this is just what you need. thereportstore.com
  • OCX does not show on the form at runtime

    I have a macro that contains the GL2100 OCX (journal entry screen) When run on site on a particular computer the form pops up , there is no error message but the ocx does not show at all On the same computer, al macros that contain OCX have the…
  • 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…