Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

Posted on by 372

Hello,

Does anyone know what causes this error? It pops up when our users Sort by remaining amount then highlight the records they want to set applies to ID in. Super users can do it, but cannot figure out what permission set it is that causes this error.

pastedimage1579023482328v1.png

  • ChazKimRP Profile Picture
    ChazKimRP 372 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    HI we figured this one out. One of the permission sets on the user had a security filter for an unrelated table. If there is any security filter, the user cannot sort by a flow field then edit the record.

    My new question is there a different way maybe through code to hide specific records? Basically trying to hide vendor ledger entries where it is a specific Vendor No.

  • ChazKimRP Profile Picture
    ChazKimRP 372 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    Yes for cust. Ledger Entry(21) and Detailed Customer ledger entry(379). I even just recorded me doing it as a Super User, went and applied that permission set to the user and it still didnt work.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    Does the user have the insert, modify and delete permissions, I mean direct permissions?

  • ChazKimRP Profile Picture
    ChazKimRP 372 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    I dont have access to that code, but why would the super user be able to and not the user with permissions? Is there like a separate security table they need.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    you can try this, In that function, for the CustLedgEntry record variable change the property of the security filtering from validated to filtered as specified in the error.

  • ChazKimRP Profile Picture
    ChazKimRP 372 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    SetApplId(VAR CustLedgEntry : Record "Cust. Ledger Entry";ApplyingCustLedgEntry : Record "Cust. Ledger Entry";AppliesToID : Code)

     CustLedgEntry.LOCKTABLE;

    HERE IS THE ERROR  IF CustLedgEntry.FINDSET THEN BEGIN

       // Make Applies-to ID

       IF CustLedgEntry."Applies-to ID" <> '' THEN

         CustEntryApplID := ''

       ELSE BEGIN

         CustEntryApplID := AppliesToID;

         IF CustEntryApplID = '' THEN BEGIN

           CustEntryApplID := USERID;

           IF CustEntryApplID = '' THEN

             CustEntryApplID := '***';

         END;

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    Can you try to debug and check where the error is happening?  looks like a permission issue

  • ChazKimRP Profile Picture
    ChazKimRP 372 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    Hello,

    Negative. We do not have any security level filters in the permissions table for these users.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Cannot Select Multiple "Apply Entries" after Sorting by Remaining Amount

    Did you add any security filters in the permission set for those users, check for the cust. ledger entry table permissions and detailed cust. ledger entry permissions

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans