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…

Hello everyone, How can I configure email on SAGE 300 under the company profile to invoke the a clients outlook such that also the sent statements are stored on the sent folder in the clients Outlook? I'm using SAGE 300 2022.

AP Check printing with missing alpha text. Noticed after upgrades to 2023PU1 and 2024PU1.

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

Hi all, I know this is a very specific question but I am using Sage 300 Intelligence and I have consolidated 3 entities into one report (all 3 listed under Database Consolidation List). Within this report I have built financial statements for all 3…

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…

Is Creating a Budget in General Ledger a useful tool or is it better to create the budgets in Excel and export the data from GL?

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 am looking for an excel template to import Sage 300 AR Receipts. Would anyone be willing to share one?

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 can currently change budgeted amounts in the "Budget Maintenance" window; however, I am wondering if I can do so in such a way that a record is kept of the changes and, ideally, a note can be left to explain the change. Does anyone know if this can…

I recently got new checks for payroll and they are not the same as our previous layout. How can i change the printing layout in Sage 300 PR?

Hi alll, I am trying to compile my module ID but having this error: makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found - Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…

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'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…

We require a National statement to be sent to the head office, but We need the statement for the national account to show all the branch invoices and payments on one statement. Please can you assist with the customized report.

Recently upgraded a client from Sage 2014 to 2023, several custom crystal report run ok but one gives an " Invalid agrument for Database" ? It runs ok on my laptop . I am thinking it has to do with the new ODBC driver 18 and/or the new 2019 MS-SQL but…