Storing a Book cost as issued by a supplier and using this to mark up the product from this cost, but identify a discount against items to reflect the actual cost.
Storing a Wholesale cost as book cost and using the "extra" filed with a negative value as a percentge of the book cost to reflect a discount against the item. This can be a set amont or a percentage of the book cost.
Retial pricing is then set to markup from Wholesale instead of landed cost. The landed cost has the discount already recognized.
Video source: training:book_cost_vs_actual_cost0802181257.flv
Created by Charlene Scott at 18/02/2008 12:57:10 PM