Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035798Openbravo ERP07. Sales managementpublic2017-04-19 11:012017-12-19 16:14
Reporterngarcia 
Assigned Tocollazoandy4 
PriorityhighSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
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
Summary0035798: Invoiced Sales Order Report and Delivered Sales Order Report do not show negative sales order lines
DescriptionInvoiced Sales Order Report and Delivered Sales Order Report do not show negative sales order lines

The queries are filtered by

HAVING SUM(C_ORDERLINE.QTYINVOICED) > 0 (ReportSalesOrderInvoiced_data.xsql)
HAVING SUM(C_ORDERLINE.QTYDELIVERED) > 0
(ReportSalesOrderProvided_data.xsql)
Steps To ReproduceAs group admin role:

   Create a Sales Order, select POS Order document type
   Add 1 unit of a product with stock (A)
   Add a new line with -1 unit of the same product (A)
   Complete it

   Create a Sales Order, select POS Order document type
   Add -1 unit of a product with stock (B)
   Complete it

   Create a Sales Order, select POS Order document type
   Add 2 units of a product with stock different from the previous one (C)
   Add a new line with -1 unit of the same product (C)
   Complete it

   Launch the Delivered Sales Order Report and and Invoiced Sales Order Report and check:
      - Product A is not shown
      - Product B is not shown
      - 1 unit of Product C is shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-04-19 11:01ngarciaNew Issue
2017-04-19 11:01ngarciaAssigned To => Triage Finance
2017-04-19 11:01ngarciaModules => Core
2017-04-19 11:01ngarciaTriggers an Emergency Pack => No
2017-04-19 11:01ngarciaIssue Monitored: networkb
2017-04-19 13:39heccamIssue Monitored: heccam
2017-12-18 20:53collazoandy4Assigned ToTriage Finance => collazoandy4
2017-12-18 20:53collazoandy4Statusnew => scheduled
2017-12-19 16:14collazoandy4Note Added: 0101138

Notes
(0101138)
collazoandy4   
2017-12-19 16:14   
Test Plan
  As F&B International Group Admin Role
    Go to Sales Order window and create a new record:
      Transaction Document: POS Order
      Business Partner: Alimentos y Supermercados, S.A
      Create a new record in Lines tab:
        Product: Zumo de Piña 0,5L
        Ordered Quantity: 1
      Create another record in Lines tab:
        Product: Zumo de Piña 0,5L
        Ordered Quantity: -1
      Book the order and check a new shipment and invoice was created
    Launch the Invoiced Sales Order and Delivered Sales Order Reports and check the order line is shown in the report
    Go to Sales Order window and create a new record:
      Transaction Document: Standard Order
      Business Partner: Alimentos y Supermercados, S.A
      Create a new record in Lines tab:
        Product: Zumo de Pera 0,5L
        Ordered Quantity: 5
      Book the order
    Launch the Invoiced Sales Order and Delivered Sales Order Reports and check the order line is not shown in the report
    Go to Sales Invoice window and create a new record for Alimentos y Supermercados, S.A bp from the previous order created and complete it
    Launch the Invoiced Sales Order report and check the previous order is now shown
    Void the previous invoice and launch the Invoiced Sales Order report and check the previous order is not shown
    Create a shipment from the previous order and check in the Delivered Sales Order Report the order is shown
    Void the previous shipment and launch the Delivered Sales Order Report report and check the previous order is not shown