• User is unable to print from Sage 2022

    A user of ours has recently been set up on a newly refurbished device. Device is on Windows 11 While logged into Sage 2022 they can drill down to specific location but when trying to print or preview the get the following alert "The database login…
  • input/output error SY_Session.pvc

    We are getting multiple occurrences of this error (multiple lines and multiple processes) on Windows 11 machines (like the Windows 10 posted linked below). I have research a lot of things but this keeps happening. Any assistance or ideas? Did the…
  • Sage 100 Information Center

    Is there a way to disable the information or other clickable links in Sage100? I have a client that does not have web browsers installed on their terminal server and users are clicking on the links and getting errors. They would like to prevent clicks…
  • Sage 2018 and Fixed Assets 2023

    Just upgraded Fixed Assets to 2023 for a client and they are still using Sage 2018 (in the process of upgrading to 2023 just waiting for a new server) and now they cannot print in Sage or in Fixed Assets. Getting this error. Report file C: ProgramData…
  • Sage 100 very slow over network

    We have Sage 100 Enterprise at the company I support. Performance directly on the host server is lightning fast, but on client PCs over the network it is painfully slow, especially when printing to paperless and opening Adobe Reader. I have followed every…
  • Location of UserUpdatedKey/UserCreatedKey and How SequenceNo is picked?

    Hi, I am looking at our backend tables and I am trying to determine what user did what. In our worktickets I see UserCreatedKey and UserUpdatedKey but I cannot find a table that links those to the employees table. I read that they might be stored…
  • Sage 100 Version confusion / upgrade needed for TLS1.2

    I'm reading that TLS1.2 is supported on 2021.4 or 2022.1 Going into About on the server (on-prem) the follow appears: Sage 100 Standard 2021 (Version 7.00.0.0) (Payroll Version 2.22.0.0) 32-bit, WebView2 Version 105.0.1343.27 Question: All the…
  • Sage 100 Customizer DMAIN and DMAINW

    When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry, there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…
  • Connection string for ODBC connection SOTAMAS90 with powerBi Gateway?

    I have seen some similar threads but none of them seem to work. Here is my situation, and bear with me I am very green with ODBC connections: I am wanting to connect to SOTAMAS90 through PowerBI gateway to get my data on a constant refresh. This would…
  • Modify report name on AR Custom Reports menu

    Is it possible to modify the name of a report that was added to our AR Custom Reports menu?
  • List of Tables and Fields for Sage 100 v2017

    Hi, I need to write a query to get the customized AP Open invoice report. In order to do so, I need to find out the reference documents of Sage 100 v2017 that provides a list of Tables and Fields. I searched the Sage City. There was an old thread…
  • setting up general ledger accounts

    Hello I am sorry if I am in the wrong section but, I am trying to set up a company and I chose contractor for the chart of accounts, but when I go to the maintenance account only I can only see the retained earnings account. how can I make the accounts…
  • Rebuild Key Files - Strange Issue?

    Greetings, We're in the process of upgrading our ancient Sage 4.50 to Sage 2018. Ran into a strange issue with regards to rebuilding the key files prior to migration. All the files were able to be rebuilt and optimized without any issue except for…
  • manuell structure database

    Hi; Please someone can help me ; i need a manuell of structure database SAGE 100 ; thnks!
  • Permissions working as intended?

    Hello, Our accounting department was trying to limit who has access to Vendor Maintenance, and instructed me to remove permissions for all users except for a select few. Unfortunately, when one user was trying to use "Receipt of Invoice Entry," and…
  • Access 2016 ODBC / Sage Issue

    Hello. We are having a bizarre issue with Microsoft Office 2016 and an ODBC connection to Sage 100 Advanced 2018 ERP. We use a system DSN to connect to Sage from Access to run queries and reports not available in Sage and have been doing this for years…
  • How to save order with credit card payment data via SData?

    Hello! I am trying to create an order completely with SData and Paya. I have no problems with it when I am trying to create an order with PaymentType = Check. Here is the XML for such example: <entry xmlns:atom=" ">http://www.w3.org/2005/Atom…
  • Error 20 Syntax Error on quick print of s/o trying to go to print window

    Converted sage 100 from 2016 to 2018. In 1 of 4 companies (of course the main company), quick print from sales order gives err 20 pointing to line 122 cm_uiscript.link. Last file is sy\sy_reportsetting.m4T. so_salesorderquickprint_ui.pvc If I check…
  • M9-SO-1099 'On Demand' Sales Order Fill Report

    Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…
  • Unable to Verify SMTP Connection -- GMAIL

    Good afternoon, I have searched all related topics and am still having issues with setting up paperless office emailing. I am using a GSUITE SMTP Relay. I have used Captcha to allow access to apps, as well as allowed access to less secure apps…
  • sData Create Sales Order Payload

    Hi There... I'm working on an ecommerce integration using sData ( and PHP ) and I'm having trouble trying to create a sales order. I'm getting a message " This Order has no lines and has zero total amounts " back from the server. I know the issue is…
  • How to enter search criteria for Blank Fields

    Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?
  • Connection Failure to host:[tcp]servername;port;NODELAY;STREAM

    Hello, We are currently running Sage 100 ERP (as application, not service) and have been having issues. Recently, the users are intermittently receiving an error stating: Unable to Connect to Server. The server "servername"is reachable, but it…
  • Valuation Report table empty

    Hi, I'm sorry if i am in the wrong place to raise my question... I need help with my report, trying to retrieve from MS SQL server. I need Valuation Report By Period. Where i found the table "IM_ValuationReportByPeriodWrk" in my database, but it is…