Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012719Openbravo ERP07. Sales managementpublic2010-03-18 08:002011-07-20 18:12
Reporterneil_smith 
Assigned Tojonalegriaesarte 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012719: Allow to change the ordered quantity even if delivered or invoiced.
DescriptionIt is not possible to change the ordered quantity of a sales invoice line if it has been delivered or invoiced (partially or completely).
Wouldn't it be possible to change the trigger to allow to change the quantity only if it is greater than the quantity that is already delivered or invoiced?
Steps To ReproduceCreate an order with an orderline and complete it.
Deliver and/or invoice this line.
Reactivate the order and try to change the quantity and you get the error 'DeliveredInvoiceOrderline'.
Proposed SolutionChange the c_orderline_chk_restrictions_trg trigger.
Line 73 :
        ELSIF (v_IsSOTrx ='Y' AND v_DocStatus = 'DR' AND (OLD.QTYDELIVERED <> 0 OR OLD.QTYINVOICED <> 0)) THEN

To :
        ELSIF (v_IsSOTrx ='Y' AND v_DocStatus = 'DR' AND (OLD.QTYDELIVERED > NEW.QTYORDERED OR OLD.QTYINVOICED > NEW.QTYORDERED)) THEN
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-18 08:00neil_smithNew Issue
2010-03-18 08:00neil_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.