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.
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…
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…
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);
…
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
When the user is login and the Task Scheduler fired up, the posting in SAGE is successful. But when the user is Signed Out and Task Scheduler fire up. We received an error:
Error: External component has thrown an exception.. Inner: . Full: System…
Does anyone here encounter an error for the SUBVIEW.DLL? We created a WEB API, when deployed it is fine when creating single calls. But when doing multiple calls simultaneous we got w3wp.exe error. Upon analyzing the dump file it shows: \ vi65a\SUBVIEW…
I am using the .net interface, but am fully fluent in VBA.
Does anyone know of a “rule” when creating a view, and then using browse for the view?
I have this snip of code that works just fine:
myview = dbLink.OpenView("CS0120")
myview.Browse(…
Hi All,
I am doing a "Field Edit Control" and would like to put in a presentation mask. From the programming guide, there is a property ".PutPresentationMask (????").
But where can I find what are the "Mask example", and what does each characters…
We have a Sage 300 v16 system. I am trying to use the .NET API to call it from another system.
I am running the following code;
Session s = new Session();
s.RemoteConnect(Server, User, Domain, Password);
s.Init("", "XY", "XY1000", "62A");
s…
I have some macro code that is printing A/R Invoices to PDF files.
The code works fine on my laptop, but on the client workstation, it crashes. Event Viewer identifies MSVCR120.DLL as the problem.
The OS and Excel versions are identical on the workstation…
When trying to process the Create Revalation batch in General Ledger, the Batch Description and the Process Botton are not accessible.
We are using Sage 300 ERP 2014 , PU3, Microsoft SQL.
Any ideas?
Hi,
I'm developing an Order Entry macro, by using "AccpacOE1100UICtrl" object.
This macro should be able to add an item and delete the item if the user selects a certain ship-to location.
I'm able to add the item, but when deleting the item, the…
Hi - I have a client that would like to export A/R data from Sage 300 (specifically the Aged Trial Balance report) and upload it to my server (we are a SaaS provider). They have nearly 100 "companies" in Sage that they would like to do this for, and doing…
Can anyone tell me advantage or disadvantage of using one over the other?
My scenario is that I am writing a C# dll for an external .Net application I am writing. Currently I started out using Accpac.Advantage but am unsure if that is the best approach…