In converting to B1 9.0, I have encountered what appears to be a bug in the Print Layout Designer. The issue is with trying to access Branch and Department information via a DB field. It appears that SAP is trying to match the user code (ousr.internal_k) with the description field in the Branch (OUBR) or Department (OUDP) table. We are using SQL Server 2012.
Here is the error the SQL Sever throws:
This reads "Conversion failed when converting the nvarchar value 'Main Branch' to data type smallint"
Here is the setup in Print Layout Designer:
If I remove this field or change it to a different table, printing proceeds normally.
Is this a bug in 9.0 with SQL Server 2012? If so, are there any workarounds or patch levels where this is fixed?