• 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
  • OE COST PRICES

    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…
  • RECSTATUS column in BKTRANH

    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.