Internal Use with zero qty is dropping the inventory

Description

As reported by Edwin here:
https://groups.google.com/d/topic/idempiere/DtRz9g6Y0Wk/discussion

Hi All,

I just noticed this lately when our user reported that some Internal Use Inventory documents are missing after complete. Upon tracing we found out that, the user has set internal use qty for all lines to 0. When completed, the document are processed as Physical Inventory document and worse the qty book is 0.
So basically this will clear up the storage.
This behaviour is observed at Adempiere361 and I've just confirmed that this is still a current issue on demo.idempiere.com.

A quick solution is to add a flag isInternalUse on M_Inventory to differ the document processing.

Why do you think?

Regards,

Edwin Ang

Environment

None

Activity

Show:
Edwin Ang
March 29, 2013, 8:15 AM

checked CalloutInventory, no change required IF we are ok that QtyCount and Qtybook in INTERNAL USE do not need to be zero. Currently all codes that relate to INTERNAL USE is ignoring them. But probably to avoid confusion for report creator, it is better to set them to zero.
checked Doc_Inventory, done a little modification.

Edwin Ang
March 29, 2013, 11:08 AM

Added migration script to update WhereClause untuk window Physical Inventory and Internal Use Inventory.

Carlos Ruiz
April 3, 2013, 11:54 PM

Thanks Edwin, I made some additional changes on https://bitbucket.org/idempiere/idempiere/commits/98bcd80

Can you please review and test.

Regards,

Carlos Ruiz

Carlos Ruiz
April 4, 2013, 12:26 AM

A migration note for this ticket was added here:
http://wiki.idempiere.org/en/Migration_Notes#Inventory_Document_Types

Assignee

Edwin Ang

Reporter

Edwin Ang

Labels

None

Tested By

None

Components

Affects versions

Priority

Blocker
Configure