Sage 300

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 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&…

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…

Hi, I'm trying to automate order ->prepayment->shipment->invoice with COMAPI. I did what I usually do by recording a macro and see the code. I'm able to create the shipment and the invoice but I cant see the prepayment in ARBTA. Sub MainSub() ' ' Sage…

Trying to use the .NET ACCPAC.Advantage library in a console app and it's saying I need a ref to windows.forms DLL? Is this normal? Do I really need win forms?

Hi all, I am developing an app using ACCPAC libraries: I have difficulty to do an Order Entry from my application, especially on setting the value of CUSTOMER (OE0520) and ITEM(OE0500), to do RecordCreate(ACCPAC.Advantage.ViewRecordCreate.Insert…

I am using the Accpac.Advantage dlls to communicate from a third party .net app into Sage 300. The processes we are doing are simply to open a connection and then return various pieces of information from view calls (I use the CS query view through an…

Sage 300 dotNet API project. Lots of the available docs say to use create a macro in the UI for what you want to do and then translate to C#. Works great for most of it but I am having an issue with the PROCESSCMD lines, which are often necessary to get…

Questions: 1. Where can we found exactly information about ACCPAC.Advantage > .Init session parameters, their sources and properly case usages? 2. Do [.Init] session parameters affect anything (for example, when reading data)? * eg invalid [programName…

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(…

The following code is a translation of a VB macro to create a new time card. The issue that I am having is that the Compose statement on line #37 set the view's parent to null. This causes the SetValue on line #49 to fail with a NullReferenceException…

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…

Using ACCPAC.Advantage with vb.net, I was able to open a session by doing the following: Dim SageSess As New ACCPAC.Advantage.Session SageSess.Init("", "XY", "XY1000", "62A") SageSess.Open("ADMIN", "", "XXXXXXX", DateTime.Today, 0) Now, in version…

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 have written a c# application that uses accpac.advantage to reach out and get various data from the sage 300 views. Currently I have tested this and it works just fine on the Server install machine. The issue I am having is I wondered if this…

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…