So, my trial balance is out of balance... Data Integration is not fixing it. Rebuilding is not fixing it...

Reason for the out of balance...

Basic Setup:
Sales Master Account 1000/000
Sales Sub Account 1000/100

The sales went to the Master account and is not appearing in the Sub Account... I can't reverse it with a journal as Pastel won't allow me to post to the main account, I HAVE to post to a sub account.

Is there anyone that can assist me? Maybe I can fix it with a data table?