Expression to print Bin No. on BOM Works Order Document

kerryh

Hi

Could anyone help with an expression to print the stock item's bin number on a Works Order Document

I have an expression that is working fine on components but not where the item is a sub-assembly

Many Thanks
Kerry

2011-10-27_CH-Stammtisch_2.pdf

richardd

The bom files don't store the BIN location so you need to find it in the cstwh file. I wrote the expression below but in this example I only needed to look in the "WORK" warehouse. Hope this helps

iif(seek(left(ltrim(curBomWoDetail.Component),16)+"WORK","cstwh"),cstwh.cs_bin,"")