Query balance para llevar a power bi

SAP Business One
1

buen dia

agradzeco si me pueden ayudar con un query para balance que se pueda tomar fecha inicial uy fecha final tal como sale en SAP para llevarlo a power bi o donde puedo consultar lso querys del estandar de sap trae para el balance

gracias

2

Buen día yo tengo este, claro que tendrías que adaptarlo a tus necesidades pero lo puedes usar como base.

SELECT
T0.“TransId” as TransId,
T0.“Account” AS CUENTA,
T0.“RefDate” AS FECHA,
T2.“CardCode” as CARDCODE,
T2.“CardName” as CARDNAME,
T3.“GroupCode” as CODEGROUP,
T3.“GroupName” as NAMEGRUPO,
T0.“BaseRef” as NUMDOC,
T0.“TransType” as ORIGEN,
T0.“LineMemo” AS COMENTS,
T0.“DebCred” as DEBCRED,
CASE
WHEN LEFT(T0.“Account”,1) = ‘1’ THEN ‘Activo’
WHEN LEFT(T0.“Account”, 1) = ‘2’ THEN ‘Pasivo’
WHEN LEFT(T0.“Account”,1) = ‘3’ THEN ‘Capital contable’
END AS TipoCuenta,
T1.“AcctName” AS NombreCuenta,
(-SUM(T0.“Credit”) + SUM(T0.“Debit”)) AS saldo

FROM "SBOVIDRIO".JDT1 T0 
INNER JOIN "SBOVIDRIO".OACT T1 ON T0."Account" = T1."AcctCode" 
LEFT JOIN "SBOVIDRIO".OCRD T2 ON T0."ShortName" = T2."CardCode" 
LEFT JOIN "SBOVIDRIO".OCRG T3 ON T3."GroupCode" = T2."GroupCode" 
 
 where T0."RefDate" between '2025-01-01' and '2025-12-31'
GROUP BY 
T0."Account",
 T0."TransId",
 T1."AcctName",
 T0."RefDate" ,
 T0."DebCred",
 T2."CardCode",
 T2."CardName",
 T3."GroupCode",
 T3."GroupName",
 T0."BaseRef",
 T0."TransType",
 T0."LineMemo"