Sage 100

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…

I am having an issue where New/Open order pick sheets, are not printing when running large pick sheet batches. We have a small, pull pack and ship operation and can print anywhere from 50 to 250+ pick sheets a day and ship them out same day. When we do…

I haven't tried this with a brand new RMA, but I think this would also have issues working. When I go into an RMA and try to pick which lots are being returned, upon selecting the lot number, I get: Error 47 in program RAWDAI at line 1945. I know…

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…

We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…