• Reasons a macro would suddenly quit working on some Windows 10 devices and not others.

    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…
  • Sage 2017 - 64A can't login through C# App.

    Wrote simple app to simulate login into Sage 300 in C# i can query the company names... but when i try to actually use a password and login user it gives me Invalid Signon Information error message, anyone know what i'm doing wrong? session =…
  • Session Initialization w/.NET API

    I have the following code to create a session. Session s = new Session(); s.Init("", "XY", "XY1000", "67A"); s.Open(User, Password, Company, DateTime.Today, 0); A client had been using ADMIN/ADMIN for the username and password (don't ask why they…
  • VBA emails and Outlook 365

    Is it possible to use Outlook 365 in a VBA macro to send emails? Does anybody have any sample code? Thank you.
  • Payables Workflow with PJC Retainage Integration

    Does anyone knows of a web-based Payables Workflow that is able to process and approve job-related PJC invoices with retainage? Both Pacific Technologies and Norming's solutions do not handle PJC retainage. Thanks.
  • Event Viewer Exception from Accpac internal dlls

    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…
  • Issue sending AP/AR Adjustments using SAGE300WebAPI calls ARReceiptAndAdjustmentBatches/APPaymentAndAdjustmentBatches

    I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
  • Website integration to Sage 300 ERP

    How can we restrict or reserve one LANPAK from one IP address. We have a web store where we selling items . a customer purchases item on web store and it goes and creates an order and an invoice in sage.. The service is configured to use a sage LANPAK…
  • dotNet API PROCESSCMD

    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…
  • 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(…
  • 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…
  • Post OE SH Invoice

    Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…