I'm using SAP B1 2007A. We recently added several International countries and their regions (states). We are having a problem with the state that appears on the Business Partner List (list that appears when you search using part of a company name or *). The query that gets the data does not take into consideration the Country where the state is located. The result is that the query returns the first state it finds based on the state code not the state associated with the country.
Is there a fix for this query or is there a way I can adjust the query to get the correct state results in the Business Partner List.
Thanks,
Mark