Finish implementation of weighted average costing

First step:
- implement the ProcessedOn column that Heng Sin added to the documents ... working on it

First step:
- implement the ProcessedOn column

Committed with revision 11558
http://adempiere.svn.sourceforge.net/adempiere/?rev=11558&view=rev

The new column ProcessedOn is calculated automatically on PO.java when the document changes the Processed column from N to Y

Committed migration script to fill the ProcessedOn column based on AD_ChangeLog, then AD_WF_Activity, then column Updated of the document

Next step:
Implement AcctProcessor to process the documents in the order they were processed (Heng Sin already did this on branch - I'll try to apply some potential improvements to the algorithm).

Regards,

Carlos Ruiz

revision 11558 integrated to release with revision 11572
even this work is still incomplete and in progress - the addition of the column is needed for many purposes

Committed revision 11599
http://adempiere.svn.sourceforge.net/adempiere/?rev=11599&view=rev

Second step:
Implemented AcctProcessor to post the documents in the order they were processed.
Changes from Heng Sin's version:
- Post also possible NULL values on ProcessedOn
- Summarized summary of documents posted
- Implemented also for ClientAcctProcessor

With this new approach I would recommend this index for document tables with big number of records:
Index on (posted, processed, processedon)

Next step:
Create default account for Average Cost Variance.

Regards,

Carlos Ruiz

revision 11599 integrated to release with revision 11619
even this work is still incomplete and in progress - the processing of documents in the order they were completed is needed for many purposes

Committed revision 11624
http://adempiere.svn.sourceforge.net/adempiere/?rev=11624&view=rev
Also committed 11625 for adempiereAcctEdit project

Third step:
Created the default account for Average Cost Variance.

Next step:
Start testing and fixing the weighted average costing.
Use the new Average Cost Variance when costing a receipt with negative inventory.

Regards,

Carlos Ruiz

revision 11624 arrived to /release with revision 11665

Committed revision 11710.
http://adempiere.svn.sourceforge.net/adempiere/?rev=11710&view=rev

Found problems when committing inout and invoice - the generated matchinv and matchpo must be posted after.

Regards,

Carlos Ruiz

Committed revision 11806.
http://adempiere.svn.sourceforge.net/adempiere/?rev=11806&view=rev
* Update MatchInv ProcessedOn to happen after invoice ProcessedOn (for a better reposting process)
* Added ProcessedOn column to RV_Unposted view and window
* minor fix in MCost - printing wrong variable in log

Regards,

Carlos Ruiz

revisions 11710, 11806 integrated to release with 11832

Revision 11710 caused an issue reported in
Bug [2982558] C_InvoiceLine and C_OrderLine's QtyInvoiced do not match
Fixed with revision 11901
http://adempiere.svn.sourceforge.net/adempiere/?rev=11901&view=rev

Regards,

Carlos Ruiz

implemented history of costs in M_CostDetail with revision 11920
http://adempiere.svn.sourceforge.net/adempiere/?rev=11920&view=rev

Integrated revision 11920 to release with revision 11993

revision 12064
implement history of costs in M_CostDetail
as orders can be reopened - better assign matchpo just with invoice and not with order
integrated to release with revision 12077

small correction: it is Rev. 12046

Mario Calderon

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 15 days (the time period specified by
the administrator of this Tracker).