E10: Custom grid - how to format sales order number

Yahoo Archive
1
Actually, I got the last part wrong.
We are populating data into UD38 and then displaying this data. The order number field is stored in Number01, which is of type decimal, which is likely the problem.
Any ideas?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 04, 2015 9:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Custom grid - how to format sales order number



Hi All,

In E9, we have a custom grid that we added to a screen that displays the sales order number in one of the fields.
I added code to the grid so that we can get the order number context menu when we right click it.
All works great in E9.

In E10, it still works but just before the called screen opens, say Order Tracker, we get this error:
Error accessing the database: Conversion failed when converting the varchar value '3169360.000000000' to data type int.

If I click ok on the error, the called screen opens and has the correct order loaded.

I’m not sure what I need to do to the grid so that the order number in this field does not have the trailing zeros.
Any ideas?

The grid is populated from data retrieved from a BAQ using the DynamicQuery BO.

[cid:ed96b5.png@cca2fd0f.4590c178]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>


[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Hi All,

In E9, we have a custom grid that we added to a screen that displays the sales order number in one of the fields.
I added code to the grid so that we can get the order number context menu when we right click it.
All works great in E9.

In E10, it still works but just before the called screen opens, say Order Tracker, we get this error:
Error accessing the database: Conversion failed when converting the varchar value '3169360.000000000' to data type int.

If I click ok on the error, the called screen opens and has the correct order loaded.

I’m not sure what I need to do to the grid so that the order number in this field does not have the trailing zeros.
Any ideas?

The grid is populated from data retrieved from a BAQ using the DynamicQuery BO.

[cid:ed96b5.png@cca2fd0f.4590c178]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>



[Non-text portions of this message have been removed]