In my Inventory Database, I have purchasing functions and issuing function and inventory tracking functions. Because I have a PO Details table which includes lines for each inventory item and its current price on any given PO, I really have a defacto serial number for each part/PO combination. For job costing purposes, this would be very useful to develop. I can think of several directions to take in order to tie Part, Price, PO Line and Job together to establish a true cost but none of my thoughts seem to efficient to me.
On a theoretical basis, how would you do this???
On a theoretical basis, how would you do this???
