ReleaseUpdateDB60_Ledger.updateGDL_TH_EDT_Records Upgrade Script

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

Class	ReleaseUpdateDB60_Ledger
Method	updateGDL_TH_EDT_Records
Description	Updates the Thai Withholding EDT relations with the RecId table-based relations.

Affected Modules and Tables

Affected Modules
General ledger

Affected Tables
LedgerJournalTrans
TaxWithholdItemGroupHeading_TH
TaxWithholdLedgerAccountGroup_TH
TaxWithholdOnItem_TH
TaxWithholdPeriodHead_TH
TaxWithholdReportPeriod_TH
TaxWithholdReportSetup_TH
TaxWithholdReportVoucher_TH
TaxWithholdRevenueTable_TH
TaxWithholdTable
TaxWithholdTrans

Remarks

Updates the TaxWithholdItemGroupHeading_TH field in the LedgerJournalTrans, TaxWithholdReportSetup_TH, taxWithholdOnItem_TH, and TaxWithholdTrans tables with the value from the RecId field of the TaxWithholdItemGroupHeading_TH table. Updates the TaxWithholdPeriodHead_TH field in the TaxWithholdReportPeriod_TH, TaxWithholdTrans, and taxWithholdTrans tables with the value from the RecId field of the TaxWithholdPeriodHead_TH table. Updates the TaxWithholdLedgerAccountGroup_TH field in the TaxWithholdTable table with the value from the RecId field of the TaxWithholdLedgerAccountGroup_TH table. Updates the TaxWithholdRevenueTable_TH field in the TaxWithholdItemGroupHeading_TH table with the value from the RecId field of the taxWithholdRevenueTable_TH table. Updates the CustAccount field in the TaxWithholdTrans table with the value from the del_CustAccount_TH field of the TaxWithholdTrans table. Before Microsoft Dynamics AX 2012 there could be the case that a record could be created for Thai and non-Thai customer. However, in the current version, the Thai withholding tax is limited to Thai legal entity,and there is no need for a Thai specific column.