You’re offline. This is a read only version of the page.
10
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?
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.
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.
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
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (