mibuso.com

Microsoft Business Solutions online community
It is currently Tue May 21, 2013 9:16 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Unit Cost rounding issue at Item Journal
PostPosted: Thu Apr 05, 2012 6:42 pm 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
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.


Top
 Profile E-mail  
 
 Post subject: Re: Unit Cost rounding issue at Item Journal
PostPosted: Thu Apr 05, 2012 8:59 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
compare you gl setup table cronus

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Unit Cost rounding issue at Item Journal
PostPosted: Fri Apr 06, 2012 1:08 am 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
ara3n wrote:
compare you gl setup table cronus

actually i'm using cronus database
is there any setting in gl setup?


Top
 Profile E-mail  
 
 Post subject: Re: Unit Cost rounding issue at Item Journal
PostPosted: Thu Apr 12, 2012 2:06 pm 
Offline

Joined: Fri Mar 23, 2012 8:01 pm
Posts: 67
Country: United Arab Emirates (ae)
Dear

Use table 98. you check field Unit amount rounding. Amount Rounding Precision put 0.01 or as per your requirement.

Warm Regards
KMK


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 16 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: