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?
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
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
#1
WarrenBelz
770
Most Valuable Professional
#2
stampcoin
494
#3
MS.Ragavendar
399
Share
Report
All responses (
Answers (
