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 […]

What is our month on Month Useage per item code?

Introduction I have been asked to provide monthly useage figures by item from Infor Syteline 8 to be used to analyse our current stock holding. The user want to be able to select the date ranges he is interested in analysing, and is not interested in miscellaneous issues. This wasn’t […]