Skip to Content
0
Former Member
Nov 06, 2012 at 09:59 AM

Query showing number instead of name

481 Views

We have a couple of fields setup on our SAP B1 system for the following details...

  • GroupCode - This shows as a text value to determine the type of customer, Contractor, Roofer, Builder, Scaffolder, etc in our case.
  • Territory - This shows the geographical location based on our sales areas, midlands, scotland, south, europe etc.

The issue i have is that i would like to build a couple of queries but the select and the results give me the numeric value of this field and not the text value...

For example, if i want to query all roofers, 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....

This happens on both of these fields....

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