Sage 300

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…

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…

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…

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…

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…

Hi all, I want to get the username of current login user in macro. What Roto ID should I use?

Hi, I am doing customization to add multiple lines to GLJED. But I get multiple error that I cannot find out why it is happening, note that I only trying to add to GLJED, not GLJEH Below is my code. Instead of getting the record by Batch in GLBCTL…

Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.

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…

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…

I need to replace my budget macro because it has been overwritten by an excel worksheet. How do I do this?

Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

Hi all, I am making a macro program to insert OE transactions in bulk by reading a csv file with a lot of Order transaction. Some of the Order might have error while trying to insert. So, I need an indicator that this specific transaction failed or…

Hi SageCity, which framework can I use to have the same user interface as Sage 300, Border Size, Title bar color Example Sage Interface : My Interface :

Hi I'm trying to get company color but I haven't the same color with Sage, Someone can help me please Dim Company As String Company = AccpacSession.CompanyID Dim System As String System = AccpacSession.Organizations(AccpacSession.CompanyID).SystemDatabaseID…

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…

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…

Hi All, I have problem with printing report from macro. this is my code in macro this is my parameter in the Crystal Report and this is the only parameter. But it still prompt for connection authentication and parameter Is there…

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…

Hi All, I'm making a macro to post receipt entry based on PO number and the receipt number is pre-generated. For the detail line, I do not want to receive all. But so far did not success. How to prevent receive all? Below is my code. I have set…

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.

Hi, I have create a new program using C# to be used inside Sage300 as a program. Currently to create a session, I hardcode the companyID for the parameter. However, the program is going to be used by multiple companies. Hence my question, how to pass…

Hello I Want to get the opened company id on my custom program, which argument can i use? i'm using Sage 300 2012

Hi, im trying to create a macro to capture Popup data sources, and capture the events of the ds. I created this code below, then I tried to debug. But it does not capture the events of the dsPORCPLDet. Is it possible to have this function in Sage .…

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…