Detailed Diagnostics for Case 'razao' in KM_Docs/ctb

Resolved dbPath: F:\Inetpub\vhosts\nervous-meitner.23-111-178-130.plesk.page\httpdocs\App_Data\KMCTB.mdb

Testing with accID: 1, dateStart: 2026-08-01, dateEnd: 2026-08-31

1. Testing query on tblPlanoContas...

Account with ID 1 not found.

2. Testing previous balance SUM query...

SELECT SUM(IIF(Tipo='D', Valor, 0)) as TotD, SUM(IIF(Tipo='C', Valor, 0)) as TotC FROM tblLancamentosItens i INNER JOIN tblLancamentos l ON i.ID_Lancamento = l.ID WHERE i.ID_Conta = 1 AND l.DataLancamento < #2026-08-01#

Success! TotD: 0, TotC: 0, Saldo Anterior: 0

3. Testing period movements query...

SELECT i.ID as ItemID, l.DataLancamento, l.ID as Ref, i.Tipo, i.Valor, i.Historico, i.tblDoc, (SELECT TOP 1 p2.CodigoFacil  FROM tblLancamentosItens i2 INNER JOIN tblPlanoContas p2 ON i2.ID_Conta = p2.ID  WHERE i2.ID_Lancamento = i.ID_Lancamento AND i2.Tipo <> i.Tipo) as Contrapartida FROM tblLancamentosItens i INNER JOIN tblLancamentos l ON i.ID_Lancamento = l.ID WHERE i.ID_Conta = 1 AND l.DataLancamento BETWEEN #2026-08-01# AND #2026-08-31# ORDER BY l.DataLancamento, l.ID

Success! Found 0 movements in the period.