Announcements
5,201
Hi
After I run the check links some wrong account with data is showing with “Check links acct description” account description in my TB values. Kindly advice me how can I remove these accounts with data.its making my all TB and P&L wrong
Thanks,
*This post is locked for comments
please support
even from sql script or direct application doesnt matter please advice the way to do it.
@Tristan Thor Clores : yes i am familiar to use SQL script. kindly provide me. i need to remove it from my db
Hi Rafeesh,
If you are not familiar with runnish SQL scripts, I would not recommend directly removing it using SQL.
It would still be best to just remove the historical transaction(s) using the GP interface and then deleting the account properly.
If it's been posted and in an open year then it will be in the GL20000. Since it's most likely part of a balanced transaction, the whole JE would need to be deleted. Did the transaction originate in the General Ledger or did it originate in a sub ledger?
If you truly think it just needs to be deleted and you know the JE number you should just be able to run DELETE GL20000 where JRENTRY = 'JE#'. However, if it's part of a large transaction I would make sure it doesn't need to be changed to a different account. If you do run the statement to delete it, you'll want to run your financial reconcile for the year it resided in.
i mean i need the querry to remove it . i try to remove it but it is posted transaction but that account not created and use by finance. how come?
Hi thanks for your tips. but i just need to know how can i remove it from my db for accurate TB
I'd check GL00100 to see what the ACTINDX is for that account that Checklinks created. Then see if that ACTINDX exists in any transactions in GL20000 (open years), GL30000 (closed years) or even GL10001 (work).
From what it sounds like a transaction was created for an ACTINDX that doesn't exist as an actual account and Checklinks is trying to fix that by automatically creating the account for you.
Hi Refeesh,
There are quite a number of reasons why running Checklinks against the Financial module will create these entries. One of them would be there was data against an account that was not thoroughly removed (ie: was removed using SQL and not the right way of using the GP interface).
The best solution, as with other master records in GP, is to check the account, verify if the transaction against it is invalid, delete if there are unposted transactions, and remove history if there are historical data. Once you are done with that - you should be able to delete the problematic account number.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
