Unable to delete a General Journal Entry using this codes

(0) Share

Report

Posted on by Community Member

ttsbegin;

while select forUpdate ledgerjournaltrans
where ledgerjournaltrans.journalNum == 'JBN-000846'
{
ledgerjournaltrans.delete();
}

ttscommit;

ttsbegin;
while select forUpdate ledgerjournaltable
where ledgerjournaltable.journalNum == 'JBN-000846'
{
ledgerjournaltable.delete();
}
ttscommit;

Is there any alternative way to delete the specific journal number aside from the code above.

I'm planning to delete general journal entry that are not posted

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Brandon Wiese 17,788 on at

Like (0)

Report

RE: Unable to delete a General Journal Entry using this codes

Why doesn't it work?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Unable to delete a General Journal Entry using this codes

the data goes back

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

RE: Unable to delete a General Journal Entry using this codes

Then that probably means that you're part of a larger transaction that is failing and being rolled back.

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

RE: Unable to delete a General Journal Entry using this codes

general journal entry are posted journals. the tables you want to delete have nothing to do with it. there is a field on ledgerjournalTable called posted. just at that to the code and you have the non posted journals

Was this reply helpful? Yes No