Price List at Sales Order header

Summary:

Business has a requirement where they attach the Price List at Ship to site level. We already tried many ways to achieve this and we couldn’t.

I was thinking what if I created two flexfield one at ship to site where you specify the price list for that ship to, and other at header level for the sales order. So, once you create the SO and enter the Customer, the system will query the site and automatically populate the header flexfield and then once we have the price list at header level of the SO do a logic (probably a groovy) so it will choose the price list that is in the strategy.