I want to create a monitor that displays the number of manufacturing orders where the value for reported quantity is differing from manufactured quantity, data from M3.
The fields are MWOOPE.VOMAQT(or MWOHED.VHMAQT) and MWOHED.RAQA
I have tried to make a virtual field and get that in my report in a good way but the custom APIs does not allow me to use it in thequery or as a filet.
The workaround I can think of is to make an event that checks when the order is reported if there is a difference and sends that to the responsible user but I would prefer to not have this workaround.
Anyone got any ideas on how to solve or other workaround?