web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Preventing the Posting of Specific Journal Entries

(0) ShareShare
ReportReport
Posted on by

Hello:

So far, the only means that I know of for accomplishing this is by using Account Level Security in GP.

What we would like is the ability to prevent end users from posting journal entries that originated from various windows of the Bank Reconciliation module, such as Bank Transaction Entry.  Those same users would be allowed to post other journal entries.

Yes, the GP Posting Setup window has password protection for approving journal entries prior to posting.  But, this represents all journal entries, whether they originated in a separate module or subsidiary ledger or not.

I did see where my predecessor may have tried accomplishing this sort of security by creating SQL table manipulation in Access as a means of adding additional "Origins" to the Audit Trail Codes Setup window. 

When he did this, he was able to create new audit trail code prefixes.  And, by having these new Origins, he was able to have multiple Origins for "General Entry" be available in the Posting Setup window.  That way, you could set a different approval password for each origin and therefore the same window!

Again, I can't figure out if he was actually trying to secure access to certain audit trail codes and Origins as a means of preventing posting certain journal entries.  Perhaps, he had another purpose for creating new Origins.  I don't know.

Anyway, other than using Account Level Security, is there a way of conducting such a granular level of security?

Thanks!

John

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: Preventing the Posting of Specific Journal Entries

    Good ideas, all around!  Thanks, Heather!

    John

  • Verified answer
    Heather Roggeveen Profile Picture
    9,146 on at
    RE: Preventing the Posting of Specific Journal Entries

    Hi John

    The only way I can think of, without serious customisation, would be to:

    - Turn off access to Financial Series Posting and Master Posting.

    - Restrict the lookup of batches in Financial Batches - now I know there is a security setting somewhere on that because when this current security model first came in I had issues where users couldn't "look up" but they could still enter a batch ID that existed.

    - Restrict the lookup in Journal Entry.

    - Turn off transaction level posting in Financial if it is currently allowed.

    That would at least mean users would have to enter a valid batch via the batch entry window in order to post.

    You could probably also put vba on the batch ID field so that if they did enter a batch ID that related to Bank Transactions that it would not allow them to do it.  I can't tell you how to do that, just that as an idea.

    Cheers

    Heather

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans