Serial Number In AR Invoice

[peddinti_pratap]

Dear Experts,

I Have one Issue related to serial Number in AR Invoice.i have created one crystal report for AR invoice.we require serial number in AR invoice.

Scenario:

      Item Code    Quantity    serial number

01)  FFP001        8             IC432DDRM-S13-12-62306

02   FFp002         3            IC432DDRM-S13-12-62310,IC432DDRM-S13-12-62311,IC432DDRM-S13-12-62312

How to write query for Serial number for Above scenario suggest me how to do this?

thanks&Regards,

P.Pratap

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T1.[ItemCode], T1.[WhsCode], T3.[IntrSerial] FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry left join SRI1 T2 on T2.[ItemCode] = T1.[ItemCode] INNER JOIN OSRI T3 ON T2.SysSerial = T3.SysSerial and T3.[ItemCode] = T2.[ItemCode] WHERE T2.[BaseType] = [%0] and T0.[DocDate] between [%1] and [%2] GROUP BY T0.[DocNum], T0.[DocDate], T0.[CardCode], T1.[ItemCode], T1.[WhsCode], T3.[IntrSerial]

Thanks & Regards,

Nagarajan

[peddinti_pratap]

thanks for your replay Nagarajan,

i have close this issue.

thanks&regards,

P.Pratap

[kothandaraman_nagarajan]

Hi,

Please close this thread by marking correct answer.

Thanks & Regards,

Nagarajan