ReleaseUpdateDB60_Cust.createTaxExchRateForSalesConfirmation Upgrade Script

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

Class

ReleaseUpdateDB60_Cust

Method

createTaxExchRateForSalesConfirmation

Description

Populates the SalesTaxTransactionExchangeRate table from the TaxJournalTrans table and the SalesParmTable table.

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

SalesTaxTransactionExchangeRate

Data Migration Section

From Table: TaxJournalTrans

To Table: SalesTaxTransactionExchangeRate

TransTableId

SourceTableId

TransRecId

SourceRecordId

Del_ExchRateSales_W

SalesTaxExchangeRate

From Table: SalesParmTable

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

TaxJournalTrans

Del_ExchRateSales_W