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.
The current SPM for v2020 (and v2021) both list compatibility with SQL 2017 CU "20 and earlier"...
...yet the current CU# is 23.
https://docs.microsoft.com/en-us/troubleshoot/sql/general/determine-version-edition-update-level
Is there a compatibility…
Curious if anyone knows when we are moving our data from Sage 2018 ProvideX Database to Sage 2020 SQL Database for some reason unknown 3 customers didn't carry over. We use Mapadoc and one of them customers is using that. Any ideas on what would cause…
I have a business partner account. And, I have setup sage SData and Sage ERP 100 on window server machine. I can access some resources in the browser like:
sage.lvh.me/.../ MyGreatLakes /AR_Customer
It returns a huge file of XML. My problem is…
Hope my Monday doesn't bite me.
I rebuilt some key files over the weekend.
A couple samples from the common info key rebuild log
Illegal characters have been found in the key. The record was not copied. The key read was P18569351 . Illegal characters…
Hi all,
I am looking for a document that lists a description of the columns in each table in the MS SQL server backend. I looked everywhere but not able to find any description of the columns.
I'm working on a test system and forgot to install the hot fix to prevent the IM_LotSerialTransactionHistory from taking a long time.
How long does it take to convert this table? I've been waiting for over 4 hours!
Will the table eventually convert…
link SO to WT .docx
I'm trying to find a file that contains the quantity on WorkTicket shown on the Sales Order line if exploded. see attached word doc for screen shot.
The SO detail file contains the work ticket number and the item number but not…
Hello,
I'm trying to populate a table with PO values when a UDF date value is assigned in order entry. I have a database trigger set to do this, which works when I use a generic update trigger that doesn't specify which column it's checking for for…
Does Sage 100 Vendor Maintenance have the ability to tie into the IRS TIN data base to verify a vendor's SSN or FED ID when setting up the vendor code in A/P?
Looking to have Sage Alerts and Workflow create a PO in Sage 100. It's my understanding that the Sage Alerts Workflow module has collection of API's that can update a database but Sage 100 Providex is difficult to write to and that Sage 100 does not have…
I'm using "sage 100 Standard 2019" and Version "6.10.0.0"
I tried to get "Item Maintenance details" from I nventory Management - > Item Maintenance .
I'm able to get 'Item code value' and 'Qty values(pl refer screenshot1)', but I need to get values…
Where I can find the work order header & material details in C# language?( help-sage100.na.sage.com/.../index.htm In which table I can find those?
Eg: For purchase order I fetch the details from PO_PurchaseOrder_bus. Where I can find the details of…
I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver. We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day.
Pulling FULL tables…
We run SAGE 100, and recently I purchased BizNet 5, but I also have BizNet 7 datasets - A/R, A/P and IM.
The BizNet tool works well when I am pulling general ledger information, but for our inventory, accounts receivable and accounts payable there…
Is there any record made to the database when a user has a sales order open? IE, Sage 100c SQL knows when a user has an order open, since another user cannot also open the same order... but is that information written to the DB or is it only a flag within…
Sage 100c 2018 SQL server
I want to add a database to my production Sage 100 Server instance. Will this cause any issues with Sage 100? I may also be able to use a linked server, but I'm not familiar with the limitations there, either.
Hello,
I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…
Asking for friend who just moved to Sage 100 Premium from Advanced and he has a question.
"I need to figure out how to get all of my SQL data (logs and data) to reside on the D: drive instead of the C: drive. If I make a backup company the C drive starts…
Good evening.
I have tried to create new companies and activate them in Sage 100 Premium.
Currently creating a new company does not add a new database.
Attempting to activate the company also fails
Attempting to copy a company to a new company…
Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system. We currently use MS Dynamics NAV. We switched…