Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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 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…
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…
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.
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 =…
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);
…
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…
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…
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
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,
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…
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…
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…
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.
…
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…
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…
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…
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…
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…
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…