Calculate order balance at specific time

[annanirvin]

Hi.

I have searched the community for days without finding what I need so now I hope for you guys 🙂

In order to deliver on time, we need to start order management no later than seven days after the order date. On the occasion of delays, I need to find out at what time (date or at least week) we are expected to start order processing on the seventh day (order date + 7). My data structure looks like this:

Balance

Date	Orderdate	Qty	Balance
2019-04-14	2019-03-26	44	44
2019-04-14	2019-03-27	766	810
2019-04-14	2019-03-28	680	1 490
2019-04-14	2019-03-29	622	2 112
2019-04-14	2019-03-30	91	2 203

Production capacity

Date	Capacity
2019-04-15	963
2019-04-16	1 246
2019-04-17	1 246
2019-04-18	1 246
2019-04-19	963

Expected new orders

Orderdate	Qty
2019-04-15	1 249
2019-04-16	1 186
2019-04-17	1 186
2019-04-18	1 249
2019-04-19	999

I really appreciate all the help I can get.