Announcements
Using a model driven app how would you lookup point in time data. For Example in an invoicing application, if you use a business rule to lookup the price of an item in inventory and set the price in the order line items table. Later when the price of the item changes how would you keep the price from changing in invoices that were created prior to the date of the price change?
The invoice lines that are added to the invoice are like a "snapshot" as long as "lock pricing" is set. Reference: https://docs.microsoft.com/en-us/dynamics365/sales-professional/create-invoices#lock-or-unlock-prices-of-an-invoice
I am using custom entities in CDS and model driven power-apps so dynamics 365 sales information does not apply,
Hi @Ca78 ,
Do you mean you want to get the entity record history?
My solution is to create a related entity to store many history to one record. each time you create or modify a record, also create a related record into the that entity, with modify date and creator column to record who edited what and when. Then you can lookup the invoice price at any point in time.
Sik
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
