What's the problem with, minus quantity?

[didi ber]

Hello!

if i make a invoice with quantity "-20"
rigth minus!



then the same stock

i make a mm_recept of 100
after invoice should be 120

pleace help!
greetings
Dietmar Berlinger

[didi ber]

[Carlos Antonio Ruiz Gomez]

Hi Dietmar, invoice does not affect stock, just inventory documents.

Regards,

Carlos Ruiz

On 04/05/15 a las 12:57, didi ber wrote:

Hello!

if i make a invoice with quantity "-20"
rigth minus!

then the same stock

i make a mm_recept of 100
after invoice should be 120

pleace help!
greetings
Dietmar Berlinger

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/05548fc1-f88c-4f78-81da-6aee4fc7926b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[redhuan d. oon]

Yes Dietmar, you will end up with two sets of Invoices and two sets of Shipment/Receipts records. Same like this http://red1.org/adempiere/viewtopic.php?f=45&t=1807

On Monday, 4 May 2015 20:45:04 UTC+2, Carlos Antonio Ruiz Gómez wrote:

Hi Dietmar, invoice does not affect stock, just inventory documents.

Regards,

Carlos Ruiz



On 04/05/15 a las 12:57, didi ber wrote:

Hello!

if i make a invoice with quantity "-20"
rigth minus!



then the same stock

i make a mm_recept of 100
after invoice should be 120

pleace help!
greetings
Dietmar Berlinger

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.

To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+unsubscribe@googlegroups.com.

[didi ber]

ok!

minus quantity is not working in idempiere.

please make this simple basic funktionality.

is very importent to make orders with minus idems.
all shops here work so.

is to much, make in the same time a order and a rma. all 1 min.
you now deal with bottels, the give and take in the same time, also onliy give ...
if is in the next day or h, then he can make a rma or a creditmemo.

for my customer is to hard to handl ...

i found a solution with product and minus price ...
is also not grade becose i need from every produckt 2 and this is mutch and confusing
also i have to calculate with hand the stock ...
it was just an idea, he must start to work with idempiere now ...

yes just temporary, then i have all product 2 times, 1 with + 1 with -, and i dont try this all with a bill of material, is also not working in mm_recept and so on.
i cant give him a solution with this ... is not working here ...

we can change the code to do minus but do you know the accounting consequence and stock changes?

i say YES

Regards

[Carlos Antonio Ruiz Gomez]

> minus quantity is not working in idempiere.

AFAIK negative quantities are OK and properly managed.

http://www.catb.org/esr/faqs/smart-questions.html

[didi ber]

Hello Carlos!

Now i make a Sales Order, in test.Idempiere.com

Business Partner: Joe Block
Target Document Type: POS Order

with 2 items
1 Oak_Oak Tree with quantity  20
1 Oak_Oak Tree with quantity -15

Then i Completed

I become the error: Failed when processing document - More than line qty on attribute tab for line 20

refer to the pic

Now i make the same just change to

Target Document Type: Standard Order

and i can Completed without error

and now i look to the inventory and:

only the position 10 20 quantity has been taken into account.
the position 20 with -15 quantity was not taken into account.

refer to the pic.

so please help, is an importtent issue.
i need this funktion negative quantities like bred.

Regards
Dietmar Berlinger

[redhuan d. oon]

Yes i test the same, Order, Invoice, Shipment are OK, but the Product Info for Warehouse Locator just show the positive qty and not the negative. If Carlos agrees, i will raise a JIRA ticket and fix it.

[Carlos Antonio Ruiz Gomez]

Hi, I don't see the bug, in the screenshot uploaded for product info is showing Available to Promise, not Stock.

[redhuan d. oon]

Hm, i don't see the minus stock either. What am i missing Carlos?
I debug when POS Order, with a minus, it does not allow as Dietmar reported and the code that traps it:

                //Ignore the Material Policy when is Reverse Correction
                if(!isReversal())
                {
                    BigDecimal movementQty = sLine.getMovementQty();
                    BigDecimal qtyOnLineMA = MInOutLineMA.getManualQty(sLine.getM_InOutLine_ID(), get_TrxName());
                   
                    if(qtyOnLineMA.compareTo(movementQty)>0)
                    {
                        // More then line qty on attribute tab for line 10
                        m_processMsg = "@Over_Qty_On_Attribute_Tab@ " + sLine.getLine();
                        return DOCSTATUS_Invalid;
                    }
                   
                    checkMaterialPolicy(sLine,movementQty.subtract(qtyOnLineMA));
                }

I will research further if this is a bug.

[Carlos Antonio Ruiz Gómez]

Diego followed the issue in negative order and confirmed it as a bug.

Traced the origin was caused by IDEMPIERE-1770 - please check this comment

Now negatives are allowed again in sales orders and shipments.

[Diego Ruiz]

Tested and it's working fine, it updates the inventory and create the right documents.

Thanks.