We use SuiteQL to extract journal entries. For that we leverage the transaction, transactionline, and transactionaccountingline tables. We are having issues when journal entries are changed.

If after a journal entry has been approved and posted in the ledger and something has been determined wrong with the journal entry. Our Corporate Controller will go into Netsuite and edit the journal entry with the problem and change the status of the journal entry to unposted. This gives the accountant the ability to edit and correct the entry and then the Corporate Controller will approve the entry which will change the status to posted again. That is what happened in this case. The only unusual aspect of this entry was that the original journal entry was determined to