Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / logic of calculating t...
Microsoft Dynamics NAV (Archived)

logic of calculating the Start date and End date in planning Worksheet(NAV 2009 sp1).

(0) ShareShare
ReportReport
Posted on by ANTONY MATHEW 40

I am using two machine center, one Work center, two shifts and using planning worksheet to Calculate Regenerative plan. But it Showing the result which doesn't have any logic. So any one know the logic behind calculating the date and time in Planning worksheet please share with us.

No. Action Message Accept Action Message Due Date Starting Date-Time Ending Date-Time Quantity Description Original Quantity MPS Order Ref. Order Type Ref. Order No. Ref. Order Status
SP001-FG New Yes 19-12-13 18-12-13 15:39 18-12-13 23:59 100 Finished Good No Prod. Order 101346 Planned
SP002-FG New Yes 19-12-13 18-12-13 15:39 18-12-13 23:59 100 Fininshed Goods2 No Prod. Order 101347 Planned
SP001-SF New Yes 18-12-13 17-12-13 15:39 17-12-13 23:59 100 SFG1 No Prod. Order 101348 Planned
SP003-SF New Yes 18-12-13 17-12-13 0:19 17-12-13 17:00 100 SFG3 No Prod. Order 101349 Planned
SP004-SF New Yes 18-12-13 16-12-13 15:59 17-12-13 17:00 100 SFG4 No Prod. Order 101350 Planned
SP007-SF New Yes 18-12-13 15-12-13 0:39 16-12-13 17:00 100 SFG7 No Prod. Order 101351 Planned
SP009-SF New Yes 18-12-13 16-12-13 15:39 17-12-13 0:00 100 SFG9 No Prod. Order 101352 Planned
SP002-SF New Yes 17-12-13 14-12-13 17:39 15-12-13 2:00 100 SFG2 No Prod. Order 101353 Planned
SP002-SF New Yes 18-12-13 16-12-13 15:39 17-12-13 0:00 100 SFG2 No Prod. Order 101354 Planned
SP005-SF New Yes 16-12-13 14-12-13 15:39 15-12-13 0:00 100 SFG5 No Prod. Order 101355 Planned
SP005-SF New Yes 18-12-13 16-12-13 15:39 17-12-13 0:00 100 SFG5 No Prod. Order 101356 Planned
SP008-SF New Yes 15-12-13 14-12-13 15:39 14-12-13 23:59 100 SFG8 No Prod. Order 101357 Planned
SP008-SF New Yes 18-12-13 14-12-13 0:59 15-12-13 0:39 100 SFG8 No Prod. Order 101358 Planned
SP006-SF New Yes 14-12-13 13-12-13 15:39 13-12-13 23:59 100 SFG6 No Prod. Order 101359 Planned
SP006-SF New Yes 16-12-13 12-12-13 16:59 14-12-13 17:00 200 SFG6 No Prod. Order 101360 Planned
SP006-SF New Yes 18-12-13 12-12-13 1:39 12-12-13 17:00 100 SFG6 No Prod. Order 101361 Planned

 

*This post is locked for comments

  • Patcharin Profile Picture
    Patcharin 139 on at
    RE: logic of calculating the Start date and End date in planning Worksheet(NAV 2009 sp1).

    Have you found the answer yet? I got a Start date and End date problem in planning worksheet too. And I have no idea about this. help me please. you can see more detail in this link.

    community.dynamics.com/.../planning-worksheet-didn-t-show-starting-date-and-ending-date-correctly-as-i-set

  • ANTONY MATHEW Profile Picture
    ANTONY MATHEW 40 on at
    RE: logic of calculating the Start date and End date in planning Worksheet(NAV 2009 sp1).

    Is there any bug in Planning worksheet when we are using Multiple machine and shifts in NAV 2009 SP1?

  • ANTONY MATHEW Profile Picture
    ANTONY MATHEW 40 on at
    RE: logic of calculating the Start date and End date in planning Worksheet(NAV 2009 sp1).

    Here is the details..

    Inventory 0 for all items. And its for Production. Two FG and 9 SFG,1RM. Sale order for 100 quantity for both FGS.

    BOM

    No.

    Unit of Measure Code

    Component

    SF001

    KG

    SF002

    SF002

    KG

    SP001-RM

    SF003

    KG

    SP001-RM

    SF004

    KG

    SP005-SF,SP006-SF

    SF005

    KG

    SP006-SF

    SF006

    KG

    SP001-RM

    SF007

    KG

    SP008-SF

    SF008

    KG

    SP001-RM

    SF009

    KG

    SP001-RM

    SP001FG

    KG

    SP001-SF,SP002-SF,SP003-SF,SP004-SF,SP005-SF,SP006-SF

    SP002FG

    KG

    SP007-SF,SP008-SF,SP009-SF


    Machine Center

    No.

    Name

    Work Center No.

    Capacity

    Efficiency

    Flushing Method

    SP001MC

    MAchine Center1

    SP002WC

    1

    100

    Manual

    SP002MC

    Machine Center2

    SP002WC

    1

    100

    Manual

    SP003MC

    Machine Center3

    SP002WC

    1

    100

    Manual

    SP004MC

    Machine Center4

    SP002WC

    1

    100

    Manual


    Routing  Setup Time etc are 0
    No. Description Machine Center Work Center Run Time
    FG001 FG001 SP001MC SP002WC 5
    FG002 FG002 SP001MC SP002WC 5
    SF001 SF001 SP002MC SP002WC 5
    SF002 SF002 SP003MC SP002WC 5
    SF003 SF003 SP002MC SP002WC 5
    SF004 SF004 SP002MC SP002WC 5
    SF005 SF005 SP003MC SP002WC 5
    SF006 SF006 SP002MC SP002WC 5
    SF007 SF007 SP002MC SP002WC 5
    SF008 SF008 SP002MC SP002WC 5
    SF009 SF009 SP003MC SP002WC 5
    2 Shifts
    Day Starting Time Ending Time Work Shift Code
    Monday  9:00:00 AM  5:00:00 PM 1
    Monday  5:00:00 PM 11:59:59 PM 2
    Tuesday 12:00:00 AM  2:00:00 AM 2
    Tuesday  9:00:00 AM  5:00:00 PM 1
    Tuesday  5:00:00 PM 11:59:59 PM 2
    Wednesday 12:00:00 AM  2:00:00 AM 2
    Wednesday  9:00:00 AM  5:00:00 PM 1
    Wednesday  5:00:00 PM 11:59:59 PM 2
    Thursday 12:00:00 AM  2:00:00 AM 2
    Thursday  9:00:00 AM  5:00:00 PM 1
    Thursday  5:00:00 PM 11:59:59 PM 2
    Friday 12:00:00 AM  2:00:00 AM 2
    Friday  9:00:00 AM  5:00:00 PM 1
    Friday  5:00:00 PM 11:59:59 PM 2
    Saturday 12:00:00 AM  2:00:00 AM 2
    Saturday  9:00:00 AM  5:00:00 PM 1
    Saturday  5:00:00 PM 11:59:59 PM 2
    Sunday 12:00:00 AM  2:00:00 AM 2


    Result

    Warning

    No.

    Action Message

    Accept Action Message

    Original Due Date

    Due Date

    Starting Date-Time

    Ending Date-Time

    Quantity

    Description

    Original Quantity

    MPS Order

    Ref. Order Type

    Ref. Order No.

    Ref. Order Status

    -1

    SP001-FG

    New

    Yes

    19-12-13

    18-12-13 15:39

    18-12-13 23:59

    100

    Finished Good

    No

    Prod. Order

    101362

    Planned

    -1

    SP002-FG

    New

    Yes

    19-12-13

    18-12-13 0:19

    18-12-13 17:00

    100

    Fininshed Goods2

    No

    Prod. Order

    101363

    Planned

    -1

    SP001-SF

    New

    Yes

    18-12-13

    17-12-13 15:39

    17-12-13 23:59

    100

    SFG1

    No

    Prod. Order

    101364

    Planned

    -1

    SP003-SF

    New

    Yes

    18-12-13

    17-12-13 0:19

    17-12-13 17:00

    100

    SFG3

    No

    Prod. Order

    101365

    Planned

    -1

    SP004-SF

    New

    Yes

    18-12-13

    16-12-13 15:59

    17-12-13 17:00

    100

    SFG4

    No

    Prod. Order

    101366

    Planned

    -1

    SP007-SF

    New

    Yes

    18-12-13

    15-12-13 0:39

    16-12-13 17:00

    100

    SFG7

    No

    Prod. Order

    101367

    Planned

    -1

    SP009-SF

    New

    Yes

    18-12-13

    16-12-13 15:39

    17-12-13 0:00

    100

    SFG9

    No

    Prod. Order

    101368

    Planned

    -1

    SP002-SF

    New

    Yes

    17-12-13

    14-12-13 17:39

    15-12-13 2:00

    100

    SFG2

    No

    Prod. Order

    101369

    Planned

    -1

    SP002-SF

    New

    Yes

    18-12-13

    16-12-13 15:39

    17-12-13 0:00

    100

    SFG2

    No

    Prod. Order

    101370

    Planned

    -1

    SP005-SF

    New

    Yes

    16-12-13

    14-12-13 15:39

    15-12-13 0:00

    100

    SFG5

    No

    Prod. Order

    101371

    Planned

    -1

    SP005-SF

    New

    Yes

    18-12-13

    16-12-13 15:39

    17-12-13 0:00

    100

    SFG5

    No

    Prod. Order

    101372

    Planned

    -1

    SP008-SF

    New

    Yes

    15-12-13

    14-12-13 15:39

    14-12-13 23:59

    100

    SFG8

    No

    Prod. Order

    101373

    Planned

    -1

    SP008-SF

    New

    Yes

    18-12-13

    14-12-13 0:59

    15-12-13 0:39

    100

    SFG8

    No

    Prod. Order

    101374

    Planned

    -1

    SP006-SF

    New

    Yes

    14-12-13

    13-12-13 15:39

    13-12-13 23:59

    100

    SFG6

    No

    Prod. Order

    101375

    Planned

    -1

    SP006-SF

    New

    Yes

    16-12-13

    12-12-13 16:59

    14-12-13 17:00

    200

    SFG6

    No

    Prod. Order

    101376

    Planned

    -1

    SP006-SF

    New

    Yes

    18-12-13

    12-12-13 1:39

    12-12-13 17:00

    100

    SFG6

    No

    Prod. Order

    101377

    Planned

    -1

    SP001-RM

    New

    Yes

    12-12-13

    11-12-13 0:00

    11-12-13 0:00

    300

    RM

    No

    Purchase

    -1

    SP001-RM

    New

    Yes

    13-12-13

    12-12-13 0:00

    12-12-13 0:00

    100

    RM

    No

    Purchase

    -1

    SP001-RM

    New

    Yes

    14-12-13

    13-12-13 0:00

    13-12-13 0:00

    300

    RM

    No

    Purchase

    -1

    SP001-RM

    New

    Yes

    16-12-13

    15-12-13 0:00

    15-12-13 0:00

    200

    RM

    No

    Purchase

    -1

    SP001-RM

    New

    Yes

    17-12-13

    16-12-13 0:00

    16-12-13 0:00

    100

    RM

    No

    Purchase





























    And If it is with one shift and one machine its work fine. But for multiple shift and machine we didn't get any logic how it is working. 



  • Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: logic of calculating the Start date and End date in planning Worksheet(NAV 2009 sp1).

    We cannot see complete table. We also have not enough information. What documents (sales, purchase, PO...) you have in database; what is inventory; what is replenishment and planning parameters?

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 us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans