Howdy, Stranger!
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
- 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
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
UOM conversion/display issue
ChrisG
Member Posts: 2
Our customer needs to have 2 units of measure for steel sheets: sheet and square millimetre. One sheet is 280,000,000 sq. mm.
We can set this up by using SQ MM as the base UOM and SHEET as a secondary UOM with Qty. per Unit of Measure = 280,000,000. However, this means that inventory is displayed in SQ MM, rather than sheets, which the customer requires. We tried to get around this problem by having SHEET as the base UOM, but this means that the Qty. per Unit of Measure for SQ MM needs to be 1/280,000,000, which the field cannot accept because it can store only 5 decimal places.
My questions are :
1. Is there a workaround for this problem that doesn't involve code changes?
2. If there is no such workaround, I suppose we could either (a) modify the code to make the UOM for displaying inventory configurable (like the Sales and Purchase UOM), or (b) adjust [Item Unit of Measure].[Qty. per Unit of Measure] to allow it to store sufficient decimal places. Which would be the better approach?
Many thanks in advance for any suggestions.
Chris
We can set this up by using SQ MM as the base UOM and SHEET as a secondary UOM with Qty. per Unit of Measure = 280,000,000. However, this means that inventory is displayed in SQ MM, rather than sheets, which the customer requires. We tried to get around this problem by having SHEET as the base UOM, but this means that the Qty. per Unit of Measure for SQ MM needs to be 1/280,000,000, which the field cannot accept because it can store only 5 decimal places.
My questions are :
1. Is there a workaround for this problem that doesn't involve code changes?
2. If there is no such workaround, I suppose we could either (a) modify the code to make the UOM for displaying inventory configurable (like the Sales and Purchase UOM), or (b) adjust [Item Unit of Measure].[Qty. per Unit of Measure] to allow it to store sufficient decimal places. Which would be the better approach?
Many thanks in advance for any suggestions.
Chris
0
Answers
That said, i think we should know some more info/explanations:
a. Inventory should be calculated in Sheets, correct?
b. Why do they want sqmm? do they sell/purchase in sqmm instead of sheets?
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
I've now tried increasing the decimal places on Qty. per Unit of Measure, and while that seems to do what we want, I'm not very confident that there will be no unwanted side-effects from this change and I wouldn't know how to test for such side-effects. So I think we might have to go with a change that lets the quantity on inventory be displayed in the secondary UOM.