Skip to main content

Notifications

Business Central forum
Suggested answer

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

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 6,816 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 21,647 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,445 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 8,379 Super User 2024 Season 2 on at
    Planned Receipt Date isn't changing according to the new Lead Time Calculation

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans