none
How can I write procedure for FIFO Process RRS feed

  • General discussion

  • Here I added two tables structure like Item Receive and Item Issue. I want to run FIFO process then How? Can anyone help me. If I create stored procedure then how to proceed.

    Item Receive Table

    itemrecvcno
    itemrecdate
    itemid
    itemname
    itemrecqty
    itemrecunit
    itemrecrate
    itemrecamount

    Item Issue Table

    itemid
    itemname

    itemissuebatchno
    itemissuedate
    itemissueqty
    itemissueunit
    itemissuerate
    itemissueamount

    Monday, November 12, 2012 5:24 AM

All replies

  • Hi Prasanta,

    Welcome to the MSDN forum.

    Do you mean you want to use these two tables to achieve FIFO process? By using stored procedure?

    Best Regards,


    Alexander Sun [MSFT]
    MSDN Community Support | Feedback to us

    Tuesday, November 13, 2012 7:25 AM
  • Thanks for interest. I am not able to manage can you? Please If you can.
    Tuesday, November 13, 2012 11:29 AM