Hi All,
we are using the weighted average method, with Axapta 3.0 SP5. we
are facing
the following problems,
1.The item movement journal lines shows the correct cost price &
cost amount before posting, when you click post it picks the
weighted avg value of that particular item from PO line and post the
ledger. Hence the cost price and amount is changed in the ledger. It
is surprising that the value shown in the Item movement journal is
changed when you post the entry.
2.The cost price and amount shown correctly in Onhand stock also
gets changed drastically after running recalculation.
Desc BatchNo. Qty Rate/Kg ProdVal TotVal Cost/KG Wt.Avg
Purchase A01 1000 75 75000 83000 83
ISSUE A01 -200 83 -16600 -16600 83
Purchase A02 1000 80 80000 88200 88.2 85.89
ISSUE A02 -300 85.89 -25767 -25767 85.89
ISSUE A02 -200 85.89 -17178 -17178 85.89
Total 1300 95455 111655 85.89
Error Description
Description Qty Rate/Kg Product Total Value
ISSUE correct A01 -300 85.89 -25767 -17178
ISSUE Error A02 -200 85.89 -17178 -17640
ISSUE correct A02 -200 88.2 -17640 -25767
ISSUE Error A01 -300 83 -24900 -24900
The above describes like instead of taking the wt.avg cost and
posting, system picks the wt. avg from PO line and post into the
ledger
Can anyone throw some ideas to solve this "abnormal behaviour"?
Thanks in advance.
Cheers,
Honey
