Dates in Planning Worksheets

(1) Share

Report

Posted on by Yael Suarez

119

Hello Experts, first of all, thank you very much for reading my question.
I have a functional question about how the planning sheet works in the due date fields. Below I explain my scenario.

I run the Planning Sheet and it correctly shows me the expiration date, which are the 3 dates where I need to have production of that product.

The issue is that when I go to see the components of the line there, the expiration date is the last day of the current year.

In summary, the dates and quantities of the product are correct in the planning sheet, but in the list of components, how can I modify the expiration date to the year 2024 as shown in the planning sheet or do I know why at the level of components remains until the last day of the current year

Thank you very much for taking the time and for sharing your knowledge.

Good day

All responses (2)

Answers (1)

Yael Suarez 119 on at

Like (0)

Report

Dates in Planning Worksheets

Hello, thank you very much for taking the time to read and share knowledge with me.
I verified that information and we do not have a security time configuration.
I show you how I have the configuration:

I share a little of the steps I follow to see the components:

Here everything is correct, I get the 3 lines that I expect and on the correct dates

But when I go to the components of a line that is from next year, the expiration date remains on the last day of the current year

I created accounting periods for the following year (2024) thinking that could be it but I can't get those fields to display correctly

Thank you again for your time, I hope you could help me with another point of view.

Greetings
Verified answer

Shauna Langley 879 Super User 2025 Season 1 on at

Like (0)

Report

Dates in Planning Worksheets

Hi,

That looks as if you have a default safety time setup on your manufacturing setup. See below example.

Planning worksheet shows

So the due date in this scenario on the component lines is based of the ending date on the planning worksheet as this is when the item needs to be made for to cater for the 7 day safety lead time. If you remove the safety lead time from the manufacturing setup then the due date on the planning worksheet and components will be the same.

There may also be a safety lead time setup against the item or stock keeping unit.

Hope that helps,

Shauna