on 01-10-2019 12:51 PM
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
Whenever you user Serial / Batch table in the report query you required more time to execute it and you can not minimize it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
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.