Sage 100

New client approaching go live with v4.5. SO entry, item # lookup, client wants to display a calculated value of Qty on Hand - Qty on SO + Qty on PO in order to display multiple lines when search for descriptions with common words. This would give a look up of multiple items to choose from instead of looking at the items one at a time which will provide the desired information. It doesn't appear that the SO/PO information is available. Any thoughts? Script in an ALE?

What about passing the fields from inventory to SO and then do the calculation ? Don't have MAS to test so just a thought!

Sounds like it would have to be a header script before the line lookup. The output could be via a table in a minimal IE window with some logic to return the row clicked. I can only think of ugly ways to get the item code into the lines. If this is for who I think it is then the shear number of item warehouse rows to query - performance might point toward source programming change and not a script.

Create new UDFs in CI_Item - UDF_OH(You might be able to use total qty on Hand.) UDF_SO, UDF_PO - Then import regularly these values,then do your calculation in ALE. Or create UDF_Available and precalc your available qty during export or import. This is how I would do. If they had SQL version these UDFs could be updated every min or once an hour etc.

Do NOT trust the total qty on hand field - I know I had a case for a customer in 4.4 where Sage admitted that field was not correct, and I doubt it has been fixed since...we did something like what @JohnnyPabian suggests.

We did that and populated the UDF's in an update overnight.

Thanks for the options. Not sure the direction we'll go in yet.

For things of this nature, I've usually had to do a programming change to the ALE (create a Y level MD record). I am not aware of any easy answers to this. Also is this only for a particular warehouse code, or does it need to sum up all warehouse codes for the values?

Only one warehouse in the hunt