Hi everyone,
Unfortunately, i could not find any similar or even far relevant examples on this area to suggest a start point on what LINQ C#.NET commands i can use or alter to suit my need.
so if any one interested on such issues, this is my solution, not perfect but will do the job and i think you will find it useful:
-
Create, and display an EbiNum box, with a different label name on that UI.
-
if you want, you can decompile the JobManager Contract assembly dll to find out how exactly the system calculate this value and what variable type it is, as i think it consider other factors for the qty availability not only the demand and the onhand as i want, however in my case i am happy to use the equation i stated on my post before which is ( Part Available Qty = Entire Part Demand - Entire Part On hand ) then i have run some test and checked the outcome results.
-
Check the Custom view displayed fileds (JMPartSum.OnHandQty and JMPartSum.DemandQty) and the system AvailQty on the UI Data tool, i found that both fields are reading from the PartWhse table
( i have called and test some of my parts on SQL as well):
-
set the properties of your new Displayed field as below to Bind it to a CallContext BPMData from the same type, and make it read only.
-
create a simple BPM pre-process method on job manager UI, and i have run the trace, done some quick test, and found that the best method to hook to is GetMatrix
which will cover my relevant actions which are:
-Entering and/or searching for Part No
-Changing Part no.
-and Refreshing the UI screen.
Note: there are other actions (system event buttons) will trigger this method but they have no effect on my field value.
the BPM will pass the results from the equation you want to the CallContextBPM parameter which bond to my displayed EpiNum box.
Note: i have put a condition to exclude minus figures.
HTH