Hola a todos, alguien sabe cual es mi problema, estoy trabajando en un formato de factura en crystal report, cuando quiero ver la factura preliminar en SAP B1 antes de crearla me aparece la pantalla en blanco y como borrador no me aparece los datos le factura.
SELECT T0.[CardCode], T0.[DocEntry], T0.[DocNum], T0.[DocTime],
T0.[PayToCode], T0.[Address],
T0.[Printed],
T0.[U_MOTORISTA],
T0.[ShipToCode],
T0.[Address2],
T0.[NumAtCard],
T0.[DocDate], T0.[DocRate],
T0.[DocDueDate],
T0.[Comments], T0.[OBJTYPE],
T1.[U_FSC],
T1.[ItemCode], T1.[U_OrdenCompra], T1.[Dscription], T1.[Quantity], T1.[Length1], T1.[PriceAfVAT], T1.[Weight1], T1.[PackQty],
T1.[Width1], T1.[Height1],
T2.[SlpName],
T3.[FrgnName], T4.[U_NAME],
T5.[Notes],T5.[VatIdUnCmp], T6.[Remark], T6.[EndStr], T6.[InitialNum], T6.[LastNum], F0.[NAME],
C1.[Name] AS ‘ConductorName’
FROM OINV T0
INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry]
INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode]
INNER JOIN OITM T3 ON T1.[ItemCode] = T3.[ItemCode]
INNER JOIN OUSR T4 ON T0.[UserSign] = T4.[USERID]
INNER JOIN OCRD T5 ON T0.[CardCode] = T5.[CardCode]
INNER JOIN NNM1 T6 ON T0.[Series] = T6.[Series]
LEFT JOIN [@conductor] C1 ON T0.[U_MOTORISTA] = C1.[Code]
LEFT JOIN [@FSC_DATOS] F0 ON T1.[U_FSC] = F0.[CODE]
WHERE T0.[DocEntry] = {?DocKey@} AND T0.[OBJTYPE] = {?ObjectId@}
