'Effective:' can only be updated to today or a value in future in change tracking mode.

(0) Share

Report

Posted on by Alex Kaganov

455

I'm getting this error when trying to update a record in LogisticPostalAddress. Encountered it when using dirParty.createOrUpdatePostalAddress call but I confirmed the same behavior in a simple test job. The error happens within update call so I cannot trace it all the way through. Has anyone seen something similar?

Here's the job's code.

    LogisticsPostalAddress address =  LogisticsPostalAddress::findRecId(5637172374);
    ttsBegin;
    address.ZipCode = "45386";
    address.selectForUpdate(true);
    address.ValidFrom = DateTimeUtil::utcNow();
    address.ValidTo = DateTimeUtil::maxValue();
    address.validTimeStateUpdateMode(ValidTimeStateUpdate::CreateNewTimePeriod);
    address.update();
    ttsCommit;

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: 'Effective:' can only be updated to today or a value in future in change tracking mode.

Hello Alex

You cannot update both date fields at the same time.

This white paper may help you update date effective records such as in LogisticsPostalAddress table:

download.microsoft.com/.../Using_Date_Effective_Patterns_AX2012.pdf

Regards

Hans-Peter