Sage 100

We use VI quite extensively and it works great. We use it to import many of our orders. After the VI jobs run, we open the sales order entry screen and enter the sales order number to do final editing and to print/email. Does anyone know how to add…

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 recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…

The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.

Hi All, I am trying to set the value of OrderDate while importing Sales order. Record imported successfully, but order date does not reflect in Sage100. It remains the same as previous order date. I don't know where I am wrong. Please help me. Do…

Sage 100 Version 5.20 Crystal 2011 for Sage Window server 2012 R2 Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…

Hi, I got this "The Records is not in editable state" Error while delete details from SO_SalesOrderDetail_bus object. Please anyone give hint to solve this issue. Given below is my code int TaskID = (int)oSS.GetType().InvokeMember("nLookupTask…

Hi, I have been trying to import new or exisiting sales order into SalesOrderHeader. However, when importing. i get these errors. it seems creating the new SO was fine. the only problem right now is the LotSerialNo.

We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…

I'm new to MAS, recently hired on to a company using MAS 200 4.40. I'm trying to utilize some of my experience with querying SQL databases to streamline work and am stumbling over how to avoid typing in my username and password to refresh my data in Excel…

Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…

We just upgraded to Sage 100 2017. Is there an easy way to delete warehouses?

Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…

Is Company ID from ODBC login available?

We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…

Hi, using Sage 100 Standard ERP 2014 I am writing a VI job to import a Customers Sales Orders, the source file is a CSV file, Loading into SO_SalesOrderHeader the field i am having trouble with is OrderDate The date on the CSV file comes across…

Hello! I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store. They were previously using MAS90 when we had first looked into it, but between that…

The line numbers are out of sequence on the SO picking list. For example, the first item listed list line 18, the next line 1, then line 19, then line 2, 20, 3, 4. Need some guidance on how to correct...........Thanks

After entering a sales order the line items that were entered are not the same in sales order history usually an item or several items are missing. This has happened several times. I have tried to sort and relink the data tables.

Has anyone had experience importing data into Sales Order Entry for a credit card order that has already been pre-authorized outside of Sage 100 ERP? In particular, we're working with Sage 100 ERP Advanced 2013 PU3 and an online store that uses a third…

I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…

Hello everyone, We have been using Sage 100 and it's earlier incarnations for over 20 years. Our data sets are quite large, especially sales and invoice history and inventory. What is the best practice, or what do you all do to maintain your data sets…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered. Is this normal? I can import…