Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

What is ValidTo Data field and how to handle it ?

(2) ShareShare
ReportReport
Posted on by 312
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
    233,896 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
    312 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
    233,896 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 tablesThis whitepaper should help. Then you can see the documentation page about date-effictive entities.
  • Andreas Raithel Profile Picture
    4,941 Super User 2025 Season 1 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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Zain Mehmood Profile Picture

Zain Mehmood 462 Moderator

#2
Danny Bilodeau Profile Picture

Danny Bilodeau 156 Moderator

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 120 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans