mosa
Member
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?
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?