| Description |
1. Open Purchasing > 1099
2. Select any vendor on "Vendor From"
3. Select vendor on "Vendor To"
The error below occurs.
!pastedImage_d217139_0.png|height=155,width=570!
The script below works on SQL Server and 22.1 i21 version.
{noformat}SELECT
[Extent1].[intEntityId] AS [intEntityId],
[Extent1].[strName] AS [strName],
[Extent1].[intPaymentMethodId] AS [intPaymentMethodId],
[Extent1].[intGLAccountExpenseId] AS [intGLAccountExpenseId],
[Extent1].[intDefaultLocationId] AS [intDefaultLocationId],
[Extent1].[intDefaultContactId] AS [intDefaultContactId],
[Extent1].[strExpenseAccountId] AS [strExpenseAccountId],
[Extent1].[strVendorId] AS [strVendorId],
[Extent1].[ysnWithholding] AS [ysnWithholding],
[Extent1].[dblCreditLimit] AS [dblCreditLimit],
[Extent1].[strAddress] AS [strAddress],
[Extent1].[strCity] AS [strCity],
[Extent1].[strState] AS [strState],
[Extent1].[strZipCode] AS [strZipCode],
[Extent1].[intTermsId] AS [intTermsId],
[Extent1].[ysnHasPayables] AS [ysnHasPayables]
FROM [dbo].[vyuAPVendor] AS [Extent1]
WHERE [Extent1].[strVendorId] >= N'0000000002'
ORDER BY [Extent1].[strVendorId] ASC
OFFSET 0 ROWS FETCH NEXT 100 ROWS ONLY {noformat}
Found this StackOverflow that might help.
[https://stackoverflow.com/questions/24814278/how-to-implement-lessthan-etc-when-building-expressions-on-strings]
|