Technical and Installation Discussions

[JacquieP]

I am in need of placing the extended description from the inventory files into the BOM grid for visibility. Can anyone help me with the best way to handle this?

Also, I see that when we run any BOM report - if the BOM is an Engineered sub bill within the upper level, this sub bill does not print?

Is there a way to have the BOM INQ. screen have a printing option?

[zip]

I suppose one option is to import your Extended Descriptions into a UDF, and then add the UDF field to your grid.  This would be similar to how you used to have to do that in the I/M module in order to be able to search item Ext Desc's in a Lookup.

[jepritch]

I agree with Brett above, you could do this using and UDF and some scripting. 

1. Create a UDF on the BOM Detail table for the description

2. Create a post-validate script on the ComponentItemCode that retrieves the ExtendedDescriptionKey from the CI_Item table and looks that up using the CI_ExtendedDescription_svc object, and set the retrieved value into the UDF

3. Add your new UDF to your BOM Lines panel using Customizer.

Note: Keep in mind the extended description text field is quite large (4096), so make sure your UDF is a similar size or truncate the description if necessary.

Hope this helps.

Elliott