Skip to Content
0
Jun 09, 2009 at 03:25 AM

How to determine the last transaction of a Batch Number

97 Views

Hello,

For example,

ITEMCODE - BATCHNUM - WHSCODE - LINENUM - DIRECTION

ITEM1 - BATCH1 - WH1 - 0 - 0

ITEM1 - BATCH1 - WH2 - 0 - 0

ITEM1 - BATCH1 - WH1 - 1 - 1

ITEM1 - BATCH1 - WH2 - 1 - 1

How will I know that record number 4 is the last transaction regardless of the transaction type and warehouse code. Is there any table which can help me solve this issue other than OIBT?

Regards,

Gilbert Ngo