[RESOLVED] Routing - Calculate End Date

Toddy_Boy
Member Posts: 232
I've been using an in-house developed production scheduler for months now without a glitch. This has a function to move a single operation in the same manner the graphical gantt chart allows. Yesterday, today and probably tomorrow I get a load of errors when trying to calculate the end date as a result of moving a routing line.
I run this statement
where is ProdSchedCalc codeunit "Prod. Schedule Calculations".
The problem occurs trying to execute statement
in procedure
in Table 5407 Prod. Order Component
Any ideas as to why it has started happening now .. maybe a calendar thing?
Cheers
Steve[/code]
I run this statement
ProdSchedCalc.CalculateEndDate("Prod. Order Routing Line")
where is ProdSchedCalc codeunit "Prod. Schedule Calculations".
The problem occurs trying to execute statement
ProdOrderLine.GET(Status,"Prod. Order No.","Prod. Order Line No.");
in procedure
ProdOrderNeeds
in Table 5407 Prod. Order Component
Any ideas as to why it has started happening now .. maybe a calendar thing?
Cheers
Steve[/code]
Life is for enjoying ... if you find yourself frowning you're doing something wrong
0
Comments
-
Do the calendars for the work centres extend far enough into the future or past?The art of teaching is clarity and the art of learning is to listen0
-
Sorted it. There was a record in the Prod. Order Component table which has a status of Simulated, with no production order or line number, and an item number. Cannot recreate this line by inserting into the table so I have no idea how it got in there.Life is for enjoying ... if you find yourself frowning you're doing something wrong0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions