mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 7:52 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Item cost adjustment
PostPosted: Fri Jul 13, 2012 12:44 pm 
Offline

Joined: Thu Jun 16, 2011 10:53 am
Posts: 3
Country: Nigeria (ng)
Has anyone come across this in Nav 6.0R2
Cost of goods sold was adjusted through the ajust Cost - Item entries batch job. the problem is that the original sales document had a posting date of 15/05/2012 and an adjustment entry was created by the system with the same document no. but with a later posting date of 28/06/12.

Pls what can be the cause of this?


Top
 Profile E-mail  
 
 Post subject: Re: Item cost adjustment
PostPosted: Fri Jul 13, 2012 12:49 pm 
Offline

Joined: Sat Aug 08, 2009 6:28 am
Posts: 158
Location: gujarat
Country: India (in)
Sure it must be following reason,

If item which you are selling is production item, then one of its component reevaluated, so yours sold its also affected and its' COGS changed.

If it is purchased item then it is, revaluation of this item affected.

_________________
Uday Mer | MS Dynamics NAV Techno-Functional Consultant


Top
 Profile E-mail  
 
 Post subject: Re: Item cost adjustment
PostPosted: Fri Jul 13, 2012 3:34 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8703
Location: 3rd rock from sun
Country: United States (us)
If it's a purchase item, it could be that the invoice came after the sale. What costing method do you have?
It could be also that you assigned freight charges. It's very easy to fin out how the Sales entry is applied against it. Find the inbound Item ledger entry and take a look.

_________________
Rashed.

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


Top
 Profile  
 
 Post subject: Re: Item cost adjustment
PostPosted: Fri Jul 13, 2012 5:58 pm 
Offline

Joined: Thu Jun 16, 2011 10:53 am
Posts: 3
Country: Nigeria (ng)
@ Udaymer, it is purchased item. and the purchase invoice was posted earlier but it has been revalued.

@Rashed.. the purchase invoice has a posting date earlier than the sales document

Thanks Guys


Top
 Profile E-mail  
 
 Post subject: Re: Item cost adjustment
PostPosted: Fri Jul 13, 2012 7:07 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 4858
Location: Los Angeles, CA
Country: United States (us)
You changed the Allow Posting From on the General Ledger Setup. If the adjustment date is prior to the transaction date allowed by the Allow Posting From date, then it will use the current date as the posting date.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work


Top
 Profile E-mail WWW  
 
 Post subject: Re: Item cost adjustment
PostPosted: Mon Jul 16, 2012 2:40 pm 
Offline

Joined: Sat Aug 08, 2009 6:28 am
Posts: 158
Location: gujarat
Country: India (in)
yes,

If the item has been reevaluated so revaluation entry is there.

May i know what is your purpose behind revaluation ?

_________________
Uday Mer | MS Dynamics NAV Techno-Functional Consultant


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

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 6 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: