Skip to main content

Location wise User access to post the inventory transaction


In Dynamics NAV, if you are using the warehouse functionality like warehouse receipt and warehouse shipment then you have an option to define the location wise user access but what if you are not using warehouse functionality and just doing inventory transaction.

One of my client had a same scenario, they have multiple branches and keeping stock over there. now the problem was any branch employee can post the inventory in other branch location if the user has the inventory posting rights. Their requirement to stop the user to post the inventory in other location and restrict them only to their assigned location.

Below is the solution we implemented and it worked...!!!

Create New table Called "Location Employee" with User ID and Location Code field so here you can assign the User ID against the location code. it could be single or multiple.

Once this defined, you need to write small code under codeunit 21 - Item Jnl.-Check Line under Runcheck function to find the relation of the user id and location based on the item journal line. if it is found then it is allowed or system will give error message. it is simple ..

I hope this will help you if you have same problem.

Regards,

Saurabh Shah




Comments

  1. Hi,

    Is there any other way to restrict a user to a single location? This does not mention a version. What about in 2016?

    Thanks

    Amal

    ReplyDelete

Post a Comment

Popular posts from this blog

Dynamics 365 Business Central - Key Board Shortcuts for Quick actions

We all are very much familiar with the Dynamics NAV shortcuts to do day to day transactions but what about the Business Central.  Below are the Key Board Quick reference shortcuts for some of the most used actions.  Blog Referenced to Microsoft Post. here

COMMENT AND UNCOMMENT MULTIPLE LINES OF C/AL CODE IN NAV 2015

We can add and remove comment marks manually for each line till now. But from now the Comment Selection and Uncomment Selection options available in the Edit menu. The Comment Selection and Uncomment Selection options enable you to comment or uncomment multiple lines of code all at once.   To comment lines of code, select the lines, and then, in the Edit menu, choose Comment  Selection ( Shift+Ctrl+K ). To uncomment lines of code, select the lines, and then choose Uncomment Selection               ( Shift+Ctrl+O ).

Microsoft Dynamics Business Central Cumulative Update Summary - May 2022.

  Hello Readers, Microsoft Released Cumulative Update for May 2022 for Business central 14, 18 & 19. Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 18 & 19. Below are the Links to Download the Latest Cumulative Update. #msdyn365bc14, #msdyn365bc18 #msdyn365bc19 1. Title - Cumulative Update 19.7 for MSDYN365BC 2021 Wave2 Update on-premises (BC19)    Application Build No. -  19.7.39830    Platform Build No. -  19.0.39770    Local versions -  AT,AU,BE,CA,CH,CZ,DE,DK,ES,FI,FR,IS,IT,MX,NL,NO,NZ,RU,SE,UK,US    Details of Update    Download Link    Docker Pull Request -  Get-BCArtifactUrl -type OnPrem -version 19.7 -country w1    ** Replace w1  with local version that you need. 2. Title - Cumulative Update 18.13 for MSDYN365BC 2021 Wave1 Update on-premises (BC18)    Application Build No. -  18.13.39821    Platform Build No. -  18.0.39769    Local versions -  AT,AU,BE,CA,CH,CZ,DE,DK,ES,FI,FR,GB,IN,IS,IT,MX,NL,NO,NZ,RU,SE,US,W1    Details