• VBA macro for Order Entry price not on price list

    I am trying to get my macro to allow entering a price manually. The price is not on the customers assigned price list, nor on any other price list. It is essentially a price override, which we are able to do in the UI. Get the following warning 'Information…
  • Attempt to change read-only field 'Header Discount'. when I did not even set the HDRDISC value

    Hi, I encounter this odd behavior while creating a macro to do an OE Invoice Entry. I did not even set the "HDRDISC" value but this error 1144 " Invoice Detail Attempt to change read-only field 'Header Discount'. " keep popping up and I am not able…
  • Macro to print/save Open G/L batches at month end

    I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…
  • 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.
  • I am writing a macro using ACCPACCOMAPI and was wondering how you get the Applications version

    When i run my accpac session init, as part of the arguments for that function it requires i put an arbitrary number for the version CompanySession.Init "", "CS", "CS0001", "60A". Regardless of what version the computer is using the macro now reads…
  • 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…