Sage 300

I did a test install of Sage 300 V2024 on Windows 11, and loaded the SAMLTD database. I am unable to run macros - nothing happens when I click Run and select the macros (standard ones e.g. cashflow, getrates). I tried recording a simple macro to print…

The rates macro is putting up a runtime error 438, object doesn't support this property or method. They moved their server to a new location. No updates or changes otherwise. Any Advice? Dana

Is there a plan to get the sage 300 macros to run in 64 bit excel? If someone has them running in 64 bit, what was your solutions? I find the macros will only run in 32 bit and cannot get the out of box macros to run in 64 bit. Also Sage intelligence…

Our IT company has turned on 2 factor authentication and now Sage Alerts and Workflows is not able to send out e-mail notifications. Has anyone figured out a way around this? TIA

Sage 300 2021 PU5 Does anyone know if the default refresh rate can be changed on the Current Users UI? If so, where is the value stored? Also, why the heck can't this UI be filtered and/or sorted?! When you have 70 users and 25 entities it becomes…

I've been using Win Auth via the COM API for a number of years. It saves me having to store user+pass in services and integrations as I can pass in a blank username + password and it will connect using current win user. However, I've recently found that…

Hi, I'm trying to allow users to only run Macros without also giving permission to record or edit. In Administrative Services Security Authorizations (sage300.com) , for the "Maintain Macros" permission, it says " Allows users to record and edit macros…

We have a customer setup on Sage 300 2020 using Windows Authentication. Their windows user is {firstname}.{lastname}, so even though said user has the rights for credit approval, they are unable to type their username and password on an OE Credit Check…

Windows 2019 Server Sage 300 2020 PU3 Has anyone encountered issues running or editing Macros on Sage 300, when running directly on a server? When I try, its not opening or reporting any error at all. If I go into Options and click Security, that…

Hi, We noticed just yesterday that some of users were in the Other tab instead of the LanPak tab in the Current Users window. Although the system still works and the users can still access Sage when they were logged in oni the Other tab, what is the…

AccpacReport rpt = Program.session.ReportSelect("OEINV01[C://SAGE//Sage ERP 300//OE61A//ENG//GST-CHUANLEEHININVNEW3B.RPT]", " ", " "); AccpacPrintSetup rptPrintSetup = Program.session.GetPrintSetup(" ", " "); // the record show error AccpacPrintSetup…

I would like to make changes to the G/L Integration, Transactions, within the AP module and have the changes take effect from day one of using this module, as opposed to only having the change in effect moving forwards. Any macros that could be run to…

We have always linked our contract items to one job. Wondering if there is a way to set up / customize CN Module so that a Contract Item can be linked to multiple jobs?

I am running 2014 300ERP on VMware and experiencing performance drop if SQL Server and Application server are hosted on different physical machines. All virtual servers running Windows 2012 64bit and SQL is 2012. VMWare 6.0.0.All users are connecting…

incase of "error 49153" try to configure a new port in the firewall i.t start>allow a program through windows firewall>change setting>allow another program>then add sage accpac

Windows 10 Pro, running Sage 300 ERP 2014 PU3 Macros have been working fine for 3 weeks on brand new box, now today I go to run and I am getting crashes of A4WVBA.EXE Faulting application name: A4WVBA.EXE, version: 6.2.0.3, time stamp: 0x5522d494…

I used to run the cashflow.avb macro almost every month, but hadn't run it since our year end March 31. When I went to run it this week on my computer, I don't get any error messages, just a busy cursor for a few seconds and then nothing. I have gone…

I came across a blog post from 2013 that mentions that it is possible to run a sage macro without logging directly into sage using VBA, this could then be automated with task scheduler on windows here is the original blogpost from greytrix: http…

Does anyone have a good setup for prevailing wage calculation in Payroll for Washington State? The use of the Certified Pay table is challenging due to the fact that WA state does not provide a fringe rate.

Hi guys, I'm inserting new detail line for the existing Order. and I hit this error: Incorrect Procedure. Tax Group must be entered before inserting a detail line. Location, Item, Qty. Ordered, Price List, Expected Date, Unit Price, Tax Included, Tax…

We are integrating Sage 300 using the COM interface and want to prevent the COM interface being locked out of signing onto Sage when concurrent users have reached the max limit. We have 10 user licenses, and is it possible to somehow prevent more than…

Day-End will update your vendor costs based on the receipt costs from that day. Does anyone know if or how to stop that from happening? Currently we run a macro to Export the vendor tables, run day-end, then re import. Would be nice to simply avoid the…