[WebERP-developers] inventory costing

[AndyThompson <ath...@mo...>]

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