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 am trying to get my macro to allow entering a price manually. The price is not on the customers assigned price list, nor on any other price list. It is essentially a price override, which we are able to do in the UI.
Get the following warning 'Information…
I have a Sage 300 program, developed in VB.Net, that generates crystal report PDFs.
When I run the program from the Sage 300 desktop on my client's server, it works just fine by passing the session token as a parameter.
It also works fine running…
I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
If you have to print multiple instances of a (seemingly any) form (with different parameters, order number, invoice number) using the COM AccpacReport and AccpacReportSetup types they leak a lot of memory.
In the space of 200 iterations there is about…
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 All,
I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…
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…
Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH")
On "OnUIAppOpened()"
Public WithEvents dsGLJEH As ACCPACDSControl
Private…
A sage 300 company with 15 users runs into the commonly seen problem where users forget to logout at the end of the day. There is a nice feature where you can sign out users from the lanpaks licenses screens manually, but has anybody written a macro to…
Hi All,
I have problem with printing report from macro.
this is my code in macro
this is my parameter in the Crystal Report and this is the only parameter.
But it still prompt for connection authentication and parameter
Is there…
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…
I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro?
I want to put it in the message box for the user.
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…
It would need to prompt for from bank, to bank, amount, and transfer date.
then offer OK or cancel.
The rest of the stuff on the bank transfer screen I find not helpful.
would like to change the default text on the Purchase order entry screen to use the Arrival Date field, and call it Contract Date. can see where you can customized thee screen and add it to profile to add or remove a field but cannot see where you can…
Hi,
I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…
I would like to make changes to the G/L Integration, Transactions, within the AP module and have the changes take effect from day one of using this module, as opposed to only having the change in effect moving forwards. Any macros that could be run to…
I have a macro at a client that shows a (Not Responding) message at the top of the screen while the macro is running. It still works and completes its process. This message does NOT show on their old server when the exact same macro is run. Same version…