• Posting AR or AP Batches using accpac advantage

    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…
  • VB.Net report printing is not happy with a sage 300 session created by the program

    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…
  • CS0120 data to accpac finder in COM API

    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); …
  • Fiscal Period for Specifik Module Macro

    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
  • Unable to post via Task Scheduler - System.Runtime.InteropServices.COMException (0x80004005)

    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…
  • SUBVIEW.dll causing AccessViolation

    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…
  • create view - only some allow SQL?

    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(…
  • Sage300 VBA field edit control .PUTPRESENTATIONMASK

    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…
  • Remote .NET API fails at Session Open.

    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…
  • Excel crashes printing A/R invoices through VBA - MSVCR120.dll

    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…
  • Batch description and Process bottom are not accessible for users

    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?
  • Delete an order item without user confirmation

    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…
  • Help testing/writing AccPacCOMAPI for a client (I'm in NY)

    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…
  • AccpacCOMAPI vs Accpac.Advantage - closing connections.

    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…