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…

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…

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…

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…

Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…

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…

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…

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 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…

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…

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…