Sage 100

1) For inventory, I'm trying to get the sum total of all inventory in warehouses where warehouse number in (100,200,300). Additionally, my formula for getting the inventory is: IM_ItemWarehouse.QuantityOnHand -IM_ItemWarehouse.QuantityOnPurchaseOrder…

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…

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…

Sentence two: "Clear this check box to include existing records" doesn't make sense for this field. v2020 and 2018, so it's probably been that way for a while. Can someone correct the above sentence in Help?

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…

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…

I'm trying to set up a report for an alert, after running an automated VI import. The customer (v2014 Premium) wants to know if there are any failed / invalid records. I know the data is available, because the UI can produce reports based on job results…

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…

Using VI to import into physical count. On serialized items, if I import a new serial number (did not previously exist in the system), the "frozen" qoh (which should be 0) is incorrect. If I had 3 new serial numbers for the same part, each new line shows…

we are on MAS100 5.1 using crystal reports 2011 for Sage. I have created a UDF field in Sales Order Detail called UDF_Customer_Item_No , i made this 15 char long as a String, control type multi line. we are using visual integrator to import orders…