FIFO

• Motz

  Old Hand

  Points: 310

  More actions

  August 28, 2009 at 5:56 am

  #135083

  HI,

  I want to implement FIFO logic in Inventory Ageing report

  For example

  As of Date i hve remaining Qty for Code 1112 , Qty =50

  for Code 1122, Qty =100

  and say i purchased qty as

  Period: 0-15 Days, Code: 1112, Qty = 70

  Period: 0-15 Days, Code: 1122, Qty = 25

  Period: 16-30 Days, Code: 1122, Qty = 30

  Period: 31-60 Days, Code: 1122, Qty = 60

  Then the output should be

  Period: 0-15 Days, Code: 1112, Qty = 50 (as 70>50 and i have only 50)

  Period: 16-30 Days, Code: 1112, Qty = 0

  Period: 0-15 Days, Code: 1122, Qty = 25 (as 100>25 and i have 100 avl)

  Period: 16-31 Days, Code: 1122,Qty = 30(as 100>55 (25+30) )

  Period: 31-60 Days, Code: 1122, Qty = 45 (in this age group i purchased 60 but i hve remaining Qty only 45 )

  If any one has implemented the same logic or know how this can be achieved then plz let me know

  Thanks in Advance

  Motz

• drew.allen

  SSC Guru

  Points: 76988

  More actions

  August 28, 2009 at 4:40 pm

  #1046428

  This was recently discussed in the following thread

  http://www.sqlservercentral.com/Forums/Topic771804-338-1.aspx

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA