Sage 300

Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…

Hi everyone, I started using an AP automotation software by Beanworks which is tied to our Sage 300 system. When I view our tax authorities within the Beanworks environment, it shows some tax authorities as inactive but when I go to the tax authorities…

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…

Client migrating to new server, Winsows 2019 with Sage 300 2020. Existing server is Windows server 2008, running Sage 300 2016. On the old existing server, Sage uses Windows authentication for many users. On the new server, when I try to change the…

Is there a way to disable the forcing of capital letters in the PO no. field within order entry? We have a partner who sends us PO numbers that contain both capital and lowercase letters. When we transmit through EDI back to them the information is…

Hi, The OE shipment entry is not generating GL entries if the invoice tick box is unselected. If Invoice option got selected, then invoice entry and GL entries are being posted to respective modules. How do I set the system to allow to post the GL entry…

Our client runs Sage 300 Version 2016 and have multi locations where they sell from. They want Orders, Shipments and Invoices to have different prefixes as per the locations they are sold from. Is this achievable? All responses will be highly appreciated…

I deployed Sage 300 2016 Web Deployment and were able to login from client computers without "Enable Application Security" box being enabled in Database Setup Utility. However, after enabling this option, I started getting the warning message "Session…

I recorded a macro to import a file into sage300 - i start record (record all fields) - i go to the screen, file import, browse for a file say ok, import performs - stop record The goal is to add a pause at the file selection and allow the user…

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…

Can anyone explain to me what happened after an item 0001 merged into item 0002 ? What happened to item 0001 old receipt, PO etc? After clicking the POST button in Item Number Change, a message box pop up to ask back up database, is that normal? Thank…

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…