ActionField780

Beschrijving: Batch de-activate and activate Depreciation for ProcessFunctions. Custom: Nee

Propertiesbewerken

XMLbewerken

<Workflow Name="ActionField780" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Batch de-activate and activate Depreciation for ProcessFunctions.</Description>
	<Properties>
		<Property	Name="SetFirstDayOfMonth"	Type="Boolean"					Accessor="Optional"	Direction="In"		Default="True"	Comment="Set DepreciationStartDate to first day of month" />

		<Property	Name="ProcessFunctions"		Type="List[ProcessFunction]"	Accessor="Internal" />
	</Properties>
	<Execution>
		<UserContent Name="Pre" />

		<Transaction>
			<GetList Name="Get ProcessFunctions with DepreciationType method Linear" Type="ProcessFunction" OutputProperty="${ProcessFunctions}" OrderBy="Id" OrderDirection="Ascending">
				<Joins>
					<Join	Name="DepreciationMethodTax"	Alias="depmtax"	Type="InnerJoin" />
					<Join	Name="depmtax.DepreciationType"	Alias="deptype"	Type="InnerJoin" />
				</Joins>
				<Filters>
					<CombinedFilter FilterOperator="And">
						<PropertyFilter	PropertyName="DepreciationActivated"	Operator="="		PropertyValue="True" />
						<PropertyFilter	PropertyName="PurchasePrice"			Operator="&gt;"		PropertyValue="0" />
						<NotFilter>
							<PropertyEmptyFilter PropertyName="DepreciationStartDate" />
						</NotFilter>
						<PropertyFilter	PropertyName="deptype.Method"			Operator="="		PropertyValue="Linear" />
						<PropertyFilter	PropertyName="depmtax.Life"				Operator="&gt;"		PropertyValue="0" />
					</CombinedFilter>
				</Filters>
			</GetList>
		</Transaction>

		<ForEach Name="EachProcessFunction" In="${ProcessFunctions}" As="ProcessFunction">
			<WorkflowCall Name="Deactivate depreciation" WorkflowName="ProcessFunction_DeactivateDepreciation">
				<Parameter	Name="ProcessFunction"	Direction="In"		Value="${ProcessFunction}" />
			</WorkflowCall>

			<WorkflowCall Name="Activate depreciation" WorkflowName="ProcessFunction_ActivateDepreciation">
				<Parameter	Name="AskQuestionFirstDayMonth"	Direction="In"		Value="False" />
				<Parameter	Name="ProcessFunction"			Direction="In"		Value="${ProcessFunction}" />
				<Parameter	Name="SetFirstDayOfMonth"		Direction="In"		Value="${SetFirstDayOfMonth}" />
			</WorkflowCall>
		</ForEach>

		<Transaction>
			<GetList Name="Get ProcessFunctions with DepreciationType method LinearToResidualValue" Type="ProcessFunction" OutputProperty="${ProcessFunctions}" OrderBy="Id" OrderDirection="Ascending">
				<Joins>
					<Join	Name="DepreciationMethodTax"	Alias="depmtax"	Type="InnerJoin" />
					<Join	Name="depmtax.DepreciationType"	Alias="deptype"	Type="InnerJoin" />
				</Joins>
				<Filters>
					<CombinedFilter FilterOperator="And">
						<PropertyFilter	PropertyName="DepreciationActivated"	Operator="="		PropertyValue="True" />
						<PropertyFilter	PropertyName="PurchasePrice"			Operator="&gt;"		PropertyValue="0" />
						<NotFilter>
							<PropertyEmptyFilter PropertyName="DepreciationStartDate" />
						</NotFilter>
						<PropertyFilter	PropertyName="deptype.Method"			Operator="="		PropertyValue="LinearToResidualValue" />
						<PropertyFilter	PropertyName="ResidualValue"			Operator="&gt;"		PropertyValue="0" />
						<PropertyFilter	PropertyName="depmtax.Life"				Operator="&gt;"		PropertyValue="0" />
					</CombinedFilter>
				</Filters>
			</GetList>
		</Transaction>

		<ForEach Name="EachProcessFunction" In="${ProcessFunctions}" As="ProcessFunction">
			<WorkflowCall Name="Deactivate depreciation" WorkflowName="ProcessFunction_DeactivateDepreciation">
				<Parameter	Name="ProcessFunction"	Direction="In"		Value="${ProcessFunction}" />
			</WorkflowCall>

			<WorkflowCall Name="Activate depreciation" WorkflowName="ProcessFunction_ActivateDepreciation">
				<Parameter	Name="AskQuestionFirstDayMonth"	Direction="In"		Value="False" />
				<Parameter	Name="ProcessFunction"			Direction="In"		Value="${ProcessFunction}" />
				<Parameter	Name="SetFirstDayOfMonth"		Direction="In"		Value="${SetFirstDayOfMonth}" />
			</WorkflowCall>
		</ForEach>

		<Transaction>
			<GetList Name="Get ProcessFunctions with DepreciationType method Decreasing" Type="ProcessFunction" OutputProperty="${ProcessFunctions}" OrderBy="Id" OrderDirection="Ascending">
				<Joins>
					<Join	Name="DepreciationMethodTax"	Alias="depmtax"	Type="InnerJoin" />
					<Join	Name="depmtax.DepreciationType"	Alias="deptype"	Type="InnerJoin" />
				</Joins>
				<Filters>
					<CombinedFilter FilterOperator="And">
						<PropertyFilter	PropertyName="DepreciationActivated"		Operator="="		PropertyValue="True" />
						<PropertyFilter	PropertyName="PurchasePrice"				Operator="&gt;"		PropertyValue="0" />
						<NotFilter>
							<PropertyEmptyFilter PropertyName="DepreciationStartDate" />
						</NotFilter>
						<PropertyFilter	PropertyName="deptype.Method"				Operator="="		PropertyValue="Decreasing" />
						<PropertyFilter	PropertyName="ResidualValue"				Operator="&gt;"		PropertyValue="0" />
						<PropertyFilter	PropertyName="depmtax.PercentageDecreasing"	Operator="&gt;"		PropertyValue="0" />
						<NotFilter>
							<PropertyEmptyFilter PropertyName="depmtax.BookMethod" />
						</NotFilter>
					</CombinedFilter>
				</Filters>
			</GetList>
		</Transaction>

		<ForEach Name="EachProcessFunction" In="${ProcessFunctions}" As="ProcessFunction" Condition="${ProcessFunction.ResidualValue} &lt;= ${ProcessFunction.PurchasePrice}">
			<WorkflowCall Name="Deactivate depreciation" WorkflowName="ProcessFunction_DeactivateDepreciation">
				<Parameter	Name="ProcessFunction"	Direction="In"		Value="${ProcessFunction}" />
			</WorkflowCall>

			<WorkflowCall Name="Activate depreciation" WorkflowName="ProcessFunction_ActivateDepreciation">
				<Parameter	Name="AskQuestionFirstDayMonth"	Direction="In"		Value="False" />
				<Parameter	Name="ProcessFunction"			Direction="In"		Value="${ProcessFunction}" />
				<Parameter	Name="SetFirstDayOfMonth"		Direction="In"		Value="${SetFirstDayOfMonth}" />
			</WorkflowCall>
		</ForEach>

		<Transaction>
			<GetList Name="Get ProcessFunctions with DepreciationType method DecreasingToLinear" Type="ProcessFunction" OutputProperty="${ProcessFunctions}" OrderBy="Id" OrderDirection="Ascending">
				<Joins>
					<Join	Name="DepreciationMethodTax"	Alias="depmtax"	Type="InnerJoin" />
					<Join	Name="depmtax.DepreciationType"	Alias="deptype"	Type="InnerJoin" />
				</Joins>
				<Filters>
					<CombinedFilter FilterOperator="And">
						<PropertyFilter	PropertyName="DepreciationActivated"		Operator="="		PropertyValue="True" />
						<PropertyFilter	PropertyName="PurchasePrice"				Operator="&gt;"		PropertyValue="0" />
						<NotFilter>
							<PropertyEmptyFilter PropertyName="DepreciationStartDate" />
						</NotFilter>
						<PropertyFilter	PropertyName="deptype.Method"				Operator="="		PropertyValue="DecreasingToLinear" />
						<PropertyFilter	PropertyName="ResidualValue"				Operator="&gt;="	PropertyValue="0" />
						<PropertyFilter	PropertyName="depmtax.PercentageDecreasing"	Operator="&gt;"		PropertyValue="0" />
						<PropertyFilter	PropertyName="depmtax.PercentageLinear"		Operator="&gt;"		PropertyValue="0" />
						<NotFilter>
							<PropertyEmptyFilter PropertyName="depmtax.BookMethod" />
						</NotFilter>
					</CombinedFilter>
				</Filters>
			</GetList>
		</Transaction>

		<ForEach Name="EachProcessFunction" In="${ProcessFunctions}" As="ProcessFunction" Condition="${ProcessFunction.ResidualValue} &lt; ${ProcessFunction.PurchasePrice} &amp;&amp; ${ProcessFunction.DepreciationMethodTax.PercentageDecreasing} &gt; ${ProcessFunction.DepreciationMethodTax.PercentageLinear}">
			<WorkflowCall Name="Deactivate depreciation" WorkflowName="ProcessFunction_DeactivateDepreciation">
				<Parameter	Name="ProcessFunction"	Direction="In"		Value="${ProcessFunction}" />
			</WorkflowCall>

			<WorkflowCall Name="Activate depreciation" WorkflowName="ProcessFunction_ActivateDepreciation">
				<Parameter	Name="AskQuestionFirstDayMonth"	Direction="In"		Value="False" />
				<Parameter	Name="ProcessFunction"			Direction="In"		Value="${ProcessFunction}" />
				<Parameter	Name="SetFirstDayOfMonth"		Direction="In"		Value="${SetFirstDayOfMonth}" />
			</WorkflowCall>
		</ForEach>

		<UserContent Name="Post" />
	</Execution>
</Workflow>