• ProvideX/NOMADS capability

    I'm new to these products and a bit intimidated by the extensive documentation. Before I waste a lot of time trying to make a change to a production system work correctly, I'd appreciate a simple answer: Is what I want to do possible with these products…
  • Sage 100 Customizer DMAIN and DMAINW

    When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry, there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…
  • Accessing UDT through SQL linked server

    I have successfully been able to create queries that can access the data in Sage but I am now trying to query data from a UDT and I am getting an error. Can anyone advise how to workaround or solve this error? This query runs fine: select * from …
  • UDT not showing in user-defined field and table maintenance

    I've got a UDT that isn't displaying in the list under user-defined field and table maintenance. It used to display but has since disappeared. I wonder if anyone knows some tricks to refresh the menu system? The table I'm looking for is called SY So…
  • Cannot get an Excel query to return updated information

    Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows…
  • M9-SO-1099 'On Demand' Sales Order Fill Report

    Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…
  • 100c Entry box "Settings" how to turn it on for employees?

    We have just switched to 100c. I, as administrator, can change to the new ribbon, themes, etc. When my employees try to use the "settings" at log in, it says: You do not have permission. Where is the security to turn this on? I have tried searching for…