Serial Number of Item in Delivery or A/R Invoice

[Former Member]

Hi all experts,

i have one item "I0001".this item is managed by serial number.when i create delivery,i choose this item and system will alert me to choose the serial number of this item.

My question is What is the table that store the serial number for this delivery no?

Thanks

TONY

[Former Member]

    Soeun did you find the table you were looking for, I read the SAP note listed in this discussion and  and at least in my data base 8.81 there are no OSRI nor  SRI1 tables!!!

    Thank you.

[Former Member]

Hi Tony......

Try this..........

SELECT T0.CardCode, T0.Docnum,T0.DocDate, T0.CardName,T1.Quantity,T1.ItemCode,T4.DistNumber

from ODLN T0 inner join DLN1 T1 on T0.DocEntry=T1.DocEntry

left outer join SRI1 I1 on T1.ItemCode=I1.ItemCode   and (T1.DocEntry=I1.BaseEntry and T1.ObjType=I1.BaseType)

left outer join OSRN T4 on T4.ItemCode=I1.ItemCode and I1.SysSerial=T4.SysNumber

Regards,

Rahul

[chladek]

did You try it? Such select doesn´t work.

[Rafaee_Mustafa]

HI Soeun,

Here you can find the serial nos of your deliverd item

SELECT  T0.BaseNum, T0.CreateDate, T0.WhsCode,

         T0.CardCode, T0.ItemCode, T2.IntrSerial

FROM     dbo.SRI1 T0

         INNER JOIN dbo.OSRI T2 ON T0.SysSerial=T2.SysSerial

WHERE    T0.BaseType = '15'

AND      T0.ItemCode = 'I0001'

Thanks.

Regards,

[former_member186095]

Hi Soeun,

You can use OSRI table to check it.

In the table, all serial numbers from all documents are stored there.

You can also use serial number transaction tables.

Rgds,

JM

[Former Member]

Hi Jimmy,

I think that this table is not correct because i added 2 delivery No(34,35) and when i select* from OSRI, it doesn't display the delivery No or Delivery ObjType.

Thanks

TONY

[former_member186095]

Hi,

You can also use OSRD or SRI1. More detail about the SAP B1 database table references, you can use SDK help file

Rgds,

JM

[former_member186095]

Hi,

You can also apply the solution part of this following sap note:

990153  - Where is the Serial no. assigned in a base document found?

Version   5   Validity: 05.08.2009 - active Language   English

Content:      Summary    |    Header Data    |    Validity 

Symptom

           An A/R Invoice has been created based on a delivery and serial Numbers have been assigned in the delivery.

           Where can these serial numbers be found so that they can be displayed in the invoice itself?

 

Cause

Specific Solution

 

Solution

1. In the SAP Business One Menu Go To View and choose 'System Information'

2. When selecting the serial numbers in the base document, the Delivery in our example, in the select serial number window note that the OSRI table is used. (To find the table name roll the mouse over the fields in the lower half of the screen and look at the system information displayed at the bottom of the screen)

3. The other 2 tables which need to be used are the OSRD and SRI1 tables.

4. Write a select query selecting the required information from these tables(OSRI, SRI1, OSRD).

5. Create a User Defined Field(UDF) on row level of marketing  documents. To create a UDF go to Tools - User Defined Fields - Manage  User Defined Fields - Marketing Documents - Rows. Click on 'Add' and create a UDF of Type 'AlphaNumeric' and Structure 'Regular'.

6. Save the query behind the newly created UDF in the target document,  the A/R Invoice in our csae. Do this by opening the A/R Invoice(Sales -  AR -> A/R-Invoice). Choose a Business Partner in the "Customer" field.  On row level choose an item code in the "Item No." field. Click into the  UDF on row level. Go to  Tools -> Search Function -> Define -> Search by  Saved Query, double click on the grey line to open the query manager and choose the required query.

7. To run the formatted search in the target document eg. the A/R  Invoice go to Tools -> Search funtion -> search and the correct serial number will be displayed.

 

Other terms

Serial Numbers, Serial Number Management, Display serial numbers in a target document, Invoice

   
       

Header Data

Released On	05.08.2009 12:51:09
Release Status	Released for Customer
Component	SBO-MM-MGM-SER Serial Numbers
Other Components	SBO-SD-INV A/R Invoice SBO-SH-MM-MGM-A1 Serials/Batches Management
Priority	Recommendations/additional info
Category	Consulting

  
      

Validity

Software Component	Version
SAP BUSINESS ONE	2005 A
	2005 A SP01
	2005 B
	2007 A
	2007 B
	8.8

    

Good luck

Rgds,

Jimmy