Hi Naomi.
Can I upload a File Here ? (let me know how and I can upload a copy of the Table)

There aer lot of fields but boils down to 3
Qty (Qty eceived into Stock)
Cost (Cost of the goods going into stock
QtyRem (Qty remaining in stock for the specific delivery)

All Postive Receipts just apend to this table (Making Qty remaining equal to the Qty received)
All Negative Transactions (e.g. A Sale or a Negative adjustment) seeks the oldest Stock Code, that still has a Qty remaining, and applies that cost , and then decrements the stock.
In a FIFO, very important that the system is never allowed to go into Negative Stock
(If this happens, a positive adjustment must be entered)
In the case where a Sale 'Staddles' two costs, as far as I can rememebr I take a weighted aveage of the 'straddled' Costs
e.g. 10 remainig @ 5.00 6 remaining @ 4.00 but sale is for 12 (Cost = (10 *5) + (2 *4) / 12 = 4.67


Regards,
Gerard





>>Hi Naomi.
>>Have a routine in VFP for FIFO, but always adopted the methodology where, as soon as a transaction is posted, it calls the FIFO routine.
>>Basically, I maintain a 'FIFO' table for each Positive Transaction, which has the Movement In, as well the balance remaining on that movement, so that as soon as a sale is made, it goes back, in date order, over evry non zero Balance remaining, and starts decremetning the Balance remaining.
>>
>>This is implemented live on an inventroy stock file with about 30,000 items , and takes less than a second
>>
>>I realise this is different than what you are trying to do, but might have some pointers.
>>regards,
>>Gerard
>>
>>
>Can you post the exact structure of that table and an example of your inventory and updates in that table?
>
>Thanks again.