Rounding Entries
bcoleman
Member Posts: 7
Hello all -
I was hoping someone might be able to shed some light for me on best practices regarding rounding entries in NAV 2009 Classic Client.
We use NAV in a manufacturing company and are heavy users of the Manufacturing module. We have item standard costs that go to 6 decimal places. We will "output" in quantities of lbs. So, for example, we will output a line with a quantity of 1,400 lbs at .389838 per lb. The value entry will be posted at $545.77. However, when we run adjust cost, we will get numerous entries adding and subtracting $0.01. Sometimes, it will hit and re-hit an ILE line each time we run adjust cost. Everything ultimately hits the G/L correctly.
So what's the problem? A full 18% of my G/L entries are these $0.01 adds and subtracts. In one of our plants I'm up to almost 4 million G/L entries of just these $0.01 lines. I'm not super concerned by it, but it just feels wrong. It takes longer than normal to run adjust cost and it does impact performance somewhat.
Any ideas or suggestions would be appreciated. Thanks for your help in advance!
I was hoping someone might be able to shed some light for me on best practices regarding rounding entries in NAV 2009 Classic Client.
We use NAV in a manufacturing company and are heavy users of the Manufacturing module. We have item standard costs that go to 6 decimal places. We will "output" in quantities of lbs. So, for example, we will output a line with a quantity of 1,400 lbs at .389838 per lb. The value entry will be posted at $545.77. However, when we run adjust cost, we will get numerous entries adding and subtracting $0.01. Sometimes, it will hit and re-hit an ILE line each time we run adjust cost. Everything ultimately hits the G/L correctly.
So what's the problem? A full 18% of my G/L entries are these $0.01 adds and subtracts. In one of our plants I'm up to almost 4 million G/L entries of just these $0.01 lines. I'm not super concerned by it, but it just feels wrong. It takes longer than normal to run adjust cost and it does impact performance somewhat.
Any ideas or suggestions would be appreciated. Thanks for your help in advance!
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions