Sage 100

I am trying to use BOI to create orders. I am able to initiate a session on a server running the Advanced version of Sage 100, but not on a server running the Standard version. I thought I had to do some type of registration at first, but then I tried…

Hello, We just upgraded from an older version of MAS 90 / Providex to Sage 2023 100 Premium. It appears that all of the NULL values in our company tables have been converted to empty data, with the exception maybe of the date fields. This is causing…

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…

Moving from the Progress DB to SQL Server version discount percentage type columns are decimal(7,3) but in the old version it is decimal(8,3). Also a lot of other decimal columns went from (16,6) to (15,6). How have people handled this? It is breaking…

Hoping someone can help. Couldn't find much online and the online resource file layout mentioned the code but no definition on what this code represents. Since upgrading to Sage 100 2022 I am seeing JI codes in inventory transaction history. Those codes…

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

2019 Advanced - Sales order history detail has extended into a second partition and MS Access now gets the message "Cannot open Database" when trying to link or import the table. It may not be a database that your application recognizes, or the file…

In Vendor Pricing Maint. there is field called "Pricing Method" What table is this field in and what is the field name under the covers? Thanks

Posting this to help others in the same situation. The client system had a 3rd party modification to their SQL databases (by FYISoft / Renovo), adding table level SQL triggers that became broken with the migration (since the new SQL instance didn't have…

Where can I get a cross reference table from the files/tables in V2019 to map to V2022 fields Thanks

Hello. We are looking to upgrade from Advanced to premium primarily because of the need for external reporting from "3rd Party" tools. These tools require SQL server access to be able to PULL data from Sage running SQL. We have read where the SQL server…

Hello, I am trying to clean up our Sage database and wanting to delete old salespersons. I understand you are not able to delete salespersons with history. Is there a way around this? I do not want to have our Sales Support Staff having to scroll down…

Hi, I know SequenceNo counts up if a duplicate record is generated on the same day but I am not sure what fields exactly need to be used. Is it just SalesOrderNo, WTNumber, WTStep, RecordType, and TransactionDate? Or is it the rest of the fields as…

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…

During the migration process, the following error appears. Parallel Migration Wizard - InstallShield Wizard Error execute: Select ServerProperty('ProductVersion') As Product Version. After clicking on the OK button. This error appears: SQL Server…

Has anyone copied the BM_Header and BM_Detail files from one company to another company? Just curious if there are reasons not to try this. We do not need any history, just the bill of materials master files.

I tried reinstalling Sage 100 v 16.5. After installing I tried opening Sage commercial and Sage accounting. This message appears: unable to connect to PupilPath sql server [5] What is the problem?

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…

We were needing to have Microsoft reporting services (SSRS) on the same server as Sage 100, but as sage uses the sql database, and has (I believe?) Crystal Reports built in, would there be any issue installing the SQL Server Reporting Services onto the…

Is it possible in Data Agent Server 5.1 (Global Software) to send reports to multiple email address depending on their buyer code? Pretty sure no one uses this software anymore but maybe some has figured this out. I was thinking that a SQL expression…

I am a contract web developer and currently have a painting company asking if I could create a web app that automatically pulls and manipulate data from their database. I went to a meeting with them and realized that they use a program called “sage 100…

I found a SQLite3 OLE wrapper that might be useful with VBScript BOI scripts when MS Access and OLE DB isn't an option, SQLite is free and open source. I used a VB6 demo that came with the control to populate a test.db. This is an example of reading…

Hello! We have an A/R Aging report in Sage intelligence reporting and now I'm trying to add the MemoText in the AR_InvoiceHistoryMemo table where MemoCode = "COLLECTION". Below are my statements, but the report still doesn't only pull the MemoText…

Sage Premium version 2020 Reinitialize Datafiles utility I get the above message/problem when trying to reinitialize any AP or AR data files. I don't get the message when reinitializing IM, PO and SO files. So when this message pops up I have to…

I am a contract web developer and currently have a painting company asking if I could create a web app that automatically pulls and manipulate data from their database. I went to a meeting with them and realized that they use a program called “sage 100…