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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

Formula versions - validity dates

(1) ShareShare
ReportReport
Posted on by 93
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
    Microsoft Employee on at
    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
    3,668 on at
    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
    40 on at
    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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 1,072

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 214 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 131 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans