on 07-09-2020 4:29 PM
Hi Everyone,
I am just writing a few queries and wanted to ask if someone could help with this one. I just want first to check an Serial Numbers status. Version 9.3 PL5.
In the OSRN table definition, it lists the column status as having a value of 0,1,2 to represent the status (Available, Unavailable and allocated). When i query this table all this column has is null. (Its a 5 year old database working with serial numbers all the time).
select * from OSRN where Status is not null
>> This Returns 0 Rows.
So is this column no longer used? does anyone know why the status column in OSRN is NULL?
So then I move onto OSRI, this has a status column, but it is only 0 or 1 (Available / Unavailable). This works OK, but Allocated would be a great addition.
So the question is, is there an easy way to get the serial number status of allocated? Or do i need to trawl through the SRI1 table to find its allocation?
Hi,
Check this link,
https://www.sap-business-one-tips.com/find-your-allocated-batch/
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.