Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Does the Connector support UNION Queries for Sage 100 Data?
Have a simple UNION that just doesn't seem to work. See sample below:
Select
JT_Transaction.SalesOrderNo as 'SalesOrderNo' ,
JT_Transaction.TotalCost+JT_Transaction.TotalLaborCost…
Hi All,
I want to setup a calculated field in explore that takes a package quantity UDF and divides the on-hand quantity by that to show the number of cases they have on hand. The hitch is that not all of the items have a pack size and some items have…