980
When attempting to delete a GL account, we get the message "xxx is part of an unposted transaction. It cannot be deleted."
There are no unposted transactions for this company, and the account is not used as a default on a vendor, customer or system posting setup.
Is there a way to determine where this account is being used, so it can be deleted?
*This post is locked for comments
Follow up - if I remove the Account from the XLImport - is that only effect the content of the Budgets?
This table - and the GL00100 and Gl00105 are the only other places I find the reference to the Account Index. So removing from that table only effects that budgets.
We have the same issue - have tried the same resolution and none of the suggestions have worked.
Questions - My reservation about deleting the account is 'what happens to the posted transactions that reference this account'
Do we need to remove them first? If so, where does it stop.
We figured that a recently added budget was causing the issue here as well. After trying to delete and recreate the budget, the account still would not delete.
We found that the issue was in the XLImport table. After deleting the contents of that table for the account in question, we went back into and deleted the account without issue. This was on GP2015R2.
Here's the script that we ended up having to run
Select * from XLImport where actindx = {}
Delete from XLImport where actindx = {}
This could be due to a Budget ID that has been deleted. Create a new budget ID using Excel wizard with the exact same BID as was deleted. Need only use one account, with Blank budget. Save the excel file, close excel, back in GP select the BID and import from Excel the saved file. This will overwrite/update the tables and now you will be able to delete the accounts. To delete the Budget ID from GP, first delete the account budget through GP, save, and then delete the Budget ID
Do you have acccess to SSMS? If so, try these steps:
1) Select * from GL00100 and look for your GL accouint and make note of the ACTINDX value
2) Select * from GL10001 where ACTINDX = the value from Step 1 make note of the DEX_ROW_ID value(s)
3) Delete GL10001 where DEX_ROW_ID = the value(s) from Step 2
or
You may have orphaned records and running check links might clear up this issue. Make sure you have a backup before running check links or running the SQL commands.
Okay then, we are clear now.
Let me provide my suggestion on how to handle this case, you may go through the following suggestions in sequence
SELECT A.BACHNUMB,
A.JRNENTRY,
A.ACTINDX,
B.ACTNUMST,
A.DEBITAMT,
A.CRDTAMNT
FROM GL10001 AS A
LEFT OUTER JOIN GL00105 AS B
ON A.ACTINDX = B.ACTINDX
WHERE B.ACTNUMST = '000-000-000'
As always, when performing a very simple update or delete statement on the database level, a back up is always a must. If you are not a technical person, contact your partner. If you are a technical person, check the suggested criteria on a test environemnt to ensure its validity first.
Hope this helps,
Thanks for the answer, but there are no unposted transactions in GL (or in any module). The smartlist you noted returns no records.
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.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (