Hi.
I need to implement an Average Weighted cost (AWC) feature into pretty much all my database projects, so i was wondering what is a good way to design this feature? i dont care about implementation, just the concept/planning.
if no-one knows what 'average weighted cost' means, ask me and i'll explain it in detail
i just want ideas on how to do it, examples would be cool, but general thoughts and ideas would be fine.
the main problem is when stock is ordered, this affects the average weighted cost for the particular 'batch' of the product, not the product in total/general
I need to implement an Average Weighted cost (AWC) feature into pretty much all my database projects, so i was wondering what is a good way to design this feature? i dont care about implementation, just the concept/planning.
if no-one knows what 'average weighted cost' means, ask me and i'll explain it in detail
i just want ideas on how to do it, examples would be cool, but general thoughts and ideas would be fine.
the main problem is when stock is ordered, this affects the average weighted cost for the particular 'batch' of the product, not the product in total/general