ReleaseUpdateDB60_Ledger.updateGDL_TH_EDT_Records Upgrade Script

  • Article

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.