70
Hello, we have just noticed several of our accounts that had the "Allow Account Entry" checked, all of a sudden have been uncheck.
Is there a way to audit accounts as to who changed them?
We are thinking it is from a Smartconnect upload, so we are trying to track down user
I know we have a few balance sheets accounts that should be do not allow account entry, but the ones I am looking at are all expense accounts
*This post is locked for comments
Let me know how things go with you ...
Hello again
You can simply consider a direct update statement on the table GL00100, which is the simplest and quickest way. When you change the "Allow Account Entry" checkbox, the field ACCTENTR flips between (1 and 0). All you need to do is to initially get the account indices for these 400 accounts.
UPDATE GL00100
SET ACCTENTR = 1
WHERE ACTINDX IN
(
)
If you are familiar with SQL, you may consider the following SQL statement which shall automatically retrieve the account index
UPDATE GL00100
SET ACCTENTR = 1
WHERE ACTINDX IN
(
SELECT DISTINCT AccountIndex
FROM
(
SELECT A.ACTINDX AS AccountIndex,
RTRIM(B.ACTNUMST) AS AccountNumber,
RTRIM(A.ACTDESCR) AS AccountDescription FROM GL00100 AS A
LEFT OUTER JOIN GL00105 AS B
ON A.ACTINDX = B.ACTINDX
WHERE RTRIM(B.ACTNUMST) IN
('000-1100-00',
'000-1120-00',
'000-1220-00'
)
) AS X
)
All you need to do is to fill in your account numbers instead of the "sample accounts" included above. Be careful in order to miss the update :)
Let me know if you need any further assistance,
Sorry one more question
We were able to stop the issue, but now have 400 accounts that have "allow account entry" unchecked
Is there an easy way to change this back to allow account entry via smartconnect. I am not familiar at all with SQL, so that is out of question
Hello, thank you for taking time to respond to my question.
We have been able to track down that it is from an AP upload file. Seems to change all accounts in the file to Do Not Allow Account entry
We are having developer take a look at the file.
If you are talking about a large number of accounts that have been changed all at the same time, you may check the "MODIFDT" in GL00100, if it is the same for all these accounts then I would agree that it is some sort of change that have been applied on the database level. When the allow account entry checkbox is changed, two changes occur on the GL00100 which are (MODIFDT is changed to the current data) and (ACCTENTR is changed either to one or zero)
Activity Tracking for Dynamics GP would track such change, but it won't be efficient when activated since it will track all changes related to other master files as well (not only accounts). In this essence, you may need to consider a trigger on the GL00100 to track this change and the user applying the change. This could be stored in a separate table for audit purposes.
The above would be effective if you are looking only to track the change of account changes on the account maintenance window (such as allow account entry). Otherwise, if you are looking to track down and prevent, we may discuss other scenarios.
Your feedback is highly appreciated,
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (