Forum Discussion
pawelj795
Post Prodigy
5 years agoGet 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
- pawelj795
Post Prodigy
.
- 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,
KellyDid I answer your question? Mark my post as a solution!