ReleaseUpdateTransformDB40_Ledger.updateReferencedVendInvoiceJour_BR Upgrade Script

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

Class	ReleaseUpdateTransformDB40_Ledger
Method	updateReferencedVendInvoiceJour_BR
Description	This script is used for updating the referenced fiscal documents from customer invoices.
Script Type	Preprocessing 60: Live Pre-processing60: Delta
Ax Version	Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules
General ledger

Affected Tables
DEL_ReferencedFiscalDocJourUpgrade_BR
FiscalDocument_BR
FiscalDocumentReferenced_BR

Remarks

The script updates the <c>FiscalDocument_BR</c> table <c>ComplementedFiscalDocument</c> field and creates the <c>FiscalDocumentReferenced_BR</c> table records.

Data Migration Section

From Table: VendInvoiceJour	To Table: DEL_ReferencedFiscalDocJourUpgrade_BR
RecId	FiscalDocJourRecId
RecVersion	RecVersionId

From Table: FiscalDocument_BR	To Table: FiscalDocument_BR
RecId	ComplementedFiscalDocument

From Table: FiscalDocument_BR	To Table: FiscalDocumentReferenced_BR
RecId	FiscalDocument
RecId	ReferencedFiscalDocument

From Table: FiscalReference_BR	To Table: FiscalDocumentReferenced_BR
LegalTextId	FiscalDocumentSourceText

From Table: ExternalInvoiceInfo_BR	To Table: FiscalDocumentReferenced_BR
RecId	ExternalReferencedFiscalDocument

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
FiscalDocument_BR
FiscalDocumentReferenced_BR