mibuso.com

Microsoft Business Solutions online community
It is currently Thu Jun 20, 2013 5:53 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 1:14 pm 
Offline

Joined: Thu Mar 29, 2012 12:46 pm
Posts: 6
Country: Philippines (ph)
Hi everyone!

We got a situation as mentioned in the subject. The inconsistent entries originates from certain Transfer Order documents.

Here's how it goes:

Transfer Order:
Qty Shipped : 10

Item Ledger Entry:
From Location: -10
To Location: 0 (This is supposed to be 10 right?)

Value Entry (Qty/Cost Amount (Actual)):
From Location: -10/-550.00
To Location: 0/550.00 (This is supposed to be 10 also?)

I'm thinking of running the Average Cost Adjmt, but Im not quite sure if it would resolve the issue.

Need your help guys.

Thanks :)


Top
 Profile E-mail  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 1:22 pm 
Offline

Joined: Tue Jun 30, 2009 9:05 am
Posts: 102
Location: Bangalore
Country: India (in)
Is this a manual transfer order posting or any customization activity done.

Let me know which Navision Version you are using.

_________________
Jubelhttp://navisionplanet.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 1:25 pm 
Offline

Joined: Thu Mar 29, 2012 12:46 pm
Posts: 6
Country: Philippines (ph)
customization concerning posting none.

we're using NAV 5.1.

Thanks for the prompt response.


Top
 Profile E-mail  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 1:25 pm 
Offline

Joined: Thu Mar 29, 2012 12:46 pm
Posts: 6
Country: Philippines (ph)
btw, yes it's a manual transfer.


Top
 Profile E-mail  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 1:31 pm 
Offline

Joined: Tue Jun 30, 2009 9:05 am
Posts: 102
Location: Bangalore
Country: India (in)
Is there any quantity available on the In-transit Location.

_________________
Jubelhttp://navisionplanet.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 2:05 pm 
Offline

Joined: Thu Mar 29, 2012 12:46 pm
Posts: 6
Country: Philippines (ph)
Base on item ledger entry balance as of the date of posting that transaction, there was.


Top
 Profile E-mail  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 5:34 pm 
Offline

Joined: Tue Jun 30, 2009 9:05 am
Posts: 102
Location: Bangalore
Country: India (in)
So your Transfer Order is posted and Posted Transfer Shipment created but Receipt not yet created.

So please check the same on your open transfer order list and then receive the materials.

_________________
Jubelhttp://navisionplanet.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 5:43 pm 
Offline

Joined: Thu Mar 29, 2012 12:46 pm
Posts: 6
Country: Philippines (ph)
Transfer receipt has been posted already also, here's how the entry goes:

In Transit: -10/-550.00
To Location : 0/550.00


(I would like to correct my previous post, it was supposedly "In Transit" location not "To Location" since it demonstrates only shipment)


Top
 Profile E-mail  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Thu Mar 29, 2012 6:22 pm 
Offline

Joined: Mon Mar 12, 2007 3:07 pm
Posts: 340
Location: Hamburg
Country: Germany (de)
To summarize, you have:

Code: Select all
In the Transfer Order
Shipped 10, Received 10, Outstanding 0, In-Transit 0

In ILE/VE:
From Location    -10 pcs, -550
To   In-Transit    0 pcs, +550
From In-Transit  -10 pcs, -550
To   Location      0 pcs, +550

And you think running Cost Adjustment might help??? :shock:

You have a serious problem in the posting routine. In total you have lost 20 pcs, with no loss of value.
- What is the setting of the field Inventoriable in these Value Entries?
- Is this a one time only case or do you have more of these?

Are you an end user or a partner? If end user get your partner and have him fix this mess.

_________________
Frank Dickschat
FD Consulting


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inconsistent Item Ledger Entry/Value Entry Qty
PostPosted: Fri Mar 30, 2012 11:20 am 
Offline

Joined: Tue Jun 30, 2009 9:05 am
Posts: 102
Location: Bangalore
Country: India (in)
Yes It seem to be serious issue. Please contact your partner or mail to support@navisionplanet.com for further help.

_________________
Jubelhttp://navisionplanet.com


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

All times are UTC + 1 hour [ DST ]


Who is online

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