Re: [WebERP-developers] inventory costing

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

> Hi Andy,
> 
> Well, currently the actual cost of a delivery is recorded in the stock 
> movement - at the time the item is received the standard cost goes on the 
> stockmoves record, but when the invoice is entered the line is updated with 
> the actual cost - or at least the supplier invoice cost as converted at the 
> invoice exchange rate. If the invoice is paid at a different rate this 
> difference is not picked up on in the stockmoves record. Also, freight costs 
> associated with getting the item to its "present location and condition" is 
> completely ignored - as it is in most systems. I am not sure if I remember if 
> the stockmoves record is updated when a shipment is closed - I guess this 
> could easily be accomodated.
> 

I've been doing some stock transfers looking at this table and it 
appears some things are missing.  The price (cost) column is not updated 
when a transfer is done, nor is the standardcost column.  I'm not sure 
how invoicing would refer to this table?  Have to dig thru some of it 
and try to sort it out.

Also, there has to be some way of tracking when a record in this table 
is sold (or transferred) in it's entirety, which I assume is what you 
were referring to.

Do you have a list of all scripts and their functions?  As I'm digging 
into this I'm just going to the modules and seeing what scripts are 
referenced, but that would be helpful.  If not I'll start putting a 
document together as I go thru everything.

> The valuation then can be determined on a first in first out basis by looking 
> at the last receipts of stock and the value attached to the stockmove record 
> for the receipt of the stock up to a maximum of the quantity left in stock 
> now. So it is possible with the data we have now to create a report for the 
> FIFO valuation of stock - assuming invoices are all entered against all goods 
> received.
> 
> Its quite miserable to contemplate how this could be made to tie up with the 
> value of stock in the general ledger - the whole system is geared around 
> standard costing.
> 

I guess the first thing to do will be to go thru anything that uses 
inventory in any manner and figure out where how it calculates the cost 
currently.  Perhaps together we can come up with a list.

> 
> Your point about prefixes is a good one. I have done this although perhaps not 
> rigorously, but most scripts to do with stock begin with the word Stock - 
> purchase orders - PO. I like to think the naming of scripts does tend to give 
> away the function of the script.
> 
> I am not sure what other scripts we might put in the receiving directory? If 
> we end up with as many directories as scripts we are not much better off - in 
> fact we are worse off cos we continually have to change directories every 
> script we work on. 
> 

I don't think separate directories would serve any benefit if the 
scripts had a set prefix.  I do agree with Steve that isolation of third 
party apps is a good idea though.

-andy