Forum Discussion

pawelj795's avatar
pawelj795
Post Prodigy
5 years ago

Get newer BOM version from specific date

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

2 Replies

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support

      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!