Microsoft Dynamics AX (Archived)

Cannot Delete Addresses On LogisticsLocation

(0) Share

Report

Posted on by Gokhan B.

I try to delete addresses of Customers. And I wrote a job. But I encounter this error :

"Cannot delete a record in LogisticsPostalAddress.

The corresponding AOS validation failed."

Can you help me to about this issue?

My job source code is :

static void B4D_DeleteAddresses(Args _args)
{

    DirPartyPostalAddressView DirPartyPostalAddressView;
    CustTable custTable;
    str custTableNonDeleted;
    LogisticsLocation location;
    int i;
    ;

    ttsBegin;
    try{
        while select custTable


            {

                while select DirPartyPostalAddressView
                    where DirPartyPostalAddressView.Party == custTable.Party
                          && !DirPartyPostalAddressView.IsPrimary

                            {

                                location = LogisticsLocation::find(DirPartyPostalAddressView.Location,true);

                                 if(location.validateDelete())

                                        location.delete();
                             //   i++;
                            }

            }
    }
    catch(Exception::Error)
    {
       //custTableNonDeleted += custTable.AccountNum + "\n";
        info("Caught 'Exception::Error'.");
    }
   
    ttsCommit;
   // info(strFmt("Customer %1, deleted : %2 ", custTableNonDeleted, i));
}

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

most probably your address is being used anywhere, you can see a list of table inside postalAddressTableList(method) of LogisticsLocationEntity(Class)

AX validates if address record is being used, it will restrict you to proceed for deletion.

Was this reply helpful? Yes No
Gokhan B. 15 on at

Like (0)

Report

Thank you Sohaib. I fixed the problem.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Could you tell me how the problem solved

Was this reply helpful? Yes No
Gokhan B. 15 on at

Like (0)

Report

I put comment characters to postalAddressTableList(method) = /* method codes */

So this method was not executed. Because it was restrict ing me to proceed for deletion.

Was this reply helpful? Yes No
Suggested answer

nc_hwr 30 on at

Like (0)

Report

Expiring the record may be a better idea.

select forUpdate postalAddress where postalAddress.RecId == DirPartyPostalAddressView.PostalAddress;

postalAddress.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);
postalAddress.ValidTo = DateTimeUtil::addMinutes(DateTimeUtil::getSystemDateTime(), -2);
postalAddress.doUpdate();

Was this reply helpful? Yes No
RohanS 5 on at

Like (0)

Report

Hi,

I am also facing same issue. Can you please let me know what is the changes required?

Thanks,

Rohan

Was this reply helpful? Yes No