Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0012723 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
feature request | [Openbravo ERP] 07. Sales management | major | always | 2010-03-18 09:37 | 2011-07-20 18:12 | |||||||
Reporter | neil_smith | View Status | public | |||||||||
Assigned To | jonalegriaesarte | |||||||||||
Priority | high | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | SCM revision | |||||||||||
Review Assigned To | ||||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0012723: Deliver and invoice more than the ordered quantity | |||||||||||
Description | 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? | |||||||||||
Steps To Reproduce | 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. | |||||||||||
Proposed Solution | 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-- | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Issue History | |||
Date Modified | Username | Field | Change |
2010-03-18 09:37 | neil_smith | New Issue | |
2010-03-18 09:37 | neil_smith | Assigned To | => adrianromero |
2011-06-03 10:59 | dalsasua | Assigned To | adrianromero => dalsasua |
2011-07-20 18:12 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
Copyright © 2000 - 2009 MantisBT Group |