ReleaseUpdateDB60_HRM.updateJobLimits Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB60_HRM

Method

updateJobLimits

Description

Migrates the job limits to the new signing limit model.

Affected Modules and Tables

Affected Modules

SRM

Affected Tables

HRPLimitParameters

HRPDefaultLimitRule

HRPDefaultLimitDetail

HRPDefaultLimitJobRule

Remarks

This method sets the authority basis to the Job value and the organization precedence to the Company value. Then, for each company, that is Data Area, which is not a virtual company, the system creates a policy of Signing Limit Policy type and maps to the policy.

For every signing limit policy that is created, the system creates two rules. The first rule will have a valid from date equal to the first date, which is the minimum date, from the HRPLimitDefaultTableRelationship table and the valid to date equal to one day less than the current date. The second rule will have the valid from date equal to current date and the valid to date equal to the maximum date. Every job in a company can have multiple default limit setup for the same limit type and document type during different date intervals. These jobs are copied to the two rules which were created earlier.

Data Migration Section

From Table: DEL_HRPLimitDefaultTableRelationship

To Table: HRPDefaultLimitDetail

DefaultValue

Amount

CurrencyCode

Currency

From Table: DEL_HRPLimitTypeTable

To Table: HRPDefaultLimitDetail

LimitType

LimitType

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HRPDefaultLimitDetail

HRPDefaultLimitRule

HRPDefaultLimitJobRule

HRPLimitParameters

Deleted Tables or Fields

Table

Field

DEL_HRPLimitTypeTable

DEL_HRPLimitDefaultTableRelationship