Navision 4.0 > Remaining Qty in Item ledger Entry Negative

william_akihisa

Dear,

I need help with to fix Total Remaining Qty of Item Ledger Entry, first i want to explain why this situation occurred.
Before our database server got crashed and Table Item Ledger Entry got un-repaireable data. and then some one
had inserted the Item Ledger Entry data with Value Entry completely (all including Quantity, Remaining Quantity, and Cost)
in result when ever User want to make Invoice Sales or Return Order, the system rejecting the process because of the Remaining Quantity is negative in total.
So far i have tried to Querrying the Item Ledger Entry and found that many Items with Open = Yes and Applies-to Entry = 0
with negative Qty and Cost.
Could i try to fix this with :
1. Make an Item Journal Positive and Apply it with the Negative Entries with the same Qty and Cost Amount?
2. After that Adjust Cost to fix the Value Entry according to Item Ledger Entry

Can someone advise me, if these solutions are correct? or Anyone have other options? thanks in advance.

vaprog

william_akihisa wrote:

and then some one had inserted the Item Ledger Entry data with Value Entry completely (all including Quantity, Remaining Quantity, and Cost

I don't understand exactly what you did to replace lost data, but before you do any more posting, make sure "Item Application Entry"s are consistent (no loose ends (pointing to non-existent entries), no over-applications, no applications between different items ...). You can then recalculate "Remaining Quantity" (including Open and Positive) based on those entries and finally post applications lost in the process.

Regarding cost: There are no such values in "Item Ledger Entry", only FlowFields. So make sure, value entries are consistent ie. are associated with the right ILE.
It might help to reset and recalculate item adjustments, once everything else is straightened out.

Only after the whole system is consistent again, should you consider posting corrections to re-align the system with the real world.

william_akihisa

Thanks Sir Vaprog,

i will try to figure the right amount for remaining quantity based on Item Application Entry table..
maybe i will tell the user to adjust cost after we fix all mess in item ledger entry.