Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / What is ValidTo Data f...
Supply chain | Supply Chain Management, Commerce
Unanswered

What is ValidTo Data field and how to handle it ?

(2) ShareShare
ReportReport
Posted on by Teevo 362
Hi all,
 
I'm duplicating Data entity VendVendorsV2, but not changing its structure data source. Currently I'm hit strange error, something like this:
 
Path: [AxDataEntityView/MyVendorV2Entity/Fields/ValidTo/DataField]:'LogisticsPostalAddressBaseEntity' field not specified.
 
If I search in the structure and found this table LogisticsPostalAddressBaseEntity are in the sub node of its data source:
 
With its property is :
But not too sure what to do about it. 
 
Can anyone give me some idea ?
Thanks
 
  • Martin Dráb Profile Picture
    Martin Dráb 230,235 Most Valuable Professional on at
    What is ValidTo Data field and how to handle it ?
    The purpose of date-effectivity with addresses is that you may need to know address that was valid at a particular time, e.g. in time of posting. If we simply overwrote the address, we would lose information about the previous address.
     
    Look at LogisticsPostalAddressBaseEntity once more; there indeed are ValidFrom and ValidTo fields.
  • Teevo Profile Picture
    Teevo 362 on at
    What is ValidTo Data field and how to handle it ?
    Hi,
     
    Been reading the whitepaper and documentation, unfortunately I cannot understand what it means. 
     
    Can I ask for some guidance ? Looking back at the original thread, because I didn't create new entity from scratch but duplicate it, what actually I'm missing and where to check ? In relate to the documentation, I can't find any field with named ValidFrom and ValidTo as per given example.
     
     
    Thanks.
  • Martin Dráb Profile Picture
    Martin Dráb 230,235 Most Valuable Professional on at
    What is ValidTo Data field and how to handle it ?
    Before designing a date-effective data entity, you need to understand date-effective tables. This whitepaper should help. Then you can see the documentation page about date-effictive entities.
  • andreasraithel Profile Picture
    andreasraithel 4,823 Super User 2024 Season 2 on at
    What is ValidTo Data field and how to handle it ?
     Hy,
     
    the LogisticsPostalAddress table holds the current address as well as all historical records.
    This means, every address change creates automatically a new line with the changed address and the ValidTo date is set /never/
    For the old address line the ValidTo is set to datetime of the change.
    So only one address at a time can be the valid one.
     
     
    Hope this helps.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans