Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012723Openbravo ERP07. Sales managementpublic2010-03-18 09:372011-07-20 18:12
neil_smith 
jonalegriaesarte 
highmajoralways
newopen 
5
 
 
Core
No
0012723: Deliver and invoice more than the ordered quantity
It is not possible to invoice a greater quantity than what was ordered.

It is important to be able to do this as for products ordered by weight, it is very often not possible to have the exact same weight ordered and delivered (and invoiced). It can be greater or smaller.
Why is this done like that?
Create an order for a customer with the invoice rule 'After Delivery' with an order line (quantity = 10 e.g.) and complete it.
Create a manual delivery and copy the line from the order and change the quantity to 10.2 e.g.
Then generate the invoices through the 'Create invoices from Orders' process and you will get the following error:
ERROR=NotPossibleCompleteInvoice 100088 line 10. OrderDocumentno 50189: QtyInvoicedHigherOrdered@.

The invoice is not created and it is not possible to create it.
Remove the test of the c_ordline_chk_restrictions_trg trigger (line 73 to 76)

      ELSIF (v_IsSOTrx = 'Y' AND ABS(new.QtyInvoiced) > ABS(new.QtyOrdered)) THEN
        v_Message := '@OrderDocumentno@' || ' ' || v_DocumentNo || ' ' || '@line@' || old.line || '. ';
        v_Message := v_Message || '@QtyInvoicedHigherOrdered@';
        RAISE EXCEPTION '%', v_Message; --OBTG:-20000--
No tags attached.
Issue History
2010-03-18 09:37neil_smithNew Issue
2010-03-18 09:37neil_smithAssigned To => adrianromero
2011-06-03 10:59dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:12dalsasuaAssigned Todalsasua => jonalegriaesarte

There are no notes attached to this issue.