ReleaseUpdateDB60_Srm.initPOCreationRule Upgrade Script [AX 2012]

Updated: June 15, 2012

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

Class

ReleaseUpdateDB60_Srm

Method

initPOCreationRule

Description

Initializes records for PO creation related tables.

Affected Modules

SRM

Affected Tables

PurchReqSourcingPolicyRule

PurchReqSourcingSplitRule

PurchReqSourcingPriceToleranceRule

PurchReqSourcingHoldRule

PurchReqParameters

SysPolicyOrganization

SysPolicySequence

SysPolicyTypeSequence

SysPolicy

SysPolicyOrganization

Policy framework has been introduced in this release. This upgrade script inserts records into tables that are related to PO creation from purchase requisition. The data is being migrated primarily from the PurchReqParameters table and the script will also inserts records in policy framework tables if not found.

Table

Field

Extended Data Type

-or- Base Enum

PurchReqSourcingPolicyRule

IsBatchGenerationEnabled

NoYes

PurchReqSourcingPolicyRule

DefaultPurchaseRequisitionName

PurchReqName

PurchReqSourcingPolicyRule

ErrorOption

PurchReqPurchOrderGenerationErrorOption

PurchReqSourcingSplitRule

SplitByRequisitioner

NoYes

PurchReqSourcingSplitRule

SplitByLineType

NoYes

PurchReqSourcingSplitRule

SplitByProductCategory

NoYes

PurchReqSourcingSplitRule

PolicyRule

RefRecId

PurchReqSourcingPriceToleranceRule

EnablePriceTolerance

NoYes

PurchReqSourcingPriceToleranceRule

PercentageLimit

Percent

PurchReqSourcingPriceToleranceRule

AmountLimit

Amount

PurchReqSourcingPriceToleranceRule

PolicyRule

RefRecId

PurchReqSourcingPriceToleranceRule

EnableAmountLimit

NoYes

PurchReqSourcingPriceToleranceRule

EnablePercentageLimit

NoYes

PurchReqSourcingHoldRule

EnableHoldByPrePayment

NoYes

PurchReqSourcingHoldRule

EnableManualHold

PurchReqSourcingManualType

PurchReqSourcingHoldRule

EnableHoldByInternalCatalogItem

PurchReqSourcingCatalogItemHoldType

PurchReqSourcingHoldRule

EnableHoldByExternalCatalogItem

PurchReqSourcingCatalogItemHoldType

PurchReqSourcingHoldRule

EnableHoldByNonCatalogItem

PurchReqSourcingCatalogItemHoldType

PurchReqSourcingHoldRule

PolicyRule

RefRecId

Table

Field

PurchReqParameters

DEL_CatalogType

PurchReqParameters

DEL_ProductGroupIdCategory

PurchReqParameters

DEL_LockMultiples

PurchReqParameters

DEL_LockMinQty

PurchReqParameters

DEL_LockMaxQty

PurchReqParameters

DEL_ProductGroupId

PurchReqParameters

DEL_AutoCreatePurch


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: