Re: [WebERP-developers] inventory costing

[Phil D. <we...@pa...>]

> That does bring up a couple other questions, what is the negative record
> in the stockmoves table used for?  Reporting?  


Not sure what you mean here?


> And why do you leave a 
> record in the stockserialitems table for serialized inventory with a
> zero quantity?

To show that the item once existed in stock.

>
> > Personally I am a big fan of standard costing because:
>
> I've read up on it a bit.  Seems like it would be ok for a smallish,
> slow moving inventory.  Even with only a few thousand items, which might
> be small in some regards, standard costing seems like it would be
> tedious to maintain.  Especially in a quickly changing market where
> supplier prices can be different from week to week.  I will use the
> disclaimer that these are observations from someone who has never used
> standard costing.
>
> Regardless, I don't want this to become a discussion about the merits of
> one costing system over another.  If I implement webERP, I need FIFO
> valuation so I will add it.  

Or average cost?
The valuation reporting is one aspect and perhaps the easier aspect to 
consider the real interest is in creating a completely consistent general 
ledger posting schema that works using the costing method chosen - we are 
talking about every stock journal in the system - they are all over the place 
and amongst the more complex aspects of the logic. Its not going to be that 
easy to do.

> I just want to decide the best way to do it 
> with the idea to give it back to the project if it is deemed worthwhile.
>
> -andy
>

Certainly would be useful to many I suspect.
All contributions most gratefully received ;-)

Phil