Continued the modification in the application to get the correct location of the store with the same brand code and counter number with another store. Tested the modification made, though there are multiple conditions added, the result returning is still the same. discussed with Nina if there are any details that can be added in the data to determine and get the correct location, as per Nina, there is none, and when I sent the screenshot of the data again, she said that there is incorrect value encoded in the sales audit parser as there are multiple stores in location but there should be none multiple locations in a store, I had been advised that this will be confirmed with sales audit. I revert back to the changes in the application as the possible problem is on the data not on the application.