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

Standard Safety Stock Calculation: how to find the data used for the calculation?

(4) ShareShare
ReportReport
Posted on by 109

Hi All,

I know that the system uses this formula

 

Safety Stock Formula
[ \text{Safety Stock} = (\text{Maximum Daily Usage} \times \text{Maximum Lead Time}) - (\text{Average Daily Usage} \times \text{Average Lead Time}) ]

 

Could you please clarify where the system sources the data for the formula?

For instance, regarding "Maximum Daily Usage"; "Average Daily Usage" and "Average Lead Time" where can I find these data? I would like to reach the tables where the data are written if possible

Is this data manually entered by users in specific fields of the database, or is it calculated automatically by the system?

Thank you in advance for your help.

Kind regards!

I have the same question (0)
  • Verified answer
    Mia Remme Profile Picture
    178 on at
    Hi, 
     
    Maximum daily usage and Average daily usage are system calculated fields based on historical transactions in a certain period of time. This is used in the calculations when using the Safety Stock journal  from Master planning module. The period of time is defined in the form when adding lines to the journal. 
     
     
    The Lead time is based on the user input from the lead time fields - Vendor trade agreements,  Default order settings or item specific lead time on the item coverage page. The lead time defined at a more specific level take precedence over those defined at a more general level. 
     
    Best regards,
    Mia
  • CS-30060915-0 Profile Picture
    2 on at
     
    we are trying to calculate the safety stock, but D365 only uses the leadtime that is set on the default order settings, which is 0.
    However the item has a leadtime in the trade agreements/purchase prices, which is also used for the MRP.
     
    There is no vendor populated in the item. Disregard leadtime in the purchase prices is set to no.
     
    Is there a way to get the safety stock calculation to use the leadtime from the purchase prices?
     
    Best regards
    Corinna
     
     

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 296

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 234 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 145 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans