Decimal places..

pplNet
Member Posts: 11
Hi all,
I'm new to Navision world. I have a problem that i wish to using example to explain which makes it more clearer.
EG.
Purchase item "A" with 10 units, total discounted cost is 100.01.
Here, cost per unit will become 10.001
If you refer back to table<Value Entry>, "Cost Per Unit" is 10.001 which is correct but the "Amount" will be rounded up to 10.00.
As if all item "A" sold out 1 by 1 qty, there would be short of 0.01 amount in item card.
Any ideal how to solve this problem?
Thx in advanced.
I'm new to Navision world. I have a problem that i wish to using example to explain which makes it more clearer.
EG.
Purchase item "A" with 10 units, total discounted cost is 100.01.
Here, cost per unit will become 10.001
If you refer back to table<Value Entry>, "Cost Per Unit" is 10.001 which is correct but the "Amount" will be rounded up to 10.00.
As if all item "A" sold out 1 by 1 qty, there would be short of 0.01 amount in item card.
Any ideal how to solve this problem?
Thx in advanced.
To be a SMART, first you must be a STUPID.
0
Comments
-
Try set Amount decimal places to another value in G/L setup (or on used currency)0
-
Hi,
Field "Unit-Amount Rounding Precision" in G/L Setup is used for rounding "Unit Cost (LCY)" field in purchase line. This field might not be displayed on G/L Setup form by default (you can add it). Default value is 0.01.
For rounding "Unit Cost" field, "Unit-Amount Rounding Precision" field on 'Currencies' form is used.http://www.NaviTools.com
Documentation for Microsoft Navision
E/R diagrams, Workflow diagrams, UML diagrams, process diagrams0 -
Hi,
It sounds like a method of prevention...
But i need a solution before have these prevention way..
Anyway, thx. I learned from you.
Any other solution??To be a SMART, first you must be a STUPID.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