Sage 300

Hi, I'm trying to create a macro which uses AccpacGrid, i wanted to add a column which contain a check box or Yes or no option in the column. I can seem find the way to achieve it. Could it be done actually? Any help will be appreciated thanks

i want to know the status of my 3rd period in 2014 is locked or not i had tried using code below Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI…

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.

%1 error when I try to edit or run macros in Order Entry in Windows Server 2012 R2 Terminal Server Trying out simple order entry macros Sage 300 ERP 2016 Windows 2012 R2 using Terminal Server

Hi, I get VBE6EXT.OLB could not be loaded when trying to edit or run a VBA Macro created for my client in V2014 we just migrated to V2017. Tried to copy the file VBE6EXT.OLB from: C:\ Program Files (x86) \Common Files\Microsoft Shared\VBA\VBA6…

Hi, I'm trying to custom PO Receipt Screen, I wanted to get the datasource of the popup detail line. I have set a datasource for popup using popupdss given. When I test it only trigger when events is On Record Changed, while on Changing it does not…

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

I recorded a macro and this was the line that was recorded for the date. GLCRE2Fields("DATERUN").Value = DateSerial(2016, 8, 31) I want to be able to input a date and tried this. I tried this below; Date1 = InputBox("What is the month end", "yyyy…

Hi, MS released an update this past weekend and it seems to have affected connections to excel. I was wondering if anybody else has experienced this. Before the MS updates our macros were programmed to connect to Excel with Microsoft.ACE.OLEDB.12.0…

I came across a blog post from 2013 that mentions that it is possible to run a sage macro without logging directly into sage using VBA, this could then be automated with task scheduler on windows here is the original blogpost from greytrix: http…

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…

Hi - I have a client that would like to export A/R data from Sage 300 (specifically the Aged Trial Balance report) and upload it to my server (we are a SaaS provider). They have nearly 100 "companies" in Sage that they would like to do this for, and doing…

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…

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…

What I would like to do is to open the form and enable/disable a field on the form based on business logic. I tried to record a Macro, but it does not open the form