Why is the Satus field has a blank in OSRI

[Former Member]

Hi Forum,

I have an issue reporting serialized items from SAP B1.

I've noticed that OSRI has a status field that is supposed to be a "0" or a "1" but I have some records with " " (blank)...

Is there a meaning for the blank Status?... I have not seen it before.

I am reporting based on the Status and I am missing the records that have a blank....

Any suggestions?

Regards,

Manuel Roman

[kothandaraman_nagarajan]

Hi,

Please advice your SAP version and PL.

Please refer SAP note 1581964 & 1569329

Thanks & Regards,

Nagarajan

[Former Member]

Hi Manuel,

It is easy to find all those records by:

SELECT * FROM OSRI

WHERE ISNULL(Status, '') = ''

Thanks,

Gordon

[former_member217514]

Are the Serialized Items that are blank, are they in the warehouse and available to to delivered?

Is OSRI blank or NULL?  The only way to find this out is to query the table in SQL Management Studio.

Then add a clause to your report that adds a blank as a 0.

WHERE ISNULL(Status, ' ') IN (' ', '0')