Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041714Openbravo ERP07. Sales managementpublic2019-08-28 14:592019-09-04 16:37
Reporterngarcia 
Assigned Tocollazoandy4 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q4 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket10768
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041714: Sales Invoice Dimensional Report should not take into account the not unit cost adjustments
DescriptionSales Invoice Dimensional Report should not take into account the not unit cost adjustments
Steps To ReproduceAs group admin role:
   Set the 'Enable Negative Stock Correction' preference to Y
   Log out and log in

   Create a new product
   Set a storage bin as Undefined-Overissue to allow negative stock
   Add a manual average cost
   Create a Goods Shipment
   Add previously created product and complete it
   Invoice it

   Create a Purchase Order with a price different from the average cost
   Create the related goods receipt and complete it

   Create a goods shipment in order to leave the stock negative

   Create a Return from Customer and select the line from the first goods shipment
   Create the related Return Material Receipt
   Invoice it

   Launch the costing background process and check the transaction related with the Return Material Receipt line has created a negative stock correction

   Launch the Sales Invoice dimensional report:
      Dimensions: Documentno, Product
   Filter by the product created
   Check the cost in the line related with the Return invoice includes the amount of the negative stock correction too
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-08-28 14:59ngarciaNew Issue
2019-08-28 14:59ngarciaAssigned To => Triage Finance
2019-08-28 14:59ngarciaOBNetwork customer => OBPS
2019-08-28 14:59ngarciaModules => Core
2019-08-28 14:59ngarciaSupport ticket => 10768
2019-08-28 14:59ngarciaResolution time => 1568757600
2019-08-28 14:59ngarciaTriggers an Emergency Pack => No
2019-08-28 14:59ngarciaIssue Monitored: networkb
2019-08-29 07:42rafarodaIssue Monitored: rafaroda
2019-08-29 11:24SandrahuguetAssigned ToTriage Finance => collazoandy4
2019-08-29 15:30collazoandy4Statusnew => scheduled
2019-09-02 01:06collazoandy4Note Added: 0114352
2019-09-04 09:18hgbotCheckin
2019-09-04 09:18hgbotNote Added: 0114389
2019-09-04 09:18hgbotStatusscheduled => resolved
2019-09-04 09:18hgbotResolutionopen => fixed
2019-09-04 09:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4a816bcdc22cbed11c62a1859c78e06d97e6a155 [^]
2019-09-04 09:19SandrahuguetReview Assigned To => Sandrahuguet
2019-09-04 09:19SandrahuguetNote Added: 0114390
2019-09-04 09:19SandrahuguetStatusresolved => closed
2019-09-04 09:19SandrahuguetFixed in Version => 3.0PR19Q4
2019-09-04 16:37hudsonbotCheckin
2019-09-04 16:37hudsonbotNote Added: 0114402

Notes
(0114352)
collazoandy4   
2019-09-02 01:06   
Test Plan
   As System Admin Role:
     Set the 'Enable Negative Stock Correction' preference to Y
     Log out and log in
   As Group Admin Role
     Go to Warehouse and Storage bin and select Region Norte record
       Set the Rn-0-0-0 bin to Undefined-Overissue
     Go to Product window and create a new Product:
       Search Key/Name: Product
       Create a new record in Costing Tab:
         Cost Type: Average
         Cost: 10
         Starting Date: First month day
         Ending Date: Last month day
     Create a new Goods Shipment for 10 Units of previous product in Rn-0-0-0 bin
     Invoice this receipt
     Add to the previous product created a new record in Price tab for Tarifa de Bebidas Alegres with Unit/List Price: 5
     Create a new Purchase Order of 15 for this product
     Receipt the previous Order in Rn-0-0-0
     Create a new Goods Shipment with 7 units and check the product stock in Rn-0-0-0 is negative (-2)
     Create a new Return from Customer from the first shipment (10 units)
     Create a new Return Material Recipt from te previous RFC
     Invoice the RM Receipt
     Execute the Costing Background Process and check the transaccion line in Transaction tab for the Product have a negative stock correction
     Run the Sales Invoice Dimensional Report and check the negative stock correction from the transaction is not taked into account
(0114389)
hgbot   
2019-09-04 09:18   
Repository: erp/devel/pi
Changeset: 4a816bcdc22cbed11c62a1859c78e06d97e6a155
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Sun Sep 01 16:46:06 2019 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/4a816bcdc22cbed11c62a1859c78e06d97e6a155 [^]

Fixes issue 41714: Sales Invoice Dimensional Report should not take into account
the not unit cost adjustments

A new filter was added to only take into account if the cost is unit cost

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0114390)
Sandrahuguet   
2019-09-04 09:19   
code review + testing ok
(0114402)
hudsonbot   
2019-09-04 16:37   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/2e882fde1e88 [^]
Maturity status: Test