Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
While importing a job through VI for AP Invoices - if there are multiple lines on the same invoice, the job will not work correctly. Is there an easy fix to this. The invoice will either not show up in Invoice Data Entry or Sage will need to be prompted…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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?
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…
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…