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

View Revisions: Issue #26823 All Revisions ] 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 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker