Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Cost price , Selling Price
Hi

I would like to know if anyone has figured out how to handle inventory products that may have a change in cost price over time.

For example a
BLUETSHIRT in 2012 cost $10.00 @ 50 pcs
&
BLUESHIRT in 2013 cost $12.00 @ 20 pcs

what is the best way to handle this from a master inventory table point of view/
do i have two separate SKU's for the same product? or do i average out the price?
what i would rather do is use the latest higher price of the two, but would still like to dril down to see historical pricing.

thanks.
ID
851
Category
Other
Author

rishi uttam
Date Created
3/25/2015 11:50:53 AM
Date Updated
3/28/2015 1:04:11 PM
Comments
basenine 3/25/2015 12:40:53 PM
Have done this by creating a new table called Historical Price. Every time the price changes in the Parent table, it creates a new record in the Historical Price table via a workflow trigger...when record is added or modified...in column Buy Price...create new record in Historical Price. Push through the Parent table id , the price etc into the new (related) record

The most recent price is now pushed through to the new record and is also held in the parent record for use in your other tables.
You can set up a Custom Button with Mass select function to go through all of your current materials/inventory and create the first Historical Price record. Every time you create a new parent record, it will also create a new historical price record.

Hope this helps
Philipp Matuschka 3/28/2015 1:04:11 PM
Or you could have Valid From and Valid To dates in the historical pricing table and include <= and > then reference date in the matching conditions for the reference from the Parent table. That's how I generally do it.
Feedback
Back to Search Results