Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012723
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 07. Sales managementmajoralways2010-03-18 09:372011-07-20 18:12
Reporterneil_smithView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012723: Deliver and invoice more than the ordered quantity

DescriptionIt 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 ReproduceCreate 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 SolutionRemove 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--
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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
Powered by Mantis Bugtracker