• Reasons a macro would suddenly quit working on some Windows 10 devices and not others.

    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…
  • 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.
  • Sage 2017 - 64A can't login through C# App.

    Wrote simple app to simulate login into Sage 300 in C# i can query the company names... but when i try to actually use a password and login user it gives me Invalid Signon Information error message, anyone know what i'm doing wrong? session =…
  • CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …
  • 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…
  • Inventory transfer macro is failing when negative levels allowed

    I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2 I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5. Location 1 had zero of these items and so…
  • Fiscal Period for Specifik Module Macro

    I have some problem in macro the case was, i want to get 2022-01 (yyyy-mm) fiscal period status of my IC module in ACCPAC using macro Can anyone have some solution for this? thanks in advance
  • Attempt to change read-only field 'Header Discount'. when I did not even set the HDRDISC value

    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…
  • Allow users to run Macros, but not edit or record Macros

    Hi, I'm trying to allow users to only run Macros without also giving permission to record or edit. In Administrative Services Security Authorizations (sage300.com) , for the "Maintain Macros" permission, it says " Allows users to record and edit macros…
  • how to go to a line in a PO

    I know in OE can do something like OEdet1.gotorecordnumber 3 for example to go to 3rd line in grid but when I try this in PODET1 view (POPORL) I get an automation error i can podet1.gotop and podet1.gonext and browse all the details how do i go…
  • Indicator for a successful and failed insert in Order Entry

    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…
  • 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. …
  • Macro VBA Sage 300

    I found an error when running the macro file
  • VBA emails and Outlook 365

    Is it possible to use Outlook 365 in a VBA macro to send emails? Does anybody have any sample code? Thank you.
  • Other report parameters

    I was doing some research and came across this blog post from Stephen Smith talking about the hidden Crystal parameters. Thought I'd add it here to be picked up by the Sage forum search engine. (From: https://smist08.wordpress.com/2012/09/15/reporting…
  • Macro PO Order

    how to retrieve vendor number values ​​on the PO Order screen using macros Thanks,
  • VB6 IDE SignOn Manager Issue

    I just set up a fresh development environment. Windows 10 VM with Sage 300 2019 PU5. When I run a program from VB6 IDE and I'm logged into Sage 300 the program fails with a non descript error when trying to create/join the session. SessMgr.CreateSession…
  • Macro to print/save Open G/L batches at month end

    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…
  • Macro - Receipt Entry - Do not want to receive all

    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…
  • PopUpDS Event

    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 .…
  • 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…
  • Error adding an item to a sales order

    I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get: "Order Detail. Attempt to modify a different record than was retrieved." This occurs on the code…
  • 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…