Calculating Available quantity for different departments

madsmorre
Member Posts: 40
Hi
We have 2 sales departments - Retail and Wholesale
When we buy items for stock (Item variants), we would like some of the purchases to be "reserved" by our retail department.
Example:
We buy 1000 of one Item Variant
The 400 is reserved by Retail department. Retail department are allowed to sell up to 1000 but Wholesale are only allowed to sell 600. For both departments the standard available calculation should apply when entering a sales line (if we have 1000 in stock (600 for WHS) and 100 in open sales lines - WHS - thenonly 500 should be available for WHS and 900 for Retail)
We are running NAV 2016
Does anyone have inputs how to handle this?
We don't want to use two locations as this will require double stock. Meaning that we only want to handle our pick-bins as one stock.
I tried to browse MIBUSO for discussions concerning this, but i didn't found it
Looking foreward to hearing from you.
Regards
Mads Morre
We have 2 sales departments - Retail and Wholesale
When we buy items for stock (Item variants), we would like some of the purchases to be "reserved" by our retail department.
Example:
We buy 1000 of one Item Variant
The 400 is reserved by Retail department. Retail department are allowed to sell up to 1000 but Wholesale are only allowed to sell 600. For both departments the standard available calculation should apply when entering a sales line (if we have 1000 in stock (600 for WHS) and 100 in open sales lines - WHS - thenonly 500 should be available for WHS and 900 for Retail)
We are running NAV 2016
Does anyone have inputs how to handle this?
We don't want to use two locations as this will require double stock. Meaning that we only want to handle our pick-bins as one stock.
I tried to browse MIBUSO for discussions concerning this, but i didn't found it
Looking foreward to hearing from you.
Regards
Mads Morre
0
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