Sage 100

Does anyone know how to convert (either in explorer view or in a UDF) from either inches or feet into a ""feet & inches"" results? This is critical to the client.

So you would want an item with UM in inches to convert in a UDF to ""feet & inches"", correct? So if I enter quantity ""80"" this would convert to 6' 8"" ? Or if the UM is feet and I enter 6.75 this would convert to 6' 9""? If I am right, a script should get this done.

You are right on...wish I was up on my scripting :( Thanks Jon!

If I were making the calculation from inches to feet and inches in Excel, I would use the following formula: =INT(G3/12) & ""ft "" & MOD(G3,12) & "" in"". I don't know if you can do something similar in BIE or not. I would think this is possible with a script.

Patrick - I am looking forward to the 90Minds scripting class this weekend in Las Vegas. If you can wait, I will do this for you as my first project.

Sounds GREAT Jon...see you there.

Translating @ShawnSlavin's Excel to VB script is pretty straightforward: Function ConvertToFeet(inches) Dim feet, inchesLeft feet = inches \ 12 'Note the use of the backslash -- integer division inchesLeft = inches Mod 12 ConvertToFeet = feet & "" ft "" & inchesLeft & "" in"" End Function

@AaronClark - You are ALIVE!!!!! And well I trust???

Awesome, thanks @AaronClark

@JeffSchwenk - Alive and well, indeed. Sad that I won't be in Las Vegas with the rest of the group this week, but such is life. @PatrickAnson -- Glad to help.