Amount Limit across AP invoices to calculate Tax Exemption

Hi, 

We have a requirement for Tax Exemption on AP Invoice lines. 

1. We need to give Tax Exemption for specific Ship-To locations up to $100,000 limit for each ship-to location

2. The limit value should be calculated across invoices for the given ship-to location (within given legal entity)

3. If invoice lines are already processed up to 100,000, new invoice lines should not be exempted any more and tax has to be calculated with standard rate

We have explored existing options and we did not find any solution to calculate tax automatically.

Please let us know if you can think of any option

Thank you