We have a user in our Shipping area who can get into the data on the sales order with no problem by going through Sales Orders and drilling into the Customer Number and then Orders.
BUT, he needs to get to the Sales Order information a different way. In his job in shipping, he needs to get to the Sales Order through the AR Invoice so that he can populate the AR Invoice fields automatically. His process is to open up the AR Invoice, type in the customer number and tab to get the customer information populated. He then goes to the Sales Order button at the bottom of the AR Invoice screen, which opens all existing open orders in their account. He clicks on an order, hits the Choose button, hits the Finish button on the Draw Document window and clicks OK to the System Message window, and then all the information from the Sales Order populates the AR Invoice.
HERE'S THE REAL PROBLEM -- when he hits the Sales Order button on the AR Invoice screen in our "live" database, it will not show him the existing orders so he cannot populate the invoice. If he does the same thing in our "test" database (a copy of the database from the week before), the Sales Order button on the AR Invoice screen works perfectly and all the information populates the AR Invoice properly.
I've compared authorizations in both databases and they are exactly the same. Any ideas on what I'm missing?