NF1.0 Storage Improvements

Feature: Storage Improvements

Goal: Functional

Functional: Material Management

Contributor: Edwin Ang

Description:

Solve bugs in the table MStorage.

A big old issue inherited from Compiere times is that storage was recording reservations and on-hand quantities on the same table with different needs, for example on-hand requires a locator - meanwhile reservations don't need that, also the attribute set instance managing for both can be different. This architectural issue was leading to negative quantities on reservations which sometimes led to data corruption - and made the real control of quantities too hard to track.

In iDempiere the storage table was split in two: on-hand storage (m_storageonhand) and reservation storage (m_storagereservation), the old m_storage table was converted to a view for backward compatibility (avoid breaking your old reports based on storage table), a reservation locator (just for reporting purposes) can be configured on warehouse table

Technical Info: IDEMPIERE-385