Get newer BOM version from specific date

[pawelj795]

Hi,
I have 2 tables:

• Bill of Materials (BoM) 
• Pricelist of Components to this BoM's

Now, from a specific date (in my sample model is 07.06.2021) I want to change the BoM version from v1 to v2.

The business case of this model is to calculate production costs of specific products when the number of materials consumed in production is changing on a specific date.
Both tables are related only by components name.
How to do that?

Sample file

https://drive.google.com/file/d/1UfsJyGHXheKLFLHl1qBoj1z4Bc1I1Qkg/view?usp=sharing

[pawelj795]

.

[v-kelly-msft]

Hi  @pawelj795 ,

After checking,only qty for each components make changes from v1 to v2,right?

So what is your expected output?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!