• "[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…
  • 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…