Sage 100

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…

I'm looking for pointers on exporting data from Sage 100 into an Excel table with no page formatting. I can build queries to populate the required columns of information, but clicking the export button always renders a file with page header rows, page…