Skip to Content

Serial Number Tracking Report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 19 at 10:49 AM

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

    Add comment
    10|10000 characters needed characters exceeded