>Hi,
>Thank you.
>Don't know should I ask this question again, since I ask before. However, I still can't get it.
>
>Since, weighted cost will be calc and stored in stock header file and also with transaction file.
The transaction file will have the actual cost of the purchase transaction. Sells will be rolled out at average cost, thus, will not affect the weigheted cost. Since the header file will manage the weighted average cost of all purchase, a back log report would need to caluculate the weighted cost of just those transactions being reported on. This would be a differnt cost (most likely) than the "total" weighted average cost off all the transactions.

trans 1 = 100 shares at 10/share  trans 1 cost = 1000
trans 2 = 100 shares at 12/share  trans 2 cost = 1200
trans 3 = 100 shares at  9/share  trans 3 cost =  900
trans 4 = 100 shares at 10/share  trans 4 cost = 1000

Header totals
Total Shares = 400
Total Cost   = 4100
Weighted average cost = 4100/400 = 10.25/share

Back log costing for trans 3 and 4
trans 3 = 100 shares at  9/share  trans 3 cost =  900
trans 4 = 100 shares at 10/share  trans 4 cost = 1000
Backlog total shares = 200
Backlog total cost =  1900
Backlog weighted average cost = 1900/200 = 9.5/share

What would you do if user do backlog job like key in purchases for last week? Then the weighted cost in stock header and transaction will be incorrect.

The weighted cost in the header would be the weighted cost of all shares

>
>BTW, my application allow user to generate stock ledger/stock valuation report from period, eg. only from last monday to last friday.

The cost will remain the same, regardless of market value - the market value will float - but, luckily, it will apply to all the shares of a particular stock, and not purchase or settlement orders:-).

>
>Thank you