Sage 300

I recently inherited a client who is using many macros in their environment. Some of these macros are used in place of the standard Order Entry and Shipment forms. Everything works fine in their current environment which is Sage 300 2021. Recently I installed…

I used a VBS script to login to Sage300 with task scheduler this technique has worked for many sites and many years Client went to Azure hosting and now...... this line: Set Signon = CreateObject("A4wSignonMgr.AccpacSignonMgr") Makes this :…

Anyone have clients using the GetRates macro and having an issue with the website it pulls the data from? It appears the default fx.sauder.ubc.ca site as been down for a few days. Does anyone have an alternate site we can replace it with?

I have Windows Service which read some data from database then run macros to generate some reports as pdf files automatically (statement of account, Customer Aging....), when I run the service as "local system" the service can read the data from database…

Hi all, I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…

I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…

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…

We're printing a custom report (PJC) built using Crystal Report 16 and running Sage300 Premium v7.0 2023 How can we resolve the error below?

This is hopefully a simple request. Trying to use the stock APLETT01.rpt form and have it filter out all "inactive" vendors. Focusing on the {APVEN.SWACTV}=1 field as a record selection but cannot get it to filter. I assume it has to do with the APSLVEN…

Hello community, On SAGE 300, there is a way to have a "PAY NOW" button directly on the invoices sent as pdf to customer by email. Then when the customer click on it, he got redirected to a secured web portal transiting between Sage money and third…

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…

Does anyone know if this program is capable of inserting a signature on a cheque? if so how? If not what do others use to do this?

Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…

I am trying to have a calculated cost - ie. Ic most recent * 1.8 rounded up to the next 100. Say I get 2445 that would print 2500 and then I am trying to substruct 1.00 from 2500 to get a new sales price of 2499. I am using two formulas one to get the…

I've added the DataSource Control and FEC control to my Form ok. My COMAPI session is working fine. I'm running into a couple of issues getting the FEC working. I'm getting the following error trying to set the DataSource control to active. Also I…

I can't find any functionality for coding a specific period from 1 year ago in a fixed 12 month financial. I've got multiple columns set-up with FRAMTA ("NET1P"), NET2P, etc. and I want to add the same period from 1 year ago. All I can find is formulas…

I have a client that i upgraded from Sage 300 v2014 to Sage 300 v2022. They have some macros where some of them needed some minor changes. One of them prints a bunch of forms and they print them to different trays of the printer based on a screen selection…

I need to add a summary section to my invoice report with the value of the invoice from the previous year (if there is one). I plan on storing the batch number for the previous years invoices in the invoice optional fields. Here’s my formula to get…

If you have to print multiple instances of a (seemingly any) form (with different parameters, order number, invoice number) using the COM AccpacReport and AccpacReportSetup types they leak a lot of memory. In the space of 200 iterations there is about…

Hi Team Is possible to create a QRCode with (check number, date, customer name and amount) information to make it easy to index and store in a document management system? Any idea ? Melvin

Getting below error when calling API for AR module. The 2 config files are enabled ( https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/110205/unable-to-make-a-get-call-using-sage-300-web-api ) and in Sage 300 USER…

Hi, I need some help figuring this one out. I am trying to automatically export I/C Internal Usage reports from Sage 300 using a C# console app. I have recorded a macro in Sage 300 and have used the macro to successfully export the report to PDF.…

Hi, I was asked to create a custom service that will do the following: 1. Get Purchase Orders based on specific criteria 2. Export each Purchase Order using the standard Crystal Report file to a PDF document Getting the purchase orders is…

Hi, I've been working on a solution where we invoke BICore.exe (through PS and/or Batch script, tried both). When BICore is run, the workflow creates a report and sends an email and works perfectly when I run the script manually. Process lasts around…

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); …