Sage 100

We need an MRP report that is just a small subset of the entire 154 p. report and in a format more readily readable by our purchasing buyers. Using a silent connection string, I created a MSQuery table in Excel that brings in the filtered results of MRP…

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…

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…

I'm using Sage 100 Advanced 2017. I've been successful in coding a new MRP reporting solution for my business using the existing MP database files in Sage. One small but crucial bit of information I haven't found in the database is the actual creation…

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

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.

We are having an issue with non-existent inventory items in our Sales Orders occasionally showing up as a "-1" item, but they do exist. Our software support company looked into this a while back but was not able to resolve the issue. I am wondering…

I'm attempting to import MRP Demands for a client, but unlike the entry screens, the imports will not work without a customer number. They don't want a customer number related to the forecasted demand. Is there a workaround other than using an internal…