Bin Location on Works Order

Alex Aherne

Hi all,

Happy New Year!

I am hoping that someone can help me to get the warehouse bin location (cstwh.cs_bin) of a component onto the works order report design. I can't seem to get the expression right to get this to work (if it will work!).

Many thanks,
Alex

Legacy Contributor

Hi Alex,
I had this problem before and used the following :

IIF(INDEXSEEK(it_stock+it_cwcode,.T.,"CSTWH","CSTWH1"),cstwh.cs_bin,"")

This worked fine for me,
Try it out and hopefully it will work fine for you too.

Regards,

Dermot.