Inconsistent Item Ledger Entry/Value Entry Qty

gooddavid

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

jubeljoy

Is this a manual transfer order posting or any customization activity done.

Let me know which Navision Version you are using.

gooddavid

customization concerning posting none.

we're using NAV 5.1.

Thanks for the prompt response.

gooddavid

btw, yes it's a manual transfer.

jubeljoy

Is there any quantity available on the In-transit Location.

gooddavid

Base on item ledger entry balance as of the date of posting that transaction, there was.

jubeljoy

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.

gooddavid

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)

FDickschat

To summarize, you have:

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.

jubeljoy

Yes It seem to be serious issue. Please contact your partner or mail to support@navisionplanet.com for further help.