ReleaseUpdateDB60_Srm.initPOCreationRule 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_Srm |
Method |
initPOCreationRule |
Description |
Initializes records for PO creation related tables. |
Affected Modules and Tables
Affected Modules |
|---|
SRM |
Affected Tables |
|---|
PurchReqSourcingPolicyRule |
PurchReqSourcingSplitRule |
PurchReqSourcingPriceToleranceRule |
PurchReqSourcingHoldRule |
PurchReqParameters |
SysPolicyOrganization |
SysPolicySequence |
SysPolicyTypeSequence |
SysPolicy |
SysPolicyOrganization |
Remarks
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.
New Tables or Fields
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 |
Deleted Tables or Fields
Table |
Field |
|---|---|
PurchReqParameters |
DEL_CatalogType |
PurchReqParameters |
DEL_ProductGroupIdCategory |
PurchReqParameters |
DEL_LockMultiples |
PurchReqParameters |
DEL_LockMinQty |
PurchReqParameters |
DEL_LockMaxQty |
PurchReqParameters |
DEL_ProductGroupId |
PurchReqParameters |
DEL_AutoCreatePurch |