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 / Small and medium business | Business Central, N... / Lead Time on PO - Calc...
Small and medium business | Business Central, N...
Suggested answer

Lead Time on PO - Calculation Direction

(2) ShareShare
ReportReport
Posted on by Juliem 355
Hi,
 
Where do we define if we want to use Forward Calculation instead of Backward when calculating dates from Lead Time on Purchase Order?
 
 
When entering a new PO line, the system uses backward calculation, back dating the order date of the line. Is there a way to use Foward Calculation automatically?
 
-Julie
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Juliem Profile Picture
    Juliem 355 on at
    Lead Time on PO - Calculation Direction
    Maybe my screenshot is misleading.
    The actual order date is 4/5/2025 on the header and requested receipt date is blank
    When I add the item on the line that has a 5D lead time, the system does a backward calculation of the line order date and sets it as 3/31/2025
    It doesn't do a forward calculation of the expected receipt date based on the order date
  • Suggested answer
    Alex A Profile Picture
    Alex A 2,590 on at
    Lead Time on PO - Calculation Direction
     
    Here is some more info to help:
     
     
    Field Name Description
    Requested Receipt Date The date you want the items delivered. If populated, triggers backward calculation.
    Expected Receipt Date System-calculated date based on Order Date + Lead Time (used in forward calculation if Requested Receipt Date is blank).
    Promised Receipt Date The date your vendor has committed to deliver the items.
    Planned Receipt Date Used in planning scenarios; may reflect expected supply timing from planning worksheets or requisitions.
  • Suggested answer
    Alex A Profile Picture
    Alex A 2,590 on at
    Lead Time on PO - Calculation Direction
    Hello,
     
    Thank you for the response.  In your example, the system is now calculating the Expected Receipt Date Forward from the Order Date.
     
    Order Date      Starting point for forward calculation
    Lead Time Calculation      Date formula (e.g., 1W, 6D) added to Order Date
    Expected Receipt Date      Result of Order Date + Lead Time
    Planned Receipt Date      Often matches Expected Receipt Date unless modified by planning parameters


    If you leave the Requested Receipt Date blank, Business Central doesn’t use it at all in the calculation. Instead, it shifts to forward calculation and uses the Expected Receipt Date:
    - Order Date as the starting point
    - Lead Time Calculation from the Item or Vendor Card
    - Resulting in a calculated Expected Receipt Date

    * They system basically says, "I don’t have a target receipt date, so I’ll start from the Order Date and add lead time forward." It is a little confusing because there are like 4 fields ending in "..Receipt Date".
     


    Regards,



    Please mark the answer if it helps.
     
  • Juliem Profile Picture
    Juliem 355 on at
    Lead Time on PO - Calculation Direction
    Requested Receipt Date is blank on both header and line.
    The system still calculates it backward after entering the item no.
    Cronus database, no custom extension
     
  • Suggested answer
    Alex A Profile Picture
    Alex A 2,590 on at
    Lead Time on PO - Calculation Direction
    The formula is used to calculate dates based on either the Requested Receipt Date (backward) or Order Date (forward), depending on which is populated.

    If you don’t enter a Requested Receipt Date, Business Central will calculate the Expected Receipt Date by adding lead time to the Order Date. This makes for the forward calculation. So, don't enter a Requested Receipt Date if you want forward logic to apply.

    Please mark the answer if it helps.

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 > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 4,197

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,673

#3
Sumit Singh Profile Picture

Sumit Singh 2,907

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans