Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 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
Options
Interpretation of "Production Order - Shortage List" report
RabbitPost
Member Posts: 17
Hello All
I am trying to understand the "Prod Order - Shortage List" report. In particular the data shown in the last columns. I have tried to match the data for various items on the report by comparing the report to the associated items cards and prod orders without success.
Please can someone explain how these columns are calculated / using what data.
Remaining Qty. (Base)
Quantity on Hand
Qty. Other
Qty. on Hand after Production
Scheduled Need
Qty. on Purch. Order
Needed Quantity
Also, if there are 2 production orders requiring the same item but there is only 1 on hand how does Nav decide which order will take the stock and which order will show a shortage when you generate this report.
I am trying to understand the "Prod Order - Shortage List" report. In particular the data shown in the last columns. I have tried to match the data for various items on the report by comparing the report to the associated items cards and prod orders without success.
Please can someone explain how these columns are calculated / using what data.
Remaining Qty. (Base)
Quantity on Hand
Qty. Other
Qty. on Hand after Production
Scheduled Need
Qty. on Purch. Order
Needed Quantity
Also, if there are 2 production orders requiring the same item but there is only 1 on hand how does Nav decide which order will take the stock and which order will show a shortage when you generate this report.
0
Answers
Quantity on Hand = Inventory - Reserved Qty. on Inventory
Qty. on Hand after Production = Inventory - (Remaining Qty of prod+ Reserved Qty on prod).
Scheduled Need = Remaining Qty of item on production component
Needed Qty = Scheduled Need (Qty.) +( "Qty. on Sales Order" - "Qty. on Purch. Order" -"Scheduled Receipt (Qty.)" - nventory;