|
From: Phil D. <we...@pa...> - 2005-10-26 07:05:25
|
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 |