Query for Serial Number

[Former Member]

Experts,

How can we know the serial numbers of respective items through query, i.e, when a serail no is added to an item, which table it gets stored etc...and how to get a list of all items with thier respective serial no

[Former Member]

Hi,

There are more than one tables for serial number. Main table is OSRI which saved Serial Numbers for Items. SRI1 is related to Serial Numbers transaction for item.

Thanks,

Gordon

[Former Member]

HI

Please try this query:

Select * from OSRN TO

[Former Member]

Hi Rupa,

Try it

SELECT T0.[ItemCode], T0.[ItemName], T1.[WhsCode], T1.[WhsName], T0.[SuppSerial], T0.[IntrSerial], T0.[BatchId] FROM OSRI T0  INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode WHERE T0.[InDate] >=[%0] and  T0.[InDate] <=[%1] and  
T0.[Status] <> 1
Group by
T0.[ItemCode], T0.[ItemName], T1.[WhsCode], T1.[WhsName], T0.[SuppSerial], T0.[IntrSerial], T0.[BatchId]

Thanks,

Srujal Patel

Edited by: Srujal Patel 77 on Jun 13, 2011 6:48 AM

[Former Member]

Hi Rupa,

After the serial number is added to an item its gets stored in table OSRI. see also OSRL for all serial numbers. for example select * from OSRI to know what serial number given for which item.

hope this will be helpful.

regards,

Vignesh