ReleaseUpdateTransformDB40_Ledger.updateReferencedCustInvoiceJour_BR Upgrade Script

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

Class

ReleaseUpdateTransformDB40_Ledger

Method

updateReferencedCustInvoiceJour_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: CustInvoiceJour

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