Import Open Released Production Orders at Cut Over - Good or Bad Idea?
nav13
Member Posts: 39
All-
NAV 2016 question:
I generally have clients manually enter open RPO's at cutover and also manually use the production journal to catch up the routing time/cost and consumption journal for material issues for cost/qty to validate GL balance to WIP.
However, this client has upwards of 1000 open production orders on the floor so i was looking to see if importing cut over RPO is plausible.
My proposed process is:
1. Import RPO headers and auto refresh production order so NAV brings in routing and components.
2. Import WIP inventory in a special location so inventory can be easily consumed to RPO via consumption journal
3. Import Output journal excel report via rapid start packages for each RPO operation time/qty entry and post the journal so net is zero dollars to WIP but catch up subledger cost/time to RPO.
4. Import Consumption journal excel report via rapid start packages for each RPO component qty issues in legacy system again with zero dollars to WIP but to catch up subledger for RPO.
Let me know if this process is plausible, if client can export this data out of their current system in excel or if there is a better way to handle this volume of orders at cut over.
Thanks in advance,
NAV13
NAV 2016 question:
I generally have clients manually enter open RPO's at cutover and also manually use the production journal to catch up the routing time/cost and consumption journal for material issues for cost/qty to validate GL balance to WIP.
However, this client has upwards of 1000 open production orders on the floor so i was looking to see if importing cut over RPO is plausible.
My proposed process is:
1. Import RPO headers and auto refresh production order so NAV brings in routing and components.
2. Import WIP inventory in a special location so inventory can be easily consumed to RPO via consumption journal
3. Import Output journal excel report via rapid start packages for each RPO operation time/qty entry and post the journal so net is zero dollars to WIP but catch up subledger cost/time to RPO.
4. Import Consumption journal excel report via rapid start packages for each RPO component qty issues in legacy system again with zero dollars to WIP but to catch up subledger for RPO.
Let me know if this process is plausible, if client can export this data out of their current system in excel or if there is a better way to handle this volume of orders at cut over.
Thanks in advance,
NAV13
0
Best Answer
-
NAV13,
Did this work for you? Facing the exact same issue.5
Answers
-
Anybody?? I expect a few answers.0
-
sounds good. best you give it a try in a demo database to check if all is doing correct.best regards
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/0 -
NAV13,
Did this work for you? Facing the exact same issue.5 -
Yes it did.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
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 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
