ReleaseUpdateTransformDB40_Prod.validateProdGroup 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	ReleaseUpdateTransformDB40_Prod
Method	validateProdGroup
Description	Validates whether the account and dimension reference data is in place for the account and dimension fields in the table.
Script Type	Upgrade readiness scripts
Microsoft Dynamics AX Source	Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules
Production

Validation Issues
Validation Issues Description	Validates the AccountIssue field.
Checked Conditions	Verifies that the AccountIssue values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountIssueOffset field.
Checked Conditions	Verifies that the AccountIssueOffet values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountPicklist field.
Checked Conditions	Verifies that the AccountPicklist values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountPicklistOffset field.
Checked Conditions	Verifies that the AccountIssueOffet values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountReciept field.
Checked Conditions	Verifies that the AccountReciept values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountRecieptOffset field.
Checked Conditions	Verifies that the AccountRecieptOffset values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountReportFinished field.
Checked Conditions	Verifies that the AccountReportFinished values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountReportFinishedOffset field.
Checked Conditions	Verifies that the AccountReportFinishedOffset values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountWIPIssue field.
Checked Conditions	Verifies that the AccountWIPIssue values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountWIPValuation field.
Checked Conditions	Verifies that the AccountWIPValuation values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountWrkCtrIssue field.
Checked Conditions	Verifies that the AccountWrkCtrIssue values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.
Validation Issues Description	Validates the AccountWrkCtrIssueOffset field.
Checked Conditions	Verifies that the AccountWrkCtrIssueOffset values exist in the LedgerTable table.
Mitigation/How-to-fix	Create the corresponding LedgerTable record or update the reference in the ProdGroup table.