Sales Order Entry Issue in Employee Portal

phatdo

I have an issue in Employee Portal where the users are inputting in the incorrect shipping code. They usually just type the code into the field instead of the using the look up because they have a lot of orders to process. So when they are typing these codes in there is room for error and when they save the sales order it saves the incorrect shipping code. This causes a problem because the order gets sent to another system and that system does not understand the shipping code the users put in. Is there a way to make sure that when the user saves the sales order that it compares what is written in the field to the list of shipping codes and if it doesn't match it will then send an error message back to the user?

I'm running Navision 5.0 SP1 with WSS 3.0

Thanks!

dianepiper12

Our ship-to code field looks to the table. If it isnt in the table, the user gets an error message stating so.

"Ship-to Address".Code WHERE (Customer No.=FIELD(Sell-to Customer No.))

(this is the table relation code on the ship-to code field in the Sales Header table)