We have a field setup on our SAP B1 system displaying the following detail...
The issue i have is that i would like to build a query but the results give me the numeric value of this field and not the text value...
For example, if i want to query all BPs that have a particular GroupCode of say Roofer and have a postcode that begins with BS11. I have the query setup and when i click the button to choose which GroupCode to use it just lists lots of numbers and then next to them the amount of records against each number. It doesnt tell me what the number means in a text value....
Any ideas on how i can show the value or even better would be to actually have a dropdown in my query so my users can select the text value they require rather than a start value, if that makes sense.
Thanks