We are currently on SyteLine 8.03 and are working toward upgrading to Syteline 10(on prem). I have an external application that calls the IDO method DcmovePVb in the IDO SLDcmoves. This works fine in 8.03 but I cannot get it to work in SyteLine 10. It looks like a parameter was added (pPostDate) in SL10 and I have added the parameter to my call. The call to the method always returns “16” and the message “:Illegal content 'CHARINDEX' in filter: CHARINDEX(Stat, 'UPE') > 0 AND TransType = '1' AND TransNum > 0 And TransDate <= dbo.DayEndOf(N'20210812 10:27:17.299')”.
Looking at the code behind the IDO method, I can see this filter is being built in the method’s code and the return code 16 is coming from the method so I believe the method is being called but I have no idea why I’m getting the message about the filter. What am I doing wrong?
