39 Advanced Stock Valuation

[mosa]

Dear all:

Do you have any setup documents for Advanced Stock Valuation?
My client need to recalculate COGS with monthly weighted average cost.
Examples of Monthly Weighted Average

F4111 The Incoming transaction:
IC 1000EA* $13.6656=$13665.6
IA 10EA*$ 13.7771=$137.77
IC 200EA* $13.6656=$2733.12
IC 100EA*$14=$1400
IC 1000EA*$13.6656=$13665.6
IC 1000EA*$14.7322=$14732.16
Total 3310EA,Amount $46,334.25,

F4111 The outgoing transaction:
II -50EA* $13.7771= $-688.86
SO -1000EA*$ 14.0602=$ -14060.2
SO -500EA* $13.6784=$ -6839.2
Total -1550EA,Amount $-21,588.26

Setup:
Activate Advanced Stock Valuation P99410
Stock Valuation Constants P39042 Company 00000 is set for processing type On-Line
Valuation Method P3905 is set 10 Weighted Average by Branch
Document Type Maintenance P40040

If it is to achieve the desired results,
RUN R39120/R39130,Average cost for all incoming is calculated first,it will be $13.9983($46,334.25/3310EA),
Then recalculate the COGS and inventory,COGS=-1550EA*$13.9983=$-21,697.31,
Inventory Amount will be $46,334.25+$-21,697.31=$24,636.94,
The Inventory Stock Valuation-Adjustment is -109.05,
Cost of Goods Sold-Adjustment is 109.05,
JE
Dr:COGS-ASV 109.05
Cr:Inventory-ASV 109.05

BUT RUN R39120/R39130, Average cost IS WRONG,
Dr:COGS-ASV 24,745.99
Cr:Inventory-ASV 24745.99
WHY?