Dynamics Community Forum Thread Details

Updating CountryRegionId in TaxVatNumTable

I want to update country region Id's in TaxVatNumTable.

If the record doesnt already exists, it must be insterted.

I import the new values from a .csv file.

Here is my code. When I run the code, I get an error, that "The record already exists". But its just the VatNum that exists in the table is for another company.

        ttsBegin;

        while (file.status() == IO_Status::Ok && conLen(conRecord) > 0)
        {
            contactView.clear();
            counter++;
            Progress.incCount() ;
            nowHandling++;

            accountNum  = strLwr(conPeek(conRecord, 2));
             select forUpdate firstOnly RecId from tmpcustTable
                where tmpcustTable.AccountNum == accountNum;
               

                name        = conPeek(conRecord, 1); // Navn
                name        = strLRTrim(name);
                land        = conPeek(conRecord, 7); // Land
                tmpcustTable.VATNum            = conPeek(conRecord, 6);
                

                   if (!land)
                {
                    // Skal sættes (CountryRegionId) ellers fejl ved insert af adresser
                    land = 'DNK';
                }
                else
                {
                    logisticsAddressCountryRegion = LogisticsAddressCountryRegion::findByISOCode(land);
                    land = logisticsAddressCountryRegion.CountryRegionId;
                }

                if(tmpcustTable && tmpcustTable.VATNum != '')

                {
                  
                    select forUpdate taxVATNumTable where
                    taxVATNumTable.VATNum == tmpcustTable.VATNum &&
                    taxVATNumTable.Name == name;    
                    
                    if(taxVATNumTable)
                    {                        
                        taxVATNumTable.CountryRegionId = land;
                        taxVATNumTable.doupdate();
                        tmpcustTable.update();                 
                    }
                    else
                    {
                        taxVATNumTable.CountryRegionId = land;
                        taxVATNumTable.doInsert();
                    }
                    
                }
            
            conRecord = file.read();
        }
    }

    ttsCommit;

Quick Links

Leaderboard > Microsoft Dynamics AX (Archived)