Sage 300

HI, Is there a way to programmatically code an objecthandle without passing it as a parameter in the Program Argument? Here is the scenario: 1. I have a vb6 program (.exe) that is supposed to run on Sage 300. This .exe program passes $objecthandle…

Good Morning; I have a client that is using the Budget Macro, to populate the budget for the current year. It seems to skip a few accounts. Any ideas?

Hi everyone: I have a macro that prints invoices to preview destination ; in past versions I was selecting what invoices are printed by changing the @Selection_criteria parameter and was able to print a particular invoice, group of invoices not in a…

I have customization of AP Payment made from VBA. when the user changes the payment day, they select a date earlier than the acceptable range date, so as we know there is a warning message, but whatever user click Yes or No. Warning message unknown…

Hello all, Is there any possible way to automate the Sage 300 item number change process? I know there's a way to automate the database dump (using OrchidSystems Process Scheduler) prior to running it, but having the ability to schedule the item number…

Sage 300 dotNet API project. Lots of the available docs say to use create a macro in the UI for what you want to do and then translate to C#. Works great for most of it but I am having an issue with the PROCESSCMD lines, which are often necessary to get…

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, The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates. Is this possible using Windows Task Scheduler or is there…

I am using the .net interface, but am fully fluent in VBA. Does anyone know of a “rule” when creating a view, and then using browse for the view? I have this snip of code that works just fine: myview = dbLink.OpenView("CS0120") myview.Browse(…

Windows 10 Pro, running Sage 300 ERP 2014 PU3 Macros have been working fine for 3 weeks on brand new box, now today I go to run and I am getting crashes of A4WVBA.EXE Faulting application name: A4WVBA.EXE, version: 6.2.0.3, time stamp: 0x5522d494…

After upgrading my computer to windows 10 all my macros are now useless.... Whenever a macro runs a report and goes to print I now get an "activation error, Printer not activated, error code -30" I have tried re creating the macros entirely, uninstalling…

I used to run the cashflow.avb macro almost every month, but hadn't run it since our year end March 31. When I went to run it this week on my computer, I don't get any error messages, just a busy cursor for a few seconds and then nothing. I have gone…

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…

Hi I'm new to Sage ERP 300. I need to import shipments from another program daily. I exported a shipment entry example and created a database in MS Access that reads the file from the other program and puts it into the correct fields in the csv file…

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…

Hi, I have created a macro for OE Entry using VBA, and have created a shortcut in “Order Entry” directory in the Sage 300 ERP. But, The question are - Now there are 2 icons, the original and the macro. how I can hide the original icon, without changing…

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…

Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…

i have the below Exception please any help ????

Hi, I am trying to create a macro to run a custom report that shows all the GL entries for the prior day for our controller to review. The report is run each morning and I would like the dates to get the prior day. Is there a way I can get the date prompt…