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. UnknownFebruary 28, 2017 at 10:53 AM

    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
  2. Ambarish UpadhyayApril 9, 2018 at 10:14 AM

    please share complete guide.

    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
2 comments
Read more

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 ).
9 comments
Read more