Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Planned Receipt Date isn't changing according to the new Lead Time Calculation

(1) ShareShare
ReportReport
Posted on by 9

*Planned Receipt Date isn't changing according to the new Lead Time Calculation parameter in Purchase Orders*

Hello!

I've bulk imported essential paramters like Lead Time Calculation , Safety Lead Time etc. of Items using Confguration Packages - Items.  However, I have problem in those existing Purchase Orders. Being specifically, the Planned Receipt Date isn't changing according to the new Lead Time Calculation parameter, it's just copying from the Promised Receit Date as if there is no Lead Time Calculation parameter.

By the way, those Purchase Orders were old documents created before my bulk import. To a certain extent, I am aware that system "protects" Receipt Date Columns of those "old" Purchase Orders somehow. But, I have to make those Receipt Date Columns of Purchase Orders change according to new Lead Time Calculation paramter. Once it works so, I will use them in Requistion Worksheet. 

With some settings somewhere, I should be able to choose whether Receipt Date Columns of those "old" Purchase Orders created before the bulk import should be affected by the new Lead Time Calculation, Safety Lead Time paramters etc. or not easily. 



What settings am I missing ? What should I do? Please help.

Additional info:

Lead Time Calcuation paramters of the items in the picture attached is 102D, Safety Lead Time is 30D.

I've encountered a similar problem in Purchase Orders before, and the Lead Time Calculation affected the Planned Receipt Date after we deleted the Location Code from the line and re-entered it. I tried this method but it didn't work this time however.

  • Jun Wang Profile Picture
    Jun Wang 7,440 Super User 2024 Season 2 on at
    Planned Receipt Date isn't changing according to the new Lead Time Calculation
    agree with Ben, the previous orders won't be affected by the new parameter. 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,995 Super User 2024 Season 2 on at
    Planned Receipt Date isn't changing according to the new Lead Time Calculation
    Ben is correct, changing master data such as item cards doesn't affect existing open documents, it only affects new documents. You have several options, manually change the purchase orders, delete and create new purchase orders, or as Ben mentioned get a developer to create a processing report to push the item card changes to the purchase orders. 
     
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,997 Super User 2024 Season 2 on at
    Planned Receipt Date isn't changing according to the new Lead Time Calculation
    The changes you make on an Item AFTER a Purchase Document is created will have NO impact on the existing documents.  The values on the Purchase Lines are validated at the time of entry.
     
    If you want to update your existing Purchase Documents based on the new values, you will need to write a batch (development) to re-validate specific fields on the Purchase Lines or Purchase Header to trigger the system pulling the new values from the Item records.
     
    If you are looking to test your new Lead Time Calculations (in a Sandbox Environment), you can use the Planning or Req. Worksheet, so when you change the Vendor No. on the worksheet line it will recalculate the Order Date based on the Due Date.  This is a great way to check your dates without having to create the Purchase Documents.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • gdrenteria Profile Picture
    gdrenteria 12,920 Most Valuable Professional on at
    Planned Receipt Date isn't changing according to the new Lead Time Calculation

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans