Re:FIFO calculation

[#1]

Hi All,

          I am struggling with fifo caculation can any one help me regarding this problem.

                load * inline [Date,Type,Quntity

                                  10-11-2012,purchase,30

                                  1-11-2012,purchase,20

                                  8-11-2012,sold,25

                                  3-11-2012,sold,10

                                  2-11-2012,purchase,15

                           ] ;

This is my inline table  i don't known weather  it is correct table or not  just i assumed if any changes are need correct me.Actuvally this is my practice example.......

Kindly need for Helpful.

Regards & Thanks,

ASHOK.

[#2]

Hi ashok

I don't understand your issue.

I suppose you want to use the Date ?

To transform your field Date in a usable field try this

load   Date#( Date , 'DD-MM-YYYY') as Date , Type , Quntity

  inline [Date,Type,Quntity

                                  10-11-2012,purchase,30

                                  1-11-2012,purchase,20

                                  8-11-2012,sold,25

                                  3-11-2012,sold,10

                                  2-11-2012,purchase,15

                           ] ;

JJ

[#3]

Hi Jean,

    My issue is, if item is sold then that value is subtract from first purchase value in that date it will show remaining

value as Quntity.if sold vaiue is greaer than first purchase value then that remaining value is subtracted from second

purchased value like that..............

Thanks,

Ashok.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. Is that what you need?

[#5]

Hi Wassenaar,

    Thanks for your reply,you gave me what i want.

Thanks alot.

Regards,

Ashok