web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Formula versions - val...
Supply chain | Supply Chain Management, Commerce
Answered

Formula versions - validity dates

(1) ShareShare
ReportReport
Posted on by jwell22 83
Hello,
 
If an item has multiple formula versions, none of which have the Validity section filled in, but only one of these formula versions is active and approved, does this negate the need to fill in the Validity section? Specifically, can the /From date/ field be omitted?
 
 
I have the same question (0)
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Formula versions - validity dates
    Hi,
    If only one formula version is active and approved, and the others are not used, there may be less urgency in filling out the Validity. But when doing a version switch, it may be necessary to explicitly specify the effective date and time to ensure that the transition is orderly. The validity usually includes information about when a particular formula version takes effect (/From date/) and when it expires (/To date/). This ensures a clear record of when active formula versions were introduced. Multiple valid formula versions can only exist if the date range and "from" quantity do not overlap. This is the value of its existence.
    Best Regards,
    Hana
  • Verified answer
    ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    Formula versions - validity dates
    Correct, if only one formula version is active & approved, you can disregard the from / to date.  
     
    If you would like to have multiple active & approved formula versions, you can do so as long as they are unique combinations of:
     
    -From / To date (non overlapping)
    -From formula size
    -Site 
     
    This is useful if you have two different formulas based on batch size.  IE From formula size 1 is run on a smaller mixer, and from formula size 10,000 is run on a larger mixer that has a slightly different set of ingredients required.  
  • Nigel J Cox Profile Picture
    Nigel J Cox 40 on at
    Formula versions - validity dates
    Tiny, tiny warning, especially for Process industry. If you EVER want to create an order for less than 1.0 (I know it's unlikely), the order will have an empty Formula/BOM if the Activated from quantity is 1.0. I advise 0.0, which perhaps should be the default?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 947

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 248 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 176 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans