Need Help With Netui Browse

Firstly - I am a complete novice but I have managed to build a few browses within NETUI.
I have done some simple calculations which have workled but now need to create some more complex logic.
Essentially what I want to do is to find the quantity (and sum) that has been receipted against a work order (for a specific part/batch combination).
I have joined all the tables wo_mstr / wod_det & tr_hist
I have linked the tables by part and batch.
Now I would like to display the tr_qty_chg where tr_type = RCT-WO and of course for that part/batch.
There isn't a lot of QAD information on this.
I see reference to pre and post processor commands but I'm not sure if this is what I need.
Can anyone help?
 
Last edited:

Pechadre

Member
Hello,
First, don't use pre and post processor commands for this.
For this, i use "Insert Calculed Field".
This an example :
In expression there is : fxx-xmp11(ca_domain, ca_eu_nbr)
In Local put :
function fxx-xmp11 returns character (input ip_domain as character, input ip_adr as character ).
find first ad_mstr where ad_domain = ip_domain and ad_addr = ip_adr no-lock no-error.
if available ad_mstr then return ad_zip.
else return "".
end.
You change this function by a search on tr_hist table and if tr_type = "RCT-WO" then return tr_qty_chg else return 0.
Be careful, your function must returns a decimal, not a character likes example.

Best regards.
 
Top