Skip to Content

How to use DocDueDate (Delivary Date) in User Defined Values in SAP B1 9.2?.

Hi all,

How to use DocDueDate (Delivary Date) in User Defined Values

Actually my query works fine, but if I include the following in where clause T3.DocDueDate=(select $[OPOR.DocDueDate]) (T3 is ORDR table) it gives me the following error message

1).[Microsoft][SQL Server Native Client 10.0][SQL Server] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. "(WLS1)

I think the date format I have in delivary textbox 23/01/2017 does not match with DocDueDate in database.

How can I solve that the problem?

Please anyone can help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 23, 2017 at 12:06 PM

    Hi Rurangwa,

    Try this:

    T3.DocDueDate=(select $[OPOR.DocDueDate.DATE])

    Or just

    T3.DocDueDate= $[OPOR.DocDueDate.DATE]

    Hope it helps.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded