WareHouse Parts FIFO Pick

[henry...@hotmail.com]

Good Day,

Location Table

LOCNO..ITEMNO..LOTNO...QTY

A1...........X01........24-02....10

B2...........X01........24-01..... 6

C6...........X01........24-03....20

(FIFO = The Lowest LOTNO)

If i sell  <= 6 pieces of X01 i should pick the items from B2 Location(FIFO)

Requested Query Result should be

LOCNO..ITEMNO..LOTNO...QTY

B2...........X01........24-01..... 6

If i sell  10 pieces of X01 then

      first i should pick 6 pieces from B2 Location(FIFO)

      second i should pick 4 pieces from A1 Location(FIFO)

Requested Query Result should be

LOCNO..ITEMNO..LOTNO...QTY

B2...........X01........24-01......6

A1...........X01........24-02..... 4

If i sell  20 pieces of X01 part then

      first i should pick 6 pieces from B2 Location(FIFO)

      second i should pick 10 pieces from A1 Location(FIFO)

      third i should pick 4 pieces from C6 Location(FIFO)

Requested Query Result should be

LOCNO..ITEMNO..LOTNO...QTY

B2...........X01........24-01...... 6

A1...........X01........24-02.....10

C6...........X01........24-03...... 4

Could someone please help ?

Thank You

[henry...@hotmail.com]

I'm using FB3

[liviuslivius]

Hi

But what help you need? 

Simly write stored procedure which go record by record. Select records with lock and go until provided quantity reached. Thats it.

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: "henry...@hotmail.com" <henry...@hotmail.com>

Data: 30.06.2024 05:41 (GMT+01:00)

Do: firebird-support <firebird...@googlegroups.com>

Temat: [firebird-support] WareHouse Parts FIFO Pick

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/9b64845f-c7df-40d2-aca3-5d6a71be8cb8n%40googlegroups.com.