Sage 100

Hello. We are attempting to get two years of pay history out of Sage 100 as well as other employee information. I have attempted to use an Excel Query, but I really have no idea what I am doing. Where do I go to find an expert that knows how to retrieve…

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

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.

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…

Is it possible to subtract days from the current date? I'm trying to do an export from the AR_InvoiceHistoryHeader table, and I want this to be automated, and I don't want to export the entire table every time. I've tried things against the TransactionDate…

Greetings: I am attempting to export some data with TAB delimited fields. I have my job File Type setup for Delimiter and I have the Use ASCII Delim. box checked and for my delimiter I have attempted to use the ASCII code for horizontal tabs of 9 but…

After talking with Sage I know I am doing best practice with this. In my vi export for invoice history I am combining the taxable amount and the non-taxable amount. I have both fields pointed to the same col/pos "7" in my case but I don't know the syntax…

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 recently upgraded from Sage 100 4.4 Advanced (providex) to Sage 100 Premium (SQL). With this move, I lost the ability to export any legacy tables that are not housed on the SQL Framework. I am needing to export the data from SY_Console on a fairly…

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…

I am using Visual Integrator to export SalesOrderDetail.M4T out of sage in a csv format. The challenge i am facing is SalesORderDetail table has a column called as "CommentText" which contains a carriage returns in the data. I want to either get rid…

i got this error when i was trying to import from sage to excel "index was outside the bounds array" any help? thanks

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…

How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type. Tried checking / unchecking ASCII

My client is on Sage 100, 2014 Product update 7. Currently, I am trying to write a Crystal report for Bill of Materials. I need to have a field brought n that is the current bill or default bill for the bill of materials. I can pull the bill of materials…

Hi, I'm writing a query of my Version 4.5, I need a listing of TransactionType used in AR_TransactionPaymentHistory and what mathematical sign should be used with each in creating a report in Excel. I know about the following Transaction Types: I, P…

We were looking to clean up and standardize our misc item codes across our MAS companies. Our support group said you can't delete them if they had been used in the past, but we could switch "UseInPO" to N to hide them. I've built a VI job that seems…

Hi, I am developing website using Laravel frame work (PHP) which is invoice management system and we are giving facility to our customers to fetch Invoices/Contacts from their ERP. For sage, I have setup API based import system for Xero, Sage and Quick…

Any suggestions?

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…

Hello! I am having a problem importing records with Visual Integrator using the IM_PriceCode table. HELP! In the past, we have used this table to manually import customer pricing, basically uploading the CustomerNo, ItemCode, & Price directly into…