We have a field setup on our SAP B1 system for the following detail...
The issue i have is that i would like to build a query so the results give me the text value of this field and not the numeric value...
For example, I want to be able to run a query that i can choose from a dropdown of options to return all BPs that are in a particular territory. I would also like to be able to run this report to return all types excluding a particular territory
Thanks