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…