Discussions
How would you set up parent special item pricing to cascade down to all subcustomers?
How would you set up parent special item pricing to cascade down to all subcustomers?
I'm just not sure what the best way to set this up is or if someone has already accomplished it.
My idea is a two part SuiteScript:
Part 1 would be attached to the subcustomer records so if special item pricing is about to be changed an alert should pop up instead asking the user: "Please edit the parent's special pricing instead because it will carry over to all subcustomers. If you aren't redirected automatically, click here."
Part 2 would be triggered when a parent record is saved to run a search for all sub-customers, and delete, edit, and add any line items that don't match up with the parent record. This piece seems like it would take quite a while to run though, depending on how many subcustomers there are. Some of our parent records have hundreds of subcustomers (and subcustomers of subcustomers).