Project:
| View Revisions: Issue #26823 | [ Back to Issue ] | ||
| Summary | 0026823: the transaction cost of the Valued Stock report should be filtered regarding the movement date | ||
| Revision | 2014-06-10 16:39 by gorkaion | ||
| Steps To Reproduce | 1 Launch the report on 1st of current month. for US East Coast, Alcoholic product category and USD currency. 2. Take note of the Stock, cost and valuation of Ale Beer. In my case: 149100.00 Unit 1.36 202,776.00 3. Create a shipment of Ale Beer with movement date on previous month. 4. Launch the report again. If the cost of the shipment is not yet calculated a warning appears and a new line for Ale Beer appears without any cost or valuation. 5. Ensure that the costing background is run and that the transaction is calculated by checking in the transaction tab of Product. 6. Launch again the report. The warning dissapears and the line without cost or valuation as well. The line of Ale beer is updated so the quantity is considering our shipment, but the valuation amount remains the same as it is not including the cost of the shipment. These are the values I get after a shipment of 10000 units of Ale beer: 139100.00 Unit 1.46 202,776.00 Note the quantity is now 193100 but the valuation is still 202776. This makes the average cost to change from 1.36 to 1.46. |
||
| Revision | 2014-06-10 16:39 by gorkaion | ||
| Steps To Reproduce | 1 Launch the report on 1st of current month. for US East Coast, Alcoholic product category and USD currency. 2. Take note of the Stock, cost and valuation of Ale Beer. In my case: 149100.00 Unit 1.36 202,776.00 3. Create a shipment of Ale Beer with movement date on previous month. 4. Launch the report again. If the cost of the shipment is not yet calculated a warning appears and a new line for Ale Beer appears without any cost or valuation. 5. Ensure that the costing background is run and that the transaction is calculated by checking in the transaction tab of Product. 6. Launch again the report. The warning dissapears and the line without cost or valuation as well. The line of Ale beer is updated so the quantity is considering our shipment, but the valuation amount remains the same as it is not including the cost of the shipment. This is the values I get after a shipment of 10000 units of Ale beer: 139100.00 Unit 1.46 202,776.00 Note the quantity is now 193100 but the valuation is still 202776. This makes the average cost to change from 1.36 to 1.46. |
||
| Revision | 2014-06-10 16:39 by gorkaion | ||
| Description | The cost of each transaction should be taken into account regarding the movement date not the transaction process date This report is currently using date parameter to filter the query in 2 places. For one side it is filtering the transactions by the movement date. It only considers transactions with movement date equal or before the given date. The stock quantity is the sum of the movement quantities of these transactions. This is correct. For another side this given date is also used to filter the available cost calculations for each transaction. Filtering them by the date they were calculated. So if a transcation cost was calculated on a date after the movement date its cost won't be available on the report if this is filtered by the transaction's movement date. This is incorrect. |
||
| Revision | 2014-06-10 15:32 by gorkaion | ||
| Steps To Reproduce | The cost of each transaction should be taken into account regarding the movement date not the transaction process date | ||
| Revision | 2014-06-10 15:32 by gorkaion | ||
| Description | The cost of each transaction should be taken into account regarding the movement date not the transaction process date | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |