How to do aggregation over a week of planned order and also release netting in RP

Summary:

Business is looking for Replenish Technician Trucks(Subinventory) based on Truck Types on specific Days in a week. The day in a week for picking up DC materials is pre decided.

Also, business required, combine historical usage of item relationships when setting planning levels for ‘new’ parts. Consider the ‘on-hand’ of both ‘Old’ and ‘new’ parts while calculating the Transfer Order of the new parts.

How to achieve to do aggregation over a week and also release netting (adjustment of planned order quantity of new items with the on hand of old items).

Content (please ensure you mask any confidential information):