Skip to main content

Notifications

Supply Chain Management forum
Unanswered

What is ValidTo Data field and how to handle it ?

Posted on by 345
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 223,394 Super User 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 345 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 223,394 Super User 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.
  • andreasraithel Profile Picture
    andreasraithel 4,465 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.
     

Helpful resources

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,394 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans