Skip to Content
0
Jun 07 at 07:30 AM

ISSUE FOR PRODUCTION - DRAFT LAYOUT

116 Views Last edit Jul 27 at 05:27 AM 4 rev

Hi. I have a problem when displaying my issue for production draft layout. No problem when I preview the posted issue for production but when I want to display my draft, it only display blank. Can some one help me? below is the command that I did :

select
T0.DocNum,t0.DocTime,t0.DocDate,t0.Printed,t0.comments,
t0.DocEntry,
t1.BaseRef as JobNo,
T1.ItemCode,
t1.Dscription as Description,
t1.unitMsr as UoM,
T1.Quantity,
T4.DistNumber as BatchNo,
T3.AllocQty as BatchQty,
T4.sysnumber,
isnull(T7.[U_NAME],'') as 'NAME'
from
OIGE T0
inner join IGE1 T1 on T0.DocEntry = T1.DocEntry
inner join OITM T2 on T1.ItemCode = T2.ItemCode
left JOIN OUSR T7 ON T0.[UserSign] = T7.[USERID] 
full outer join (select S0.DocEntry, S0.DocLine, S1.SysNumber, -sum(S1.Quantity) as AllocQty from OITL S0 inner join ITL1 S1 on S0.LogEntry = S1.LogEntry where S0.DocType = 60 group by S0.DocEntry, S0.DocLine, S1.SysNumber) T3 on T1.DocEntry = T3.DocEntry and T1.LineNum = T3.DocLine
full outer join OBTN T4 on T3.SysNumber = T4.SysNumber and T1.ItemCode = T4.ItemCode
inner join OWOR T5 on T1.BaseEntry = T5.DocEntry
where T0.DocEntry={?DocKey@}