Sage 100

I just upgraded from 2019 to 2022 Advanced. We are having problems with multiple users having their password changed by the system, this has even been happening to our company account. We get the message below. When I go to SY_USER the encrypted password…

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…

Sage 100 2022.1 Advanced I have a customer whose AP_CheckHistoryHeader file has grown to be very large. I suspect it may have to do with a large number of void checks being created during their process of writing checks. They manually swap between…

We are using Sage 100 Standard ERP 2013 (Version 5.00.4.0) / SAGE 100 ERP Issue detail: when I click on Work Order -> Work Order Transaction Entry (Snapshot 1) -> it asks for the date and once I enter the date and click OK -> I get an Update Interrupted…

when I try to rebuild the GL Summary Detail Drill Down file I get the following error, Error 107 Keyed file error (Wrong key Block addr) Program is SY_Rebuildfile_BUS PVC Statement is 2324 We are trying to rebuild this file because we cannot add a new…

Sage 100 2021 PU4 This did not happen in PU2. There is a knowledgebase article ( Solution ID: 112555); however, TimeCard is not installed and no records have a blank ModuleNumber$ field.

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

I see this on two new upgrades to v2021.1 Standard (both on SPC, but that may just be a co-incidence). Edit a Role and I get this prompt when saving: (SY_RoleApply.Y2) But this is what I "should" see: Similarly, with the Document Date warning…

Hey all. We are moving from Mas90 4.3 to Sage100 Cloud. Finally! Over the weekend, we made a backup of our entire Mas90 directory and uninstalled some shipping link software before moving data from all companies. Long story made short, we did not get…

I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

I have a client that has to rename these files several times each week. Aside from anti-virus or anti-malware programs corrupting these files, what else could cause this problem. The problem is Sage opens for about 1 second and then immediately closes…

Hello, We have an issue where an order is currently marked as an "Active Order" under Sales Order and Quote History, but this file is not accessible inside of Sales Order Entry. We get the message: "The Sales Order number already exists in the History…

Sage 100. Got the subject error. When viewing records using the File Display utility, I'm not noticing any bad date values records, but I haven't looked at all the records (264) What else in the BR_Transaction table may cause the error: Do all the…

I processed payroll but was about to print checks and my forms were not there, they seemed to be set back to default. It was strange. So I tried to copy them over from another company and I got the same results. So then I manually copied the ...MAS_XXX…

Hello, We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…

Hello, We are having stomething strange going on where 11 lines from an order are showing up in both the "Detail" and "History Detail" tables, but 3 are missing from the "Detail" table and are in the "History Detail" table. Any ideas? Apart from straight…

Sage 100 2018 PU6 Error 45 Program CI_COMMONPII.PVC Statement 277 Class GL_Bank_Svc Method GetDecryptedCols This error also occurs in Cash Receipts Entry and seems to occur anytime a bank code is referenced.

Hello, Our company MAS system has been running very slowly and I would like to delete some records form our database. There does not seem to be information on certain tables inside of SAGE under File Layouts and Program Information. Specifically, I…

Hello, Today I had someone want to delete a batch that was entered into A/R cash receipts entry. When I try to delete it, a pop up box says "Missing or Invalid Header," and I am not allowed to delete the batch. I have seen this error before while importing…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

I have a client who is need of some help. She had Geek Squad repair her computer and now her MAS90 has errors, a lot of Error 2 - is full. They occur in GL, AP, and PR modules in several companies when opening maintenance or inquiry windows. This is a…

We have a sales order that disappeared somehow; it was inadvertently deleted or not saved after entering, it's not clear which. When I went to re-enter the sales order, I'm being told that one item has none in stock, although all that were on the original…