>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.