on 12-07-2007 8:50 AM
Hi All,
I am using serial numbers to finished goods items.
I sell one item as 1001 to a customer.
So all the documents related to sales (Sales order, Delivery, A/R Invoice) do not show the serial number of the particular product sold.
From the form settings if I select the Serial No. field, it adds the field in the rows but does not show the serial number of the item selected.
My client needs to view the serial numbers of the items sold.
Can anybody suggest.
Hello Ajit,
There are a few things to be considered when looking at the option of using a UDF at the row level.
Let us say, you have item A which has quantity 5. This mean you will have 5 serial number. Since this is a very good possibility in business you need to take this into consideration.
FMS(formatted search) will not be a good option or will be too difficult to implement. Couple of reason, you have to add the document first and then trigger the FMS manually by calling the document back.
You will have to Query the serial number tables OSRI and SRI1 (NOT OIBT and IBT1).
Therefore, if you are still holding on your thought to get the Serial numbers on the Screen. Then use the UDF option but create a row level UDF large enough to hold the maximum number of serial numbers you think can be delivered per item.
Then you need to write code in the SBO transaction notification stored procedure to create a looping construct to fetch all the serial numbers for a line item and ConCat it to one variable and Update the UDF with this Variable's value.
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ajit,
If you have an Item set to Manage Serial numbers and if your business process is
Sales Order > Delivery > Invoice..
During Delivery..SAP will Open a window asking to select the Serial Numbers for the Serialized Item in the Delivery. Once you have selected the Serial number and added the document. When you print the Delivery document SAP will print another sheet showing the Serial numbers.
SAP does not print the Serial number on all the 3 documents.
Go to on Administration > System Initialization > Print Preferences... Per document Tab... for Delivery.. make sure you have selected Document and Batch/Serial number option in the When Batch/Serial No. Exist, Print.
Only if this option is selected Serial number sheet will print along with Packing slip.
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suda,
Your answer stands very much right from printing point of view.
But my question here is bit different.
I would like to view the serial numbers selected in the document itself rathr than printing.
The Delivery document is the where I select the serial numbers, so I would like to view the serial numbers there in the line itself.
Please suggest.
Hello,
I suggest you to use a UDF in the row line but the difficulty is to fill it with serial number. maybe you can develop query FMS to make sure it filled automatically.
Another means to make you able to write serial number is remarks field. But it is not on the row line and also need query FMS to do that.
The tables for serial and batch management is OIBT and IBT1.
Rgds,
Hi,
In addition to my previous reply, the table for serial no. is OSRI and SRI1. I forget to write it. Someone can't differentiate these words :" serial and batch management is OIBT and IBT1" with "serial and batch management are OSRI and SRI1 and OIBT and IBT1".
talking about FMS, I think you could try first rather than listening to someone. Maybe it seems illogical but from practice, there will be come a good idea.
Rgds,
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
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.