After many rounds of discussion, we have finally decided to compute Last Purchased Cost for Items with Purchase Price. If the last purchase item is free of charge, we would ignore the zero price.
For example:
Item ABC Purchased at 2 Dates:
01/01/2011 RM 30
05/02/2011 Free of Charge RM 0
Last Purchase Price --> RM 30
Scope affected:
1. Master File --> Stock --> Profile --> Last Purchased Price
2. Sales Order Analysis with Last Purchased Cost
3. Sales Invoice Analysis with Last Purchased Cost
4. Stock Movement - On Hand Quantity by Warehouse (Daily) with Closing Cost