Posting Transfer Order

bekio

Hello everybody,

I have a Transfer Order(usually) without a warehouse receipt or shipment just transfer between locations, i have posted as a ship, but when i try to post as receive it displays a message Item Ledger Entry No. ='xxxxx' does not exist. It stops at this function CheckCyclicFwdToProdOutput from table Item Application Entry. I have traced it via debugger and it stops at the first line of function ItemLedgEntry.GET(EntryNo); This variable EntryNo has the number that is the next number that should be inserted in Item Ledger Entry(let say that the last number in Item Ledger Entry is 98818, this EntryNo variable has 98819).
I don't even know what happened here. Why this is going through this function, for what reason is this function.

Anny suggestion for what is happening this?

Thanks

KSP_NAV

Hi Bekio,

Have you done any customizations in your database? Probably, the Item Appliction Entry record would have been deleted mistakenly. Please check what kind of customization done especially doing the Shipments.

Regards,
KSP

bekio

Hi KSP_NAV,

As I know there are no customization, and it happens rare, this is the third time from 2010 ( but for me is the first time) . It is Microsoft Dynamics NAV 5.0 sp1. The origin of this i didn't get because i didn't understand it was happening during the posting or during adjustment of inventory. So i had to make a Item Journal i made some neg. adj. from Transit location and positive adj. to final location and i have deleted the Transfer Order, and now it seems to be OK, that problem doesn't happened even hundred of transfers have been made after.

Thanks for your replay,

gvolkov

the issue is that there is an open item ledger entry with negative remaining quantity. post a positive item journal to close that entry completely and then post a negative to balance it out. this occurs because the system, when posting the transfer order deems the entries as related. i got more details on this issue if anyone is interested, but this will solve your problem.

ufuk

Hi gvolkov,

Can you share your experience on this please? Rarely, I'm experiencing the same problem on a 5 SP1 with hotfix 976339 applied.

Thanks.

mschneider

gvolkov wrote:

the issue is that there is an open item ledger entry with negative remaining quantity. post a positive item journal to close that entry completely and then post a negative to balance it out. this occurs because the system, when posting the transfer order deems the entries as related. i got more details on this issue if anyone is interested, but this will solve your problem.

Your solution worked great for me. Thank you.

Phenno

gvolkov wrote: »

the issue is that there is an open item ledger entry with negative remaining quantity. post a positive item journal to close that entry completely and then post a negative to balance it out. this occurs because the system, when posting the transfer order deems the entries as related. i got more details on this issue if anyone is interested, but this will solve your problem.

Gvolkov, thank you on this solution.