Budget availability control - year to date check
I am new to this topic, is it possible to create an availability check like below :
1. Period 1 to 12, each month has available budget of $10.
2. Assume no budget consumption before, user raised a PR of $60 on period 7 (delivery date), system check available budget of period 1 to 7, total available is $70, so available check pass.
3. Another PR of $30 raised on period 5 (delivery date), system check available budget of period 1 to 5, total $50, but PR in period 7 already consumed $60 out of $70, so the maximum available for period 5 is $10, so availability check should be failed.