How often have you updated the warehouse on an existing Sales Order or Purchase Order in Sage 100? How many times have you updated the Whse code on the header and forgotten to update the lines?
A while ago, a customer of ours who receives several hundred orders a day via EDI asked me where the setting was that would update the warehouse on all of the lines of a sales order to get updated whenever they change the warehouse on the sales order header.
Since there wasn’t a readily available solution, this is where scripting comes into play. We created a script that fires whenever a user changes the Whse on the SO Header and updates the Whse on all of the lines.
The example here is a Sales Order but the same concept works for Purchase Order.
When a user changes the Whse on the Header tab, they are prompted asking if they want to update the Whse Code on the Lines.
Once the user clicks Yes, the lines get updated with the new Whse Code.
If you have questions or would like more information, please contact us.