Production Order Summary Report Field
td323i
Member Posts: 26
Hello All,
I’ve got a reporting question for Nav 4.0 Sp2. It involves the production order summary report. In the report (which has been modified) we have Material Cost, Overhead Cost and total cost. Total cost = Material Cost + Overhead Cost. The SourceExpr is <MaterialCost + OverheadCost>
We have a field that’s called “Quantity Produced” who’s Source Expr is <Finished Quantity> . We would like to have the average cost total up at the bottom of the page and that would be Total cost / Quantity Produced = Average Cost.
I’m stuck at the formula needed to make this calculation. In my mind the SourceExpr would be <MaterialCost + OverheadCost / Finished Quantity> it doesn’t work so I know its not correct. Anyone have any ideas?
Thanks,
Td
I’ve got a reporting question for Nav 4.0 Sp2. It involves the production order summary report. In the report (which has been modified) we have Material Cost, Overhead Cost and total cost. Total cost = Material Cost + Overhead Cost. The SourceExpr is <MaterialCost + OverheadCost>
We have a field that’s called “Quantity Produced” who’s Source Expr is <Finished Quantity> . We would like to have the average cost total up at the bottom of the page and that would be Total cost / Quantity Produced = Average Cost.
I’m stuck at the formula needed to make this calculation. In my mind the SourceExpr would be <MaterialCost + OverheadCost / Finished Quantity> it doesn’t work so I know its not correct. Anyone have any ideas?
Thanks,
Td
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions