Crear formato de Cheque en SAP B1 HANA

[nidia]

Hola Buen dia, me encuentro en un dilema estoy diseñando impresión de Cheque ya tengo todos los datos pero tengo que agregar la partida del pago cuenta cargada y acreditada en el voucher del cheque no encuentro la forma de hacerlo … agradezco de ante mano su ayuda.

SELECT T0."DocEntry",T0."DocNum", T0."DocType", T1."TransType", T1."BaseRef", T1."RefDate", T2."Account", T3."FormatCode", T3."AcctName",
T2."Debit", T2."Credit",  T4."VendorName", T4."TotalWords", T4."CheckSum",T4."PmntDate",
T4."CheckKey", T4."CheckNum", --T5."LineDitail",
 
(SELECT L0."LineDitail"  FROM "PRUEBAS_INTEGRALES"."CHO1" L0 WHERE L0."LineId" = '0' and L0."CheckKey"='{?DocKey@}') as "Line0",
(SELECT L1."LineDitail" FROM "PRUEBAS_INTEGRALES"."CHO1" L1 WHERE L1."LineId" = '1' and L1."CheckKey"='{?DocKey@}') as "Line1", 
(SELECT L2."LineDitail" FROM "PRUEBAS_INTEGRALES"."CHO1" L2 WHERE L2."LineId" = '2' and L2."CheckKey"='{?DocKey@}') as "line2",
(SELECT L3."LineDitail" FROM "PRUEBAS_INTEGRALES"."CHO1" L3 WHERE L3."LineId" = '3' and L3."CheckKey"='{?DocKey@}') as "line3"
 
FROM "PRUEBAS_INTEGRALES"."OVPM" T0  
INNER JOIN "PRUEBAS_INTEGRALES"."OJDT" T1 ON T0."TransId" = T1."TransId" 
INNER JOIN "PRUEBAS_INTEGRALES"."JDT1" T2 ON T1."TransId" = T2."TransId"
INNER JOIN "PRUEBAS_INTEGRALES"."OACT" T3 ON T2."Account"=T3."AcctCode"
LEFT JOIN "PRUEBAS_INTEGRALES"."OCHO" T4 ON  T0."DocNum"=T4."TransRef"
WHERE T4."CheckKey" = '{?DocKey@}'

[juanfranc520]

Hola @nidia, asumo que cuando hablas de la cuenta cargada y acredita es el detalle de la transacción (Asiento), si es así podrías mirar este Query que tengo para imprimir los cheques.

SELECT DISTINCT T7."CheckKey",
 T2."DocDate", T2."DocTotal", T2."DocNum", T2."CardName", T2."JrnlMemo", T2."TransId", T2."DocEntry", T2."Comments", T1."Account", T1."DebCred", T0."TransId", T1."Debit", T1."Credit", T4."AcctName", T5."LicTradNum", 
    T7."BankNum", T7."CheckNum", T8."BankName", T9.U_NAME AS "USUARIO", T2."PayNoDoc", t7."VendorName" 
FROM OJDT T0 
    INNER JOIN JDT1 T1 ON T0."TransId" = T1."TransId" 
    LEFT OUTER JOIN OVPM T2 ON T2."TransId" = T1."TransId" 
    LEFT OUTER JOIN VPM1 T3 ON T3."DocNum" = T2."DocEntry" 
    LEFT OUTER JOIN OACT T4 ON T4."AcctCode" = T1."Account" 
    LEFT OUTER JOIN OCRD T5 ON T2."CardCode" = T5."CardCode" 
    LEFT OUTER JOIN ORCT T6 ON T6."TransId" = T0."TransId" 
    LEFT OUTER JOIN OCHO T7 ON T7."PmntNum" = T2."DocEntry" 
    LEFT OUTER JOIN ODSC T8 ON T7."BankNum" = T8."BankCode" 
    LEFT OUTER JOIN OUSR T9 ON T9.USERID = T0."UserSign"
WHERE T7."CheckKey" = {?Dockey@}