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

View Revisions: Issue #40676 Back to Issue ]
Summary 0040676: Valued Stock Report not properly working when movementDate has more precision than days and aggregated data
Revision 2019-04-25 09:59 by dmiguelez
Steps To Reproduce The queries in the Valued Stock report assume that the precision of the movementDate field is days, if it has a greater precision than that, the values shown in the report might not be correct.

This happens when there is aggregated data
Revision 2019-04-24 17:49 by dmiguelez
Steps To Reproduce Log in as F&B Admin

Go to Valued Stock Report Window and launch the report with the parameters:
  * Organization: F&B EspaƱa
  * Warehouse: Empty
  * Date: 30-04-2013
  * Consolidated Warehouse: true
  * Product Category: Empty
  * Currency: EUR
Check that for Cerveza Ale there is a line with 158.480,00 Quantity

Go to process request window and create a new record with:
  * Organization: *
  * Process: Generate Aggregated Data Background
  * Timing: Run Immediately
Click on Schedule process and wait until there is a line with success status in the Process Monitor Tab

Return to the Valued Stock Report and launch it again with the same parameters.
The Quantity for Ale Beer is 103.480,00 which is wrong


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker