hi,
i make a daily issuance report In report i use blow field

Date product issue avgrate total


now i want to some changing in my report avgrate replace to latest product rate for example

i purschase Ring Travelers in 5/2/2010 Rs:350 issunace report show this rate in 5/2/2010

next day i purchase Ring Travelers in different Rate that is 400 the report of 5/3/2010 show these rates of this product

hope u understand.

please help me

i am waiting your reply

Best Regard
 Muhammad Jawad Khatri