|
From: AndyThompson <ath...@mo...> - 2005-10-31 17:13:11
|
Well my previous discussion seems to have fizzled out :) I am still interested in developing this but will need a little guidance from everyone (anyone?) concerned as to the best way to develop it. Starting with receiving and item transfers first off I guess. Phil pointed out that the stockmoves table tracks some of what I'm after currently. There is a price column and a standardcost column in that table which seems a bit ambiguous to me. And they are not updated consistently as far as I can tell. I guess the primary things I can see missing from that table is the ability to track a quantity sold from the move record and possibly a column to track when the record is entirely sold to be used to narrow the result when looking for a cost. Also figure out the existing price/standardcost updates that are missing and get them fixed up. I would almost prefer to add a generic "cost" column to the table and use that at least for the FIFO costing lookups to remove any ambiguity. -andy |