I'm sorry if this is the wrong area, it is so far the most relevant I've been able to find on a Google search. Looking for people who have experience with warehouse management systems for some guidance.
There are several ways to imply the cost of goods (e.g. average cost of stock-on-hand, FIFO, LIFO, supplier purchase price). Our WMS design is still fairly lightweight and am looking to develop configurable options for each of the above. If selling in-stocked goods, it will be relatively straight forward to calculate customer pricing based on one of these options (e.g. 20% margin on average cost).
If however, the order is partially on backorder and a purchase order is required to help fulfil the order, I am not sure what is the most logical way to calculate the customer price. Do other implementations generally just base it on the supplier purchase price, or would it make more sense to just use the average cost (and then add margin) regardless of how much stock is on hand?