Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 300 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Modify report to show calculation
rico1931
Member Posts: 295
Hi Everyone,
So it's been a while since I've had to modify a report and I'm having a brain block right now... I've been asked to modify report 99000784 to show on each machine line the total capacity that is 90days past due. Not each individual Production order but the total capacity (time) that is "past due"
Currently the report gives the effective capacity, and how much capacity is needed for Prod. Orders and then what's available...
I'm looking for direction on how to tackle getting the total time of what is past due from the day that is ran in the starting date minus 90days where the routing status for that machine center is not = to "Finished"
Thanks for any advice or recommendations on where to start... At first I was thinking I could use the "Prod. Order Need (Qty.)" variable to to reverse that and subtract the PeriodStartingDate by 90 days but it didn't work.
Thanks!
So it's been a while since I've had to modify a report and I'm having a brain block right now... I've been asked to modify report 99000784 to show on each machine line the total capacity that is 90days past due. Not each individual Production order but the total capacity (time) that is "past due"
Currently the report gives the effective capacity, and how much capacity is needed for Prod. Orders and then what's available...
I'm looking for direction on how to tackle getting the total time of what is past due from the day that is ran in the starting date minus 90days where the routing status for that machine center is not = to "Finished"
Thanks for any advice or recommendations on where to start... At first I was thinking I could use the "Prod. Order Need (Qty.)" variable to to reverse that and subtract the PeriodStartingDate by 90 days but it didn't work.
Thanks!
-rico1931
0