• run macros using Windows Service (local system) - Session Could not be opened

    I have Windows Service which read some data from database then run macros to generate some reports as pdf files automatically (statement of account, Customer Aging....), when I run the service as "local system" the service can read the data from database…
  • open session in Windows Service

    I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…
  • Sage 2017 How to insert AR Customer into Sage with C#

    Does anyone have a sample C# example of how to insert a customer into the AR Customers section of Sage 2017 ? I have the Visual Basic macro sample, but it looks so complicated, don't know where to start.
  • applying order level discounts with taxable items

    Hi - I have a program that is importing orders (downloaded from an ecommerce site) and sometimes there is a general discount applied to the order. Sometimes there is a taxable item on the order. When I import the order into sage I am using all of the…
  • class not registered C62A69F0-160C11CE-9E98-00AA00574A4F

    Good Day, our client upgraded there office from 32bit to 64bit. But now we are getting a class not registered error when trying to open macro to display user form. We have tried to reg edit the fm20.dll file and that also gave us an error. …
  • 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…
  • Macro fails on workstations but works fine on Server

    I updated a client from Sage 300 2017 to Sage 300 2019 and one of the macros stopped working on the workstations. They are also on a new server. The macro uses the PO Receipt screen as one of the forms. I updated that form to the new version of Sage and…
  • report @selection_criteria parameter ignored in versions 2017-2018

    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…
  • Automatically run Crystal Report & email. Sage 300 2018.1 on Windows Server 2012 R2

    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…
  • 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…
  • Order Entry macro problem

    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…
  • Report print Macros

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