Negative Remaining Quantity

Shinis

Hi,

For one of my customer using NAV 4 SP3, some item ledger entries are not applied to each other. Due to this there is a Remaining quanity in both the inbound and outbound item ledg entries eventhough the net inventory is zero. This issue is found only for few entries and for few items. Since it is NAV 4 SP3, we couldn't use the Item application entry worksheet to apply. They are using Average Costing method. I've checked the inbound entry "posting date" and "Item Ledg ENtry no" or earlier than the outbound entry.

Please suggest any solution / bug fix available for this. we can apply directly in the backend in the Item Appln entry. But need to understand why the system failed to apply automatically while posting the outbound. Due to the above problem, when they run "Calculate Inventory" batch job from Revaluation journal, it includes the inbound entry as it is still due to it is not applied to the respective outbound entry. Please advice.

MarkHamblin

We've seen this on Navision 4 SP3 with one of our clients as well. Don't know what the specific cause is, but it seems to occur more when doing negative consumption or other transactions where the transaction is manually applied (e.g., using Apply-to item entry field). The incidence of this slowed down a lot after the client reduced the use of manual applications.

We have never found a resolution and repair the entries via the back end when required (it happens very rarely now). Would be nice to know if someone else has found a resolution.

Sog

When the client uses advanced warehousing and/or production. NAV4SP3 is bugged and not an adequate solution in matters of costing.
An upgrade to NAV 5 and beyond is the only sane recommendation I can give.