yanweiyuan3
2023-08-09 588bc7829387dfc761cc25f06f77d4c81818bd10
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Quintiq file version 2.0
#parent: #root
DeclarativeReferenceRelation CalcNettedForecast
{
  #keys: '1[151892.2.1029842722]'
  Expression:
  [*
    // select leaf forecast before product in higher level
    forecast := null( Forecast );
    if ( not this.MacroPlan().GlobalParameters_MP().IsNoNetting() and this.IsEligibleForNetting() )
    {
      sdips := selectset( this, 
                          PlanningSalesDemandInPeriod.ProductInStockingPointInPeriodPlanning.SalesDemandInPeriodBase, sdip, not sdip.IsPostponed() );
                           
      forecast := minselect( sdips, 
                             Elements.MasterSalesDemand.astype( Forecast ), 
                             f, f.SalesSegment_MP() = this.SalesSegment_MP(), -f.Product_MP().Level() );
      
      if ( exists( forecast, SalesDemandFulfillmentRestriction.FulfillmentRestriction.Product_MP, product, product = this.Product_MP() ))
      {
        forecast := null( Forecast );  
      }
    }  
    return forecast;
  *]
  Relation: NettedForecast
}