Inconsistency Insertion Lots in the Physical Inventory window

Description

see: https://groups.google.com/d/msg/idempiere/BZknWTBdvdM/4NMh3KkTAQAJ

The case studies are as follows:
I have a new "Prod_Ex" product, this product has management with instance attributes, I want to inventory my lots.
I generated the Physical Inventory and in the Tab Attributes i insert their attributes:
qty 5 (attribute: AAA)
qty 7 (attribute: BBB)

The QtyCount will therefore be 5 + 7 = 12

The problem occurs when I go to complete the document. An attribute is automatically created with a moved qty = -24 (and M_Attributesetinstance_id=0).
I noticed that this works if I go to load my lots with a negative sign. Example -5 -7 and QtyCount = 12

Environment

None

Activity

Show:
Carlos Ruiz
August 22, 2020, 10:27 AM

Hi

I just simulated one case in triage4 server:
http://triage4.idempiere.org/webui/index.zul?Action=Zoom&AD_Table_ID=321&Record_ID=1000000

QtyBook=0
QtyCount=12

Carlos Ruiz
August 22, 2020, 10:30 AM

This is what I understand as wrong:

The document says:

  • there were zero items of the product (qtybook=0)

  • user counted 12, 5 AAA, 7 BBB

  • the system creates three transactions and stock:

    • 24 products without serial

    • negative 5 with AAA

    • negative 7 with BBB

  • I think the correct output must be the system creating in stock and transactions:

    • positive 5 with AAA

    • positive 7 with BBB

Carlos Ruiz
August 22, 2020, 10:36 AM

Two more test:

  • If tried the test with a warehouse that doesn't accept negative inventory the document cannot be completed.

  • when entering 5AAA and 7BBB in inventory lines (instead of attributes tab) then it works as expected.

Heng Sin Low
August 22, 2020, 10:45 AM

The qty 5 and 7 record at attribute tab is enter manually by the user, not created/generated by the system.

As it is, +ve qty at attribute tab is to reduce stock, and -ve is to increase stock. While changing that might seems more intuitive, we can’t do it as that will break backward compatibility.

Carlos Ruiz
August 22, 2020, 11:00 AM

Ah, I understand, that's why Andrea mentioned that entering negatives there worked fine.

Assignee

Unassigned

Reporter

Andrea Bellotto

Labels

Tested By

None

Components

Affects versions

Priority

Minor
Configure