calculating credit days using FIFO method ?

[#1]

Hi Guy

I need your help with calculating credit days using FIFO method

Thanks in advanced

Aviad

Product Action Type Date Qty

D1, Purchase, 8/12/2009, -15
D1, Payment, 8/20/2009, 3
D1 ,Payment, 9/10/2009, 10
D1, Purchase, 9/25/2009, -7
D1, Payment, 9/26/2009, 1
D1, Purchase, 9/29/2009, -2

[pover]

Aviad, Try something like the attached application. Regards.