...
Available parameters
| Parameter | Description |
|---|---|
| @TodayParameterTodayParameter | Today's date. |
| @YesterdayParameterYesterdayParameter | Yesterday's date. |
| @ThisMonthStartParameterThisMonthStartParameter | The first day of the current month. |
| AddMonths('@LastMonthStartParameter', 1) | The End of the Current month. |
| @LastMonthStartParameterLastMonthStartParameter | The first day of the previous month. |
| @CurrentDateMinus7DaysParameterCurrentDateMinus7DaysParameter | The date 7 days ago. |
| @CurrentDateMinus14DaysParameterCurrentDateMinus14DaysParameter | The date 14 days ago. |
| @CurrentDateMinus30DaysParameterCurrentDateMinus30DaysParameter | The date 30 days ago. |
| @CurrentDateMinus60DaysParameterCurrentDateMinus60DaysParameter | The date 60 days ago. |
| @CurrentDateMinus90DaysParameterCurrentDateMinus90DaysParameter | The date 90 days ago. |
| @CurrentDateMinus120DaysParameterCurrentDateMinus120DaysParameter | The date 120 days ago. |
| @CurrentDateMinus6MonthsParameterCurrentDateMinus6MonthsParameter | The date 6 months ago. |
| @CurrentWorkstationIDParameterCurrentWorkstationIDParameter | The ID of the current workstation. |
| @CurrentSiteIdParameterCurrentSiteIdParameter | The ID of the current site. |
| @CurrentRegionNameParameterCurrentRegionNameParameter | The region name of the current site. |
| CurrentRoleNameParameter | The Role of the current user. |
| CurrentPeriodParameter | The current month. |
| LastPeriodParameter | Last month |
| CurrentFinancialYearParameter | The Current financial year |
| LastFinancialYearParameter | Last financial year |
| ThisQuarterStartPeriodParameter | This quarter start date |
| ThisQuarterEndPeriodParameter | This quarter End date |
| LastQuarterStartPeriodParameter | Last quarter start date |
| LastQuarterEndPeriodParameter | Last quarter End date |
| DeadStockDateParameter | |
| InactiveCustomerDateParameter | |
| LowGrossProfitPercentThresholdParameter | |
| HighGrossProfitPercentThresholdParameter | |
| BuyingGroupParameter |