Finance | Project Operations, Human Resources, ...

Account ###-#####-## is part of an unposted transaction. It cannot be deleted

(0) Share

Report

Posted on by LGinNV

I created a new GP db, used PSTL to copy Financial setup info. Then used Mass Modify to "move" all g/l Chart of Accounts to segment 1. There were two accounts that did not move and I received the following message "Account ###-#####-## is part of an unposted transaction. It cannot be deleted". This is a new company and there are not transactions? I had to change the default account in the "G/L setup" used for Retained Earnings. However I have 2 other G/L posting accounts that will not let me move them and can't find what is holding them up? Has anyone encountered this when using PSTL to copy Financial Series from an existing GP db?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Lisa at AonC.com 963 Super User 2025 Season 2 on at

Like (1)

Report

See if there are any Quick Journals setup. You should be able to delete them in the new company and then move the accounts to their new number.

Was this reply helpful? Yes No
Jeff Grant on at

Like (0)

Report

Hello LGinNV,

There are no known issues with the PSTL tool company copy causing this error but I agree with the quick journal recommendation.

In addition, please use SQL to verify that the contents of the GL10000/GL10001 tables are cleared in the new installation:

select* from GL10000
select* from GL10001

Best Regards,
Jeff Grant
Microsoft Dynamics GP Support

Was this reply helpful? Yes No
LGinNV 10 on at

Like (0)

Report

Thank you, I did verify that both GL10000 & GL10001 tables were empty.

Was this reply helpful? Yes No
Chloe4418 5 on at

Like (0)

Report
Go to Smart List > Financial > Account Transactions.

Add the column "Document Status"

On the search, filter by the (Work) status which is unposted, and the account number mentioned above. quickpayportal.com

This should return the Journal Entry for this specific account. As long as you have unposted transactions, you are supposed to delete this transactions in order to be able to delete the account. Dynamics GP will not allow this GL account to be deleted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Did you get a resolution to this? I am trying to clean up old accounts that have never been used, but I am getting this error on some of them. I ran the script to show when the account was last used and it has no history and isn't on any unposted transaction but still gives me this error when trying to delete the account. Susan

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 963 Super User 2025 Season 2 on at

Like (0)

Report

Did you also confirm there are no Quick Journals out there that use the account? Check both Microsoft Dynamics GP > Tools > Setup > Quick Journal and Transactions > Financial > Quick Journal.

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 963 Super User 2025 Season 2 on at

Like (0)

Report

Additional item to check (via SQL): Is the account included in the XLImport table? If so, you'll need to delete those rows before GP will allow you to delete the unused GL account.

Was this reply helpful? Yes No