Inalid Consumption value

patelashlesh83
Member Posts: 54
Hi,
While i am finding the consumption value from Item->Price->Calculation->Complete, the actual consumption value is expected but the round figure is displayed. Please go through below short ex. for an item.
-> Height = 6
-> Width = 6
Now on the BOM Line I have set hte formula = 'Height * Width * Constant' and the measurement fields are,
-> Height = 2
->Width = 2
Now from the Main BOM item (on item page), click on the Price->Calculate->Complete.
The actual result should be '3.9204' (as per the equation '(Standard height * Conversion factor * Standard width * Conversion factor * Calculation Quantity = 6*0.33*6*0.33*1 = 3.9204) but the consumption field shows me the '4' which is not expected by my scenario.
Please advice me to resolve this.
Thanks & Regards,
/Ashlesh
While i am finding the consumption value from Item->Price->Calculation->Complete, the actual consumption value is expected but the round figure is displayed. Please go through below short ex. for an item.
-> Height = 6
-> Width = 6
Now on the BOM Line I have set hte formula = 'Height * Width * Constant' and the measurement fields are,
-> Height = 2
->Width = 2
Now from the Main BOM item (on item page), click on the Price->Calculate->Complete.
The actual result should be '3.9204' (as per the equation '(Standard height * Conversion factor * Standard width * Conversion factor * Calculation Quantity = 6*0.33*6*0.33*1 = 3.9204) but the consumption field shows me the '4' which is not expected by my scenario.
Please advice me to resolve this.
Thanks & Regards,
/Ashlesh
0
Comments
-
Have you set a roundup on the BOM line?The art of teaching is clarity and the art of learning is to listen0
-
yes, I already checked by setting up the rounding up and with it.
But the result remains the same.
Thanks for the reply.
/Ashlesh0 -
Sorry should have read your post closer
The system uses the formula you set. The formula you have set is height*width*constant. This formula is for the BOM line and has absolutely nothing to do with the item settings. The item will default the measurements on, if you choose to change them then that is for you to do. However as it is the BOM line settings you will see from your formula written out that AX is correct 2*2*1 is indeed 4. You are looking for the system to perform a calculation it does not actually perform.The art of teaching is clarity and the art of learning is to listen0
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