Hi,
I used to think the posibility you mentioned, however there will be problem:
1. my application allow user to stock in, good return and etc backdated. If user add/edit invoise from supplier for last week, then the weighted cost I stored will be invalid. Re-calc of weighted cost may cause poor performance while saving such transaction.
Any advise? Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...