Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 297 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Unit Cost rounding issue at Item Journal
julkifli33
Member Posts: 1,087
Hi All,
May I know has anyone come across Unit Cost rounding issue at Item Journal?
I am uploading inventory balances via Item Journal Lines (table 83), but after posting system automatically round up/down to whole amount.
Eg. Qty Unit Cost Unit Amount Amount
Item A 1 1,232.35 1,232.35 1,232.35
But after posting the Item Journal, then Item Unit Cost gets rounded to 1,232.00.
Qty Unit Cost Unit Amount Amount
Item B 1 13,160.69 13,160.69 13,160.69
After posting, Unit Cost gets rounded up to 13,161.
Because of this, it resulted a huge rounding differences and we are not able to tally with GL. We looked into the Setups but still couldn’t find any related configurations to resolve this. Appreciate your kind inputs on the above matter.
May I know has anyone come across Unit Cost rounding issue at Item Journal?
I am uploading inventory balances via Item Journal Lines (table 83), but after posting system automatically round up/down to whole amount.
Eg. Qty Unit Cost Unit Amount Amount
Item A 1 1,232.35 1,232.35 1,232.35
But after posting the Item Journal, then Item Unit Cost gets rounded to 1,232.00.
Qty Unit Cost Unit Amount Amount
Item B 1 13,160.69 13,160.69 13,160.69
After posting, Unit Cost gets rounded up to 13,161.
Because of this, it resulted a huge rounding differences and we are not able to tally with GL. We looked into the Setups but still couldn’t find any related configurations to resolve this. Appreciate your kind inputs on the above matter.
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
is there any setting in gl setup?
Use table 98. you check field Unit amount rounding. Amount Rounding Precision put 0.01 or as per your requirement.
Warm Regards
KMK