Sage 300

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…

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

I'm working on the Sage 300 Web API to pass Customer Receipt to Sage 300 version 2021. In the Github documentation, it mentioned that we could set the Batch Status as Ready To Post on the POST request. A separate PATCH request is not required as the…

Hi just wondering if anyone has used SalesAnywhere. Am looking for a solution/plug-in to include a field employee /Salesperson tracking function for SalesAnywhere. Would be great if it had geo-fencing as well. Thanks in advance.

I'm trying to insert an order using the API - and I'm getting back an error that just says 6666 How can I find what this means, and in general, is there a way to get the COM exceptions and error codes? I know how to get session.Errors, but that is empty…

can we integrate sage 300 SDK with node js?

Hi, I used below code to generate OE Shipment using Accapc Advantage DLL. Using below code Shipment Entry is creating successfully with Lot Info but Lot Available Qty is not deducting. I hope using ComAPI DLL it will work but i want to achieve this…

Hello Team, According to the Sage 300 specification, we can use the following filter 'allpages' For example: http://{ip adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$inlinecount=allpages But, we cannot receive the number of customers in the response…

Hello Team, When I try to call ARCustomers via API using a filter that designated in the Sage 300 specification, I received an error. Example of the request: http://{IP Adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$filter=DateLastMaintained le datetime…

Is it possible to use Outlook 365 in a VBA macro to send emails? Does anybody have any sample code? Thank you.

Hi, We've tested to call xxxxxx/.../APInvoiceBatches by sending 19K entries and the API is not returning any value (no response). Is there any limitation on the entry creation?

I have a custom integration using the COMAPI to connect to Sage 300 from another app (Sage CRM) on the same server. We have upgraded the Sage 300 to version 2020 and the integration broke. With the web deployment removed from Sage 300 in the more…

Hi there, I have a client on Sage 300 5.6 and have upgraded them to 2020. There was some legacy code written to connect an external program through the AccpacCOMAPI but it is now broken. Specifically, when I try to run this, it fails when trying to…

Hello Friends, Is there any way we can integrate other Accounting systems like Quick-books with Sage 300 ERP. If yes how can we do that Thanks Pratik

Hello, we are new to the COMAPI. Can someone point to the direction how we can find the COMAPI object in visual basic?

Hi, I am having problems loading currency rates through the webapi. I am using v2019.1 on premises to load currency rates into company EURPAY. The following code using PHP and cURL is as follows: endpoint: "">localhost/.../CSCurrencyRates"; …

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…

I am posting this as a potential issue for others. In PU2 Sage in all their wisdom have decided to.... Bump the version number of \HKLM\SOFTWARE\WOW6432Node\ACCPAC International, Inc.\ACCPAC\Web\A4WNET to 6.5.0.2 but not keep this in step with the…

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…

I am developing a critical application that will need to communicate with Sage using the API. We are typically at our max users, and anytime the critical application needs to communicate with the API it uses 1 user license. I can buy more licenses which…

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…

I just happened to be looking at an Excel conference agenda and noticed mention of an Office Javascript API. Just posting the related MSoft link for anyone who is curious. https://dev.office.com/reference/add-ins/javascript-api-for-office

I have app in vb.net that open session on accpac for take data from sql database then create an order in accpac the problem is : ex: for 100 data record the app creates 99 orders if I rerun app the missing order creates