Forum Discussion
pawelj795
5 years agoPost Prodigy
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
- pawelj795Post Prodigy
.
- v-kelly-msftCommunity 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!