Someone or some process has deleted teh item ledger entry that now requires adjustment, which would suggest you have a much bigger problem than just correcting an item ledger entry. Is this in a live environment dare I ask?
Well I have never hacked a system in this manner, and never would, so it is difficult to comment on “how” you would fix something.
I will not ask why you did this, but you obviously need to remove it from every related table and everywhere it is called in the adjust cost entry routine, this means painstakingly pulling apart the data relations for the mess created, you can get little help really, you have the data, you need to sort it.
Oh wow… Looks like this problem will be very ugly. For future reference, never EVER delete ledger entries. Especially one as sensitive as item ledger and value entry. All adjustments should be done in journals or documents.
My suggestion to you is to restore the entries as it was and try running adjust cost process. My fear is that your inventory value may be irreversibly damaged because of this… Should your inventory value be incorrect, you will need to replicate the transactions to see the true total and try to copy the exact contents over to the production ledger entries.
Well assuming you cannot restore a backup bacause of subsequent transactions do a test backup and manually recreate the ILE in the table if you can. A hack in should not be an issue as you hacked it out [:D]
Yep, you need to replicate the transactions for this item on a new database and copy the contents over to the ILE, VE, and G/L while ensuring the entries numbers are the same. Afterwards, you need to test the hell out of it.
I would estimate about 50-100 hours doing this depending on how much transactions you have.
It means there are issues with the data, a blank item will screw the routine, who knows what other errors exist when the data has been deleted directly in the tables? Very hard to assist you really, you need to keep trying to correct the errors one by one.
It doesn’t look like you replicated the data appropriately. You have to replicate the data using EXACTLY the documents that created them. So you need to recreate the purchase orders, sales orders, etc in the proper order. You also need to create the DELETED that were deleted.
Most of the case, this is not possible since no one know what was deleted. My best advice to you is to wipe out the item ledger, value entry, item application, and other related tables and positive adjust the beginning inventory. Needless to say, your item history is lost… [:(]
I really do not want to ask - you deleted the item?
The automatic cost posting depends on teh business and teh costing method and how often they want the true costs updated. So I would presume automatic cost posting is on, the automatic adjustment is a period and affects average costing calculations so it depends. You will still need to run the batch job, how often depends on teh needs. Each customer can be different!
I think in any case, the original poster is screwed. By deleting and manipulating the ledger entry and “deleting” transactions, I just don’t see how you can get reliable information out of it anymore. By prolonging the “deleteall and reimplement inventory”, the problem will just keep compounding.