Skip to Content
Former Member
May 21, 2014 at 05:02 PM

B1 9.0 Print Layout Bug


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?


pastedImage_1.png (37.9 kB)