• Azure App Service Compatibility

    Our client is running Sage 300 Premium edition. They are planning to migrate to Azure. Can SAGE application run in Azure App Service
  • Suitable Azure VM

    Our client runs Sage 300 Premium edition version 2022. They want to migrate to Azure. What kind of Azure VM model is suitable for the SAGE application

    We sometimes create an OE before we have a PO with cost prices. Is there a way to update OE tables with cost prices once a PO is entered after?
  • Shipment Detail Lot Number. Record has been modified by another program

    Sage300 v6.2, Customer use v6.2 over 8 years ago. This message is the first time. Customer shipped Item with Lot in a Order Entry > Sales Order. Then, Customer want to clear shipment in Shipment Entry(before Invoice). There is 1 item with 2 lot…
  • FIrewall screen opening delay v2024

    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…
  • Item Valuation Report vs Count Sheet value

    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…
  • Sage 300 SDK field values not setting ONHOLD and PRIPERCENT

    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…
  • Is there any way to re-do the vault/store database setup?

    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.
  • cannot access database (error=40960) sage 300

    I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?
  • I upgraded from 2023 to 2024 SAGE 300 but when I tried to login on the web screen, it gave me below error

    when i try to logging via http locally, any help please
  • How To Export a Single Transfer in Inventory Control and Re-Import Using different Items

    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…
  • Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    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…
  • Running Sage 300 (2019) off cloud paging. Error=100 during Database Loading

    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…
  • Find Sage 300 table and field

    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…
  • Accpac 5.5a

    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.
  • Sage 300 Database on Azure SQL

    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…
  • Database error (operation=LOCATE, error=0).

    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 upgrade from 2021 to 2023 I got Error HRESULT E_FAIL has been returned from a call to a COM component.

    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 ?
  • Change Job Cost Code Format

    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!
  • Test System not showing expected data

    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…
  • Setting up Database for students at our university (trying to help our professor)

    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…
  • Database error (operation=REV-POST, error=229)

    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) ------…
  • Exclusion list for anti-virus software

    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…
  • Error

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