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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035798
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2017-04-19 11:012017-12-19 16:14
ReporterngarciaView Statuspublic 
Assigned Tocollazoandy4 
PriorityhighResolutionopenFixed in Version
StatusscheduledFix 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

0035798: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0101138)
collazoandy4 (reporter)
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

- Issue History
Date Modified Username Field Change
2017-04-19 11:01 ngarcia New Issue
2017-04-19 11:01 ngarcia Assigned To => Triage Finance
2017-04-19 11:01 ngarcia Modules => Core
2017-04-19 11:01 ngarcia Triggers an Emergency Pack => No
2017-04-19 11:01 ngarcia Issue Monitored: networkb
2017-04-19 13:39 heccam Issue Monitored: heccam
2017-12-18 20:53 collazoandy4 Assigned To Triage Finance => collazoandy4
2017-12-18 20:53 collazoandy4 Status new => scheduled
2017-12-19 16:14 collazoandy4 Note Added: 0101138

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker