• Can MRP Generation be scheduled to run automatically?

    The MRP module does not appear in the Task Scheduler Module drop-down list. We would like to schedule MRP Generation to run unattended nightly. Is it possible to do that? Thank you.
  • Ability to set minimum order quantities (MOQ) by vendor for items.

    Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…
  • "[ProvideX][ODBC Driver][FILEIO]No Data Found" when refreshing Microsoft Query results in Excel against table MP_04SuppliesAndDemands. Worked until recently.

    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…
  • Outsourced Jobs accounting in SAGE 100

    Hello SAGE ppl, We buy parts from vendor as 001 and that part for outside job and receive it as 002 - How can we account that in SAGE system? We are placing PO and receiving 001 part @ price X. Now we are placing PO and and receive the part 002 @…
  • Open PO Qty vs On PO qty discrepancy

    Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…
  • MRP Generation Date - Is it stored somewhere?

    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…
  • MRP Import

    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…
  • Phase out Inventory Item

    Items that we currently purchase are going to be "Discontinued" by the mfr. and we want to use up our inventory before we phase in the replacement part. How is this doable on MAS90?
  • MRP Generation from Sales Order Demands

    It seems that the MRP generation uses the sales order date as the required date for its calculations. It seems to me that the ship date or promise date from the sales order would be the correct thing to use. The sales order date we assume to be the date…