• 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…
  • Anyone know how to Insert AR Invoice C# ACCPAC.Advantage

    I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
  • AccpacReport object leaks memory (badly)

    If you have to print multiple instances of a (seemingly any) form (with different parameters, order number, invoice number) using the COM AccpacReport and AccpacReportSetup types they leak a lot of memory. In the space of 200 iterations there is about…
  • Error "The customer or item tax class is not valid for this order." during OE Invoice Entry

    Hi All, I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…
  • My budget macro has been over written and I need to refresh it. I am using sage 300 2020.

    I need to replace my budget macro because it has been overwritten by an excel worksheet. How do I do this?
  • forcibly sign out users after 3 hours inactivity macro

    A sage 300 company with 15 users runs into the commonly seen problem where users forget to logout at the end of the day. There is a nice feature where you can sign out users from the lanpaks licenses screens manually, but has anybody written a macro to…
  • 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 New Macro instead of Editing copy of other Macro

    Hi All, I am a developer working on macro. If I want to add new macro, I have to edit existing macro and delete the codes, and pretend as if it is a new macro, instead of actually add new macro .avb file. My question is, why we cannot add new macro…
  • Edit default text on form screens

    would like to change the default text on the Purchase order entry screen to use the Arrival Date field, and call it Contract Date. can see where you can customized thee screen and add it to profile to add or remove a field but cannot see where you can…
  • 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…
  • 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…