reapply item ledger entries

tabularasa

I have been investigating a database with corrupted data that has resulted in the item ledger entries not applying. I wan´t to fix the data and then ´´open´´ the entries in order to reapply then... has annyone suggestion as to how this would be done. Which fields do you have to reset,open and in which tables ..

Alex_Chow

Are you an end user or a solution center?

tabularasa

solution center..

Alex_Chow

If you use Applies-from Entry No. when you post, the item ledger will not apply to each other. Is this the case?

Another way to go about applying everything together is to just adjust everything to 0 quantity then positive adjust the correct beginning balance forward. This way, you won't have to go in and mess with the ledger entries and risk damaging the integrity of the data.

tabularasa

Jepps. might be best to close these entries with journal postings.. My question was though if you could uncheck some boleean fields like f.eks...output is adjusted in the item application table ... and then run adjust cost - item entries in order to get the entries to reapply.... I know this used to be possible... I any one knows the trick then please..

Alex_Chow

There are a lot of ways to go about it. Short cuts seems to be the easiest solution until something goes wrong. And sometimes, you won't find out you missed something until a couple of months later or when you're doing an upgrade.

But the best way, and the only way that should be practiced, is to just use the journals and let Navision takes its course.

mrQQ

i'd like to bring back the topic - is it possible to somehow reapply the negative item ledger entries, as if they were posted again?

using journals and undoing anything is not possible and not valid in current situation...

DonDyck

Unapplied item ledger entries in version 4.0 is fairly common. The fix, as Alex mentioned, is to do positive/negative adjustment entries making sure to not use the "Applies-To/From" functionality.

If the above solution is not practical, Version 5.0 has a Item Application Worksheet. You might want to try reverse engineering the functionality and implementing it on version 4.0.

Alex_Chow

DonDyck wrote:

If the above solution is not practical, Version 5.0 has a Item Application Worksheet. You might want to try reverse engineering the functionality and implementing it on version 4.0.

I wouldn't try to reverse engineer the item application worksheet from 5.0 to 4.0 just because you're messing with inventory cost. Inventory costing is uber sensitive.