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

    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…