ReleaseUpdateDB60_Bank.UpdateCashReceiptsLV Upgrade Script

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

Class	ReleaseUpdateDB60_Bank
Method	UpdateCashReceiptsLV
Description	Upgrades the script for the cash receipts table and related fields for Latvia.

Affected Modules and Tables

Affected Modules
Bank

Affected Tables
LedgerJournalTrans_Rcash
RCashTrans
LvCashReceiptTrans
LvCashReceiptTable

Remarks

The upgrade script is necessary due to the following changes in the data model from previous version. 1.The FK constraint has been changed from the BatchId field to the RefRecId field. 2. The LV specific fields have been moved from the ledgerJournalTrans table to the LedgerJournalTrans_RCash table.

Data Migration Section

From Table: LvCashReceiptTable	To Table: LedgerJournalTrans_RCash
RecId	LvCashReceiptTable

From Table: LvCashReceiptTable	To Table: RCashTrans
RecId	LvCashReceiptTable

From Table: LvCashReceiptTable	To Table: LvCashReceiptTrans
Recid	LvCashReceiptTable

From Table: HcmWorker	To Table: LvCashReceiptTrans
RecId	HcmWorker

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
LvCashReceiptTrans
LvCashReceiptTable