ReleaseUpdateDB60_Cust.createTaxExchRateForCustInvoiceJour Upgrade Script

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

Class

ReleaseUpdateDB60_Cust

Method

createTaxExchRateForCustInvoiceJour

Description

Populates the SalesTaxTransactionExchangeRate table from the CustInvoiceJour table and the TaxTrans table.

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

SalesTaxTransactionExchangeRate

Data Migration Section

From Table: CustInvoiceJour

To Table: SalesTaxTransactionExchangeRate

Del_ExchRate_W

SalesTaxExchangeRate

RecId

SourceRecordId

TableId

SourceTableId

From Table: TaxTrans

To Table: SalesTaxTransactionExchangeRate

VatDueDate_W

DateOfVATRegister

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

SalesTaxTransactionExchangeRate

Deleted Tables or Fields

Table

Field

CustInvoiceJour

Del_ExchRate_W