Hello,
Recently one of the users detected a difference in the accounting balance, the reason was that some stock exits did not generate enteries on the journal ( the OJDT table).
I tried a querry to detect the anomalies
SELECT T1.DOcNum FROM OIGE T1 WHERE T1.DocNum NOT IN (SELECT T0.BaseRef From OJDT T0)
The query works fine, as I tested it with records I created, but it detects only the test records, and thus can't pin point the other records which carry the anomaly.
I would like to know if this is a known mulfunction of SBO, and if it is the case, what could I do to solve it ?
Thanks in advance
Amin