Sales orders have old Bin locations after bins updated with new physical locations

pancake
Member Posts: 1
I've found different results on how to be setup bins and locations but what matters is what it currently is setup, and if we need to change moving that way.
Currently we have a location as Shipping: and Bins are shelf numbers and rows. We rearrange the room for new products and move everything every few years. We update the bin locations with the item reclass journal after they have been physically moved. What ends up happening is the Sales Order now has the wrong bin location.
When the Sales Order is billed it cannot because the bin no longer has any stock. Items are only in a single bin at each location marked as the default bin.
How do we update the bin in a sales order without going line by line? Doing 1 sales order at a time would be a huge improvement but being able to bulk do it through a journal or every open sales order would be even better. Bin Mandatory is checked. Version of Navision is 2009R2 Classic. This currently is a very manual process and I feel it should be something simple.
Currently we have a location as Shipping: and Bins are shelf numbers and rows. We rearrange the room for new products and move everything every few years. We update the bin locations with the item reclass journal after they have been physically moved. What ends up happening is the Sales Order now has the wrong bin location.
When the Sales Order is billed it cannot because the bin no longer has any stock. Items are only in a single bin at each location marked as the default bin.
How do we update the bin in a sales order without going line by line? Doing 1 sales order at a time would be a huge improvement but being able to bulk do it through a journal or every open sales order would be even better. Bin Mandatory is checked. Version of Navision is 2009R2 Classic. This currently is a very manual process and I feel it should be something simple.
0
Best Answer
-
You would need to develop something to do this - should be fairly straughtforward5
Answers
-
You would need to develop something to do this - should be fairly straughtforward5
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