Infor Syteline

Syteline Customer Order Review TSQL COALESCE and FOR XML PATH

Introduction Here’s one that used a few interesting things, so I thought I’d post it. Our salesman wanted a report from our Infor Syteline 8 database that he can use to review order pattern by ship to. The example below makes use of 2 functions that are quite nice. The first […]

Syteline 8 Dataviews – Multiple IDOs

Introduction I ran into someone at the last Syteline User Group who asked the following …….. “We use some data views for forms like Job Materials and Job Operations, however they may be of some use to our customer service department as well. We wondered if there was a way […]