ReleaseUpdateTransformDB50_Vend.validateVendInvoiceTrans_Jour 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 |
ReleaseUpdateTransformDB50_Vend |
Method |
validateVendInvoiceTrans_Jour |
Description |
Validates the relation between the VendInvoiceTrans and VendInvoiceJour table. |
Script Type |
Upgrade readiness scripts |
Ax Version |
Microsoft Dynamics AX 2009 |
Affected Modules and Tables
Affected Modules |
|---|
Accounts payable |
|
Validation Issues | |
|---|---|
|
Validation Issues Description |
Some of the VendInvoiceTrans records do not link to the VendInvoiceJour records. |
|
Checked Conditions |
vendInvoiceJour.InvoiceId== vendInvoiceTrans.InvoiceId && vendInvoiceJour.InvoiceDate == vendInvoiceTrans.InvoiceDate && vendInvoiceJour.numberSequenceGroup == vendInvoiceTrans.numberSequenceGroup && vendInvoiceJour.InternalInvoiceId == vendInvoiceTrans.InternalInvoiceId && vendInvoiceJour.PurchId == vendInvoiceTrans.PurchId |
|
Mitigation/How-to-fix |
Make sure the VendInvoiceTrans records do belong to the VendInvoiceJour records. |