We have ran into an issue which we have never had before. When entering a cash receipt, after searching for a customer and selecting that customer (which appears in the list and shows as active), we receive an error that says "xxxx is not on file".
The customer is clearly created; it can be seen when searching for it. If using the arrow buttons in the customer inquiry, you can arrive at the customer and see the history, etc. However, when selecting the customer, we receive the error.
We use Sage 100 SQL. We have searched the tables to see if anything appears incorrect, but have not been able to find anything. The invoice for the customer was imported without issue. Has anyone had an error such as or have any suggestions how to correct it?