Skip to Content
0
Former Member
Jan 22, 2009 at 12:09 PM

Stock exits and deliveries not recorded on OJDT

28 Views

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