Skip to main content
Dynamics 365 Community / Forums / Supply Chain Management forum / What is ValidTo Data f...
Supply Chain Management forum
Unanswered

What is ValidTo Data field and how to handle it ?

editSubscribe (2) ShareShare
ReportReport
Posted on by Teevo 318
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
 
Categories:
Development / Customization / SDK
Attachments
  • Martin Dráb Profile Picture
    Martin Dráb 223,025 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 318 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,025 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 tables. This whitepaper should help. Then you can see the documentation page about date-effictive entities.
  • andreasraithel Profile Picture
    andreasraithel 4,423 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

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Demystifying Copilot with Sundar Raghavan

Sundar explains how Copilot for Service is meant to function separately...

Business Process Guidance Badges and New…

The Microsoft Success by Design is the framework for implementing Dynamics 365…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 223,025 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans