Freight Query A/R Order?
i have a challenge and i need your help on how to achieve it.
I have created a business partner customer with the group "Agent", and i want to make a calculation on customers in the "Agent" group in the freight column in A/R Order.
I created a UDF and a UDT. i populated the UDT with the BP Group Name and code as shown below; and i linked the UDF to the UDT.
In A/R Order if the customer chosen is an Agent u indicate by choosing the agent in the UDF on the row level.
Now i want to calculate freight on "Agent" UDF chosen.
and i want the freight(LC) to be calculated as 0.15* Unit price. for each row that has agent UDF chosen.
that's my query but it does not work and i have assigned UDV to the freight to refresh regularly on Unit Price.
Urgent help on how to get this solve will be much appreciated.