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.
I have a macro that launches a copy of the OE Order Entry. the customer runs it 3 times and gets 3 OE Windows
There seems to be data bleed between the screens where data from one screen will pop up on another screen or interfere
Any ideas on segregating…
For years we have very successfully utilized a Back Office program that I have written in MS Access and VBA. It functions to 'bridge' our POS invoices over into Sage 300.
It uses the ACCPAC COM library for login and import of invoices.
This weekend…
Hi all,
I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…
I created VB.net application which run macros but I got error when tried open session
the code:
Session = New AccpacCOMAPI.AccpacSession Session.Init("", "XY", "XY1000", "61A") Session.Open(acc_user.ToUpper, acc_pass.ToUpper, acc_company.ToUpper…
Hi all, I have already created C# program using Accpac Advantage to import AR and AP Batches into sage in Ready to Post Mode. But my client wants it to auto post after import to sage. So, is there any tutorial or example that I can reference for doing…
Hi Everyone,
I am now developing a .NET exe and Accpac.Advantage to open the view and import into Sage. But currently how I design is using the one sage login to open the view and do the stuff inside the program. Now I would like to change it to use…
I'm creating a customized OE Entry screen. I want all the users to have the exact same fields and detail columns. I'm able to hide fields on the header level using the code below. But I'm not sure how to hide specific detail columns. Anyone know how to…
Hi everyone,
I dont remember exactly but Im sure we could copy some folders/files (\USER I think so) of Sage actual installation at server (they have Sage 300 ERP 2012) to new server installation (Sage 300 2022) so we can recreate icons users run -…
Hi All,
I have an error when trying to print custom report from my C# program.
System.Runtime.InteropServices.COMException (0x80004005): Unknown error 0x80040200
at AccpacCOMSVR.AccpacSvrReportClass.PrintReport(Boolean& pWebReportGenerated, String&…
Sage menu invoked an XLSM file
Inside that XLSM file I want to use the invoking Sage300 session because customer has limited licenses
So do not want to login and make another session with another userid and or have to know user's password etc.
sort…
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…
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.
So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…
Hello
We have a C# program that takes as its input a text file, processes the file and then posts the OE Order using the class ACCPAC.Advantage. We open the OE Views to create the OE Order. The programs runs every 15 minutes on a Windows Server with…
Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
i am reviewing the Sage 300 web API and looking for a means of updating a AP payment batch (eg. removing a cheque from the batch, updating cheque dates, removing invoices,etc...) and all I can see thus far is GET and POST for APPaymentAndAdjustmentBatches…
I built two macros that create IC adjustments for a certain class of items for a client. Works fine on the system in my office.
I coped the two macros onto the clients server and when i go to edit either macro I'm getting an 'Out of Memory' error. …
Back on the custom OE Screen. Here is what I need to do. Currently the 'Post' button is hidden for certain users and exposed for others so they can post orders and quotes.
When the 'Order' is a 'Quote' ALL the users should have the 'Post' button available…
I have a built a Custom OE screen for a client that throws up an error that says "You don't have a license for this product" when it opens. When you accept the message the OE screen closes.
The screen was built in VB6 and uses a copy of the OE1100 OCX…
Hi all,
My Sage 300 version is 2023.1.0. I already have the web screen running & working fine.
My Visual studio version and info below:
Microsoft Visual Studio Community 2017
Version 15.9.52
VisualStudio.15.Release/15.9.52+33403.129
Microsoft…
I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.
Now I want to add some fields to it that are not in the set of data tables already in the report.
In the "Field Explorer" I right…
I'm trying to insert the OE Order screen into a macro and it's giving an error of 'Microsoft Visual Basic. Element not found.' I tried all of the other OE screens which worked okay.
I did this because the Visual Basic project for a custom OE screen…
Hello Team
I'm facing a small issue using Sage 300 on my new laptop, all the icons appearing too small (I customized the setting on my pc following the recommendation that I found regarding this issue but no success to fix it)