Sage 100

Got this error message when printing sales order in was 90 v 3.22. Was able to "end" and print sales order. Error 262. Program SOZREB. Line 5305. I have no idea what this means. Any help?

Hello Sage Community, Todays question is how to find order(s) in shipping that I cant find! In the image below, I have the part in Shipping and cannot find it!! I've reviewed numerous orders and shipping batches that are not updated yet, they are nowhere…

Unable to update sales order module. In Mas 90, I Get Error Record M/CU is Missing from syoctl.soa. when I click on master console. I Also get errors unable to update sales order journal. A not on file customer has been encountered. and an invalid or…

Still having issues with incorrect data in IM. Items are on SO's but are not showing the correct quantities on the header tab under "On SO". Rebuilt sort files last night, not sure if I can try something else or do I need to report to SAGE? This item…

I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…

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…

Hi Guys So we recently upgraded to Sage 2023. Since the upgrade some users have being reporting that the Customer Last purchase history (Red Binoculars) is not populating for them on sales order. I first thought it might have been a permissions issue…

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…

Hi Support Community /Support Folks: Customer suffered a power fail 2 days ago, Windows 11 running on Dell Inspirion. Ran sfc /scannow and found and repaired system corruption. Ran Windows updates (Win 11 22H2) as well as Dell command updates..…

Our AP / Inventory person yesterday ran into this issue...old transactions suddenly appearing the the Daily Transaction Register. She alerted me of the issue and I have searched here and KB but not finding any answers: Also odd that the 10-31-22 transaction…

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…

Posting this in case it helps someone else. (Client is Premium, if it matters). After a lot of troubleshooting, a colleague confirmed the issue is that a vendor just alphabetically prior to the one in question had a French accented character in its…

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…

I just upgraded from Sage 2018 v6 to Sage 2022.1. My AR people are not able to run the AR Report now. The error message involves and error dealing with one customer. When I look at this customer, he has a lot of extraneous characters in his name. This…

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

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.

Hi Forum, Is there a function to Delete records from IM_ItemCost table ?. I cannot find anything to do that. Browse for examples and nothing comes up. Regards, Manuel Roman

Sage 100 2021 PU3 Advanced. After selecting vendor invoices for payment, then going into the check maintenance window, duplicate invoices display. However, the invoices are only entered / posted once. If the phantom invoice is not removed from the check…

We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog: When I click More…

Have a client running Sage 100 Standard 2021 PU2. A check prints for an open invoice, even though the invoice was not selected for payment. The check prints, but the invoice it paid does not show up on the stub. The invoice does not print on the Invoice…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

We are following Sage ticket instructions on correcting an aged transaction. Part of the instructions are below: In the File Name field, select the "..\ MAS90 \ MAS_xxx \ ARxxx \ AR_OpenInvoice.M4T " file and press the ENTER key Click Key…