Post reply

FIFO and LIFO

  • September 14, 2010 at 10:12 pm

    #157202

    HI Friends ,

    I am new in SQL.I need a Query about FIFO and LIFO Method.My Table Structure is Hearder and Details.it's link to No .I have a one stock table.I need a report for FIFO rate based on Current STOCK With Division Wise.Pls help me.

    This is the Flow PO > GIN > GRN(Supplier/joborder) > Inspection > MI > DC > Closing Stock

    how can i get Rate in FIFO and LIFO Method .. Pls give me Some idea and Examples

    Thanks for U Help

  • September 14, 2010 at 10:23 pm

    #1221112

    naraayanan_1983 (9/14/2010)

    HI Friends ,

    I am new in SQL.I need a Query about FIFO and LIFO Method.My Table Structure is Hearder and Details.it's link to No .I have a one stock table.I need a report for FIFO rate based on Current STOCK With Division Wise.Pls help me.

    This is the Flow PO > GIN > GRN(Supplier/joborder) > Inspection > MI > DC > Closing Stock

    how can i get Rate in FIFO and LIFO Method .. Pls give me Some idea and Examples

    Thanks for U Help

    Hi Buddy,how about you going through this following article and helping us help you?? 🙂

    FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

    When u do so, i am sure a lot of us will help u instantly...

    So please post

    1. Table Structures - CREATE TABLE scripts

    2. Constraints or Indexes in the table, - CREATE SCRIPTS

    3. SAMPLE DATA - INSERT INTO TABLE scripts

    4. Desired output - some visual representation of this.

  • September 15, 2010 at 1:07 am

    #1221141

    Thanks for u Reply I will Send the table structre

    Regards

    Lakhsmi Narayanan.S

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply