Where to find Journal Entry Balances

Hello Sage Community,

I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API.

While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly, and the data is stored accurately in the database. However, when attempting to post transactions using the API, I encounter issues. For instance, the functional credit and debit columns, along with the source debit and credit column entries, appear to be incorrect.

I have been posting these entries to the GLJED, GLBCTL and GLJEH tables, but the problem persists as mentioned above.

I would greatly appreciate any insights or guidance on where I might be going wrong with the API integration.

Thank you in advance for your assistance.