Re: [WebERP-developers] inventory costing

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

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.

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.


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. 

Phil
On Wed, 26 Oct 2005 06:54, AndyThompson wrote:
> Thinking about delving into FIFO and average costing additions to
> webERP.  This will serve as a root message to hopefully get a discussion
> started on what needs to be done to make this happen.
>
> Any controlled item is pretty straightforward since the cost is a one to
> one association.  Should be easy enough to add a cost column to the
> stockserialitems table.  We will need a purchase receipts master table
> to store cost in batches of items received as well as track relief of
> those receipts on sales/transfers etc to calculate the cost against.
>
> Very simplistic (and very incomplete) overview, but hopefully will fuel
> some discussion.  I'm not sure of everything this will impact right now,
> especially in existing functionality.
>
> -andy
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course
> Free Certification Exam for All Training Attendees Through End of 2005
> Visit http://www.jboss.com/services/certification for more information
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

-- 
Phil Daintree
webERP Project Admin