Sage 300

There is a site that behaves very oddly; new server and upgrade of Sage300 Server 2022 Std DC/SQL together (yeah I know security weakness - told I.T. when Private Firewall is On at server stations get green bar opening screen with error message…

Hi, I'm preparing for our annual inventory counts and having a valuation issue. When I run the Item Valuation report as of March 31st for a range of account sets and locations it gives me a total for each location. But when I generate the inventory…

Setup: C# Framework: .NET Framework 4.8 SDK: ACCPAC.Advantage Code Context: OpenView just initializes a session to the DB, there would be no issues behind this - it works just fine with everything. Important: No errors appear what so ever…

May i know is there anyway to re-do the vault/store database setup? I have a scenario that i need to change the credentials being used for vault/store? Thank you.

I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?

when i try to logging via http locally, any help please

I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation. What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…

Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…

Hello all, I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this. I'm a student, using cloudpaging…

I’m trying to determine what table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database. You get to it by clicking the Item/Tax button…

Hi, we currently are using AccPac 5.5a version and we would like to see what options we have to move to newer versions. We run a small business and AccPac 5.5a is perfect for us but do realize its time to upgrade. Currently our systems run on Windows…

Hi All, In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table. But there is no entries for 3, 4, 5 in AOM. Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH? Thanks.

Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet. I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…

Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…

After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen. What would be the reason of this and solution ?

Good morning, I'm trying to align our cost code with the 2014 AIA cost code format in Sage. Right now, it's formatted as xxxxx.xxx but I want it to be xx-xx-xx. Does anyone know how i can change this format? Thanks in advance!

I am trying to create a test system to I can run a test upgrade before I do it on the live server. Steps Taken: Created a new virtual server and installed server 2019 Installed a new dev SQL Server instance Did a backup of my test sys database…

Hi. We need help getting our database setup. I did some reading on it and even though I understand technical things pretty well I did not quite get it. As I mentioned in the title this is for a class we are taking in Computerized Accounting and we all…

We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…

I know this has been asked before, but a few years have gone by so I'm hoping there might be some updated thoughts on the subject. Client is preparing a new Sage app server, which will have FireEye virus protection. They know they need to exclude Sage…

Can't post a batch, it is showing you can't post to future date.

im getting the below error while trying to do multiple receipt Invoice. kindly help two errors all receipts in the multiple list must have the same number of source currency decimal places all receipts in the multiple list must have the same number…

A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed. sage 300 has detected module update inconsistencies that requires activation. The…

Hello Everyone, My company is considering moving their SAGE application to Azure and does not have an Azure subscription already, How do I perform a migration from On-Premise Server to an Azure Virtual Machine Is there a detailed step on Sage Software…

Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…