cancel
Showing results for 
Search instead for 
Did you mean: 

Serial Number Tracking Report

former_member320372
Participant
0 Kudos

Hi,

How to take serial number wise GRPO & Delivery details for trading Item. The below Script has working fine but it's taking too much of time to Run. How to simplify this Query?

select T0.ItemCode,T0.itemName,T0.DistNumber,

(select T1.BaseNum from SRI1 T1 inner join OSRN a on a.ItemCode=T1.ItemCode and a.SysNumber=T1.SysSerial Where T1.BaseType='20' and T0.DistNumber=a.DistNumber )'GRPONo',

(select T1.CardName from SRI1 T1 inner join OSRN a on a.ItemCode=T1.ItemCode and a.SysNumber=T1.SysSerial Where T1.BaseType='20' and T0.DistNumber=a.DistNumber )'SupplierName',

(select T1.BaseNum from SRI1 T1 inner join OSRN a on a.ItemCode=T1.ItemCode and a.SysNumber=T1.SysSerial Where T1.BaseType='15' and T0.DistNumber=a.DistNumber )'DelNo',

(select T1.CardName from SRI1 T1 inner join OSRN a on a.ItemCode=T1.ItemCode and a.SysNumber=T1.SysSerial Where T1.BaseType='15' and T0.DistNumber=a.DistNumber )'CustomerName'

from OSRN T0

Where T0.ItemCode='Item0001'

This report has to show all purchase serial numbers even if it's not sold.

Cheers!

Prabakaran R

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member225732
Contributor
0 Kudos

Whenever you user Serial / Batch table in the report query you required more time to execute it and you can not minimize it.