I have a value list that shows customer names from the table customers and the list contains the same company name, but located in different areas. When I create an invoice using this value list it will show only one company name in one location and not all the companies with the same name in different locations.
I have the value list set to show the company name and the location. But it only shows unique values for the company names.
Any help is appreciated.