Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

help - user can't release Journal Transaction

Posted on by 3,205

dear all,

I need help please. there is user who have access to create journal transaction. but the problem, whenever she want to release, always show a message:

---------------------------
System Message 6812
---------------------------
You do not have proper access rights for this screen.
---------------------------
OK   
---------------------------

If I put access "release gl batch" screen for that user with view-update-insert, the user can release. but new problem come, we won't user can't access the "release gl batch" screen.

need help please.

we use SL 2011.

thank you

*This post is locked for comments

  • rodi Profile Picture
    rodi 3,205 on at
    RE: help - user can't release Journal Transaction

    hi,

    thanks for code. but I'm still confuse. ok here more detail:

    - there user called BR.

    - when the user open "Release GL batch" screen, the user only can release for certain batch(es) that has sub account 11-00-11

    I want to make filter on those. any advice?

    thanks

  • Ajit Kannan Profile Picture
    Ajit Kannan 1,240 on at
    RE: help - user can't release Journal Transaction

    Hi Rodi,

           StrSql = "Select * from  vs_usergrp where userid = " & SParm(Trim(bpes.UserId)) & " and GroupId ='XXX'"

           intRet = SqlFetch1(CsrTmp, StrSql, bUserGrp)

           Call SqlFree(CsrTmp)

           If Trim(bUserGrp.UserId) = "XXX"  and Trim(bUserGrp.UserId)  = "XXX" Then

           Else

               Call MessBox("Your not authorised user", MB_ICONINFORMATION, STRCPNYID)

               Exit Sub

           End If

    Thanks,

  • rodi Profile Picture
    rodi 3,205 on at
    RE: help - user can't release Journal Transaction

    hi. yup that's what I mean.

    I'm willing to put some vba code for that group user. but I need manual about SL coding first.

    anyway, thanks for help :)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: help - user can't release Journal Transaction

    Do you mean can NOT process other batches from other users ?

    It is "all or nothing" when you give rights to a screen meaning that anybody's batches could be released.   You might be able to put some VBA code on the screen to restrict what batches can be released.  

  • rodi Profile Picture
    rodi 3,205 on at
    RE: help - user can't release Journal Transaction

    hi,

    thanks for suggest.

    user has rights for 01.010.00.

    but for:

    01.011.00  rights are needed for the batch control.

    --> i think this will be ok to give the user.

    01.400.00 rights are needed to release a GL batch.

    --> can I make limitation, so that the user can process other batch on this screen, since the user can run this screen.

    thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: help - user can't release Journal Transaction

    01.011.00  rights are needed for the batch control.

    01.400.00 rights are needed to release a GL batch.

  • Suggested answer
    Ajit Kannan Profile Picture
    Ajit Kannan 1,240 on at
    RE: help - user can't release Journal Transaction

    Hi  Rodi,

    Make sure user has rights for Journal Transactions( 01.010.00) screen defined in Access Rights Maintenance (95.270.00). 

    Thanks,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans