Currently it is not possible to link a table or a custom query to a field in an SQL report or in a UDT Handler.
You have a UDT with BP and Item details. In the UDT you have BP code and Name and ItemCode and Name. In the UDT handler (or SQL report) you want to have a choose from list to look up all Items and Business Partners to fill out one BP or Item. Besides that you want the names to be automatically filled when the code is choosen.
Currently you can only assign a formatted search to the column, this work but atomatic triggering (filling the name) doesn't work.
So it would be nice to have an option to assign a default table or custom query (in case you need a lookup to another UDT) to a field in a UDT handler or assign it to a column in a SQL report
Please sign in to leave a comment.