Error while opening RTC Dynamics 365 Business Central: You do not have the following permissions on CodeUnit ApplicationManagement: Execute

Dear Readers,

This blog is a summary to resolve this step and it is fine with all RTC Clients available from NAV 2013.

Step 1.

Use this query in SQL.

Use [DATABASE]
DELETE FROM [dbo].[User];
DELETE FROM [dbo].[Access Control];
delete From [dbo].[User Property];
delete FROM [dbo].[Page Data Personalization];
Delete FROM [dbo].[User Default Style Sheet];
Delete FROM [dbo].[User Metadata];
DELETE FROM [dbo].[User Personalization];

Step 2.

Open Administration Shell of NAV version which you are using via Run as Administrator

Type these 3 Commands.

Command 1

Import-Module "${env:ProgramFiles}\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1"

Command 2

New-NavServerUser -WindowsAccount 'domain\user' -ServerInstance InstanceName

EG. New-NavServerUser -WindowsAccount "xyz\user name" -ServerInstance DynamicsNav90

Command 3

New-NavServerUserPermissionSet -WindowsAccount 'domain\user' -ServerInstance
InstanceName -PermissionSetId SUPER

EG. New-NavServerUserPermissionSet -WindowsAccount "domain\user name" -ServerInstance DynamicsNav90 -PermissionSetId COST

Step 3.

Execute the SQL Command written below you need to change Domain\User.

SET NOCOUNT ON

GO

USE [DATABASE NAME]  -- NAV 2013 database you want to use

GO

DECLARE @UserID varchar(100)

SET @UserID = 'domain\Username'  -- Windows Login you want to add

-- Get security identifier (SID) for specified user.  Login must be setup in SQL Server first.

DECLARE @BinarySID binary(100)

SELECT @BinarySID = sid FROM sys.syslogins WHERE name = @UserID

IF @BinarySID IS NULL

  RAISERROR('SQL Server login not found for User %s.', 10, 1, @UserID)

-- SID is stored in the User table as a formatted string.  Need to convert it.

DECLARE @StringSID varchar(238)

DECLARE @i AS int

DECLARE @j AS int

DECLARE @Grp AS int

SELECT @StringSID = 'S-'

    + CONVERT(VARCHAR, CONVERT(INT, CONVERT(VARBINARY, SUBSTRING(@BinarySID, 1, 1))))

SELECT @StringSID = @StringSID + '-'

    + CONVERT(VARCHAR, CONVERT(INT, CONVERT(VARBINARY, SUBSTRING(@BinarySID, 3, 6))))

SET @j = 9

SET @i = LEN(@BinarySID)

SET @Grp = 1

WHILE (@j < @i) AND (@Grp <= 5) BEGIN

  SET @Grp = @Grp + 1

  DECLARE @val BINARY(4)

  SELECT @val = SUBSTRING(@BinarySID, @j, 4)

  SELECT @StringSID = @StringSID + '-'

    + CONVERT(VARCHAR, CONVERT(BIGINT, CONVERT(VARBINARY, REVERSE(CONVERT(VARBINARY, @val)))))

  SET @j = @j + 4 

END

-- Check to see if User record already exists

DECLARE @UserGUID uniqueidentifier

SELECT @UserGUID = [User Security ID]

FROM [User] WHERE [Windows Security ID] = @StringSID

IF @UserGUID IS NOT NULL

  PRINT 'User ID ' + @UserID + ' already exists in User table.'

ELSE BEGIN

  -- Generate new GUID for NAV security ID

  SET @UserGUID = NEWID()

  -- Create User record

  INSERT INTO [User]

  ([User Security ID], [User Name], [Full Name], [State], [Expiry Date], [Windows Security ID], [Change Password],[License Type],[Authentication Email],[Contact Email])

  VALUES(@UserGUID, @UserID, '', 0, '1/1/1753', @StringSID, 0, 0 ,'VE00AC832@yamaha-motor-india.com','') 

  PRINT 'Created User record for User ID ' + @UserID + '. - ' + CAST(@@ROWCOUNT AS varchar) + ' row(s) affected.'

END

-- Check to see if user is assigned to SUPER role 

IF EXISTS(SELECT * FROM [Access Control] WHERE [User Security ID] = @UserGUID AND [Role ID] = 'SUPER' AND [Company Name] = '')

  PRINT 'User ID ' + @UserID + ' is already assigned to SUPER role.'

ELSE BEGIN 

  -- Create Access Control record to add user to SUPER role

  INSERT INTO [Access Control]

  ([User Security ID], [Role ID], [Company Name],[App ID],[Scope])

  VALUES(@UserGUID, 'SUPER', '','2de23703-bbb9-4542-970d-84b6e5597f53','0')

  PRINT 'Added User ID ' + @UserID + ' to SUPER role. - ' + CAST(@@ROWCOUNT AS varchar) + ' row(s) affected.'

END

-- User Property record required to allow login

IF EXISTS(SELECT * FROM [User Property] WHERE [User Security ID] = @UserGUID)

  PRINT 'User Property record already exists for User ID ' + @UserID + '.'

ELSE BEGIN

  INSERT INTO [User Property]

  ([User Security ID], [Password], [Name Identifier], [Authentication Key], [WebServices Key], [WebServices Key Expiry Date],[Authentication Object ID])

  VALUES(@UserGUID, '', '', '', '', '1/1/1753','')

  PRINT 'Created User Property record for User ID ' + @UserID + '. - ' +  CAST(@@ROWCOUNT AS varchar) + ' row(s) affected.'

END

SET NOCOUNT OFF

GO

Advanced Financial Management Features available in MS Dynamics NAV 365 Business Central

Below features of Financial Management are available and useful for Demo purpose for Pre Sales Consultant. Detailed steps are available on MSDN Website. If readers require any explanation , please comment below and let me know.

1. Cost Accounting

2. Master data in Cost Center

Cost Type & GL Account

3. Cost Accounting Tab is available on Chart of Accounts

4. Cost Objects

5. Cost Accounting Setup

6. Cost Allocation Dynamic/Static

7. Cost Center Vs General Ledger Accounting

8. Workflow in Cost Accounting

9. Setting Up Cost Accounting

10. Cost Entries

11. Cost Budget

12. Cost Allocations

13. Cost Accounting reporting

14. CashFlowForecast

15. Cash Flow Source -> Suggest CashFlowForecast->Register Cashflowforecast->StoreCashflow entries

16. Cash Flow Sources

a. Receivables
b. Payables
c. Liquid Funds
d. Manual Expenses
e. Fixed Assets
f. Service Orders
g. G/L Budgets
h. Jobs
I. Taxes
j. Cortona Intelligence

17. Steps for setting up Cashflow Forecast

a. Chart of Cashflow Accounts
b. Cashflow Setup
c. Cashflow payments terms
d. Cashflow Worksheets

18. Financial Reports available

a. G/L Account Balance
b. G/L Balance by Dimension
c. G/L Balance/Budget
d. BalanceSheet
e. Income Statement
f. Stmt of Cashflow
g. Stmt of Retained Earning

19. Account Schedule

20. Cost Budget Entries

21. Cash Flow Entries

22. Creating Reports based on Budgets

23. Analysis by dimension

24.Update Analysis Report

25. Financial Chart on Business Mngr. Rolecenter

26. Account Schedules Chart Setup

27. XBRL Terminology

28. XBRL Instance , Schema , Specification , Taxanomy integration

29. XBRL.ORG website for reference

Features in WareHouse

1. Warehouse Flow

a. Sales Order
b. Create Whse. Ship
c. Register Pick
d. Pick Document will Generate Post
e. Post SO

2. Purchase Order
Create Whse Recipt
Register Receipt
Put Away is created And Post Put Away
receive the Purchase Order

2. Location Blue is free to Ship/Receive and White is the location which is completely setup for Warehouse Demo in Demo Database.

3. Setups available in Warehouse

a. Warehouse Setup
b. Warehouse Employee
c. Location Setup

Bin Policy is the mandatory tab for decision making

d. Warehouse Zone Setup.

Warehouse is divided in Zones and Zones are divided in Bins

4. What is Bin?

Smallest unit in Warehouse.

5. What are available Activity Types in Warehouse?

Pick, Pur Away,Put Pick, QC,Receive ,Ship

6. Bin Ranking

Bin Ranking is provided to Bins in same zone for proper selection to System.

7. What are Put Away Templates?

STD , VAR

8.Stock Keeping Unit

Advance and dedicated Item Card fro WareHouse Activity

9. Warehouse class field in Item Card.

10. Item Tracking is integrated with Warehouse for Serial No and lot no.

11. Internal Movements

12. Bin Movement via Movement Worksheet

13. Bin Replenishment

14. Block Movement specific to a Zone

15. Whse. Internal Picks/PutAways

16.  Flushing Method Field on Item Card

17. How is Production Flow integrated with Warehouse?

Released Prod. Order
Select Location Code
Select Bin COde
Referesh Production Order
Post Consumption
Production Journal
Create Whse Pick
Pick Document (Select Bin Policy Always Create Put Line)
Pick
AutoFill Qty. To Handle
Register Pick
Whse. INternal Put Away
New
Get Bin Content
Zone Code
Bin
Create Put Away
Put Away
Autofill Qty To Handle
Register Put Away

18. What is Assembly Order and Integration with Assembly Order?

Assembly Orders are Knitting multiple Items into one and it is fully integrated with Warehouse like same as Other Modules.

19. How to Receive Items in Warehouse?

Via Put Away and Register and Post Put Away Document.

20. Waht is Cross Docking?

When we dont want to do Warehouse Activity just direct Ship and Receive from Warehouse.

21. How to use WareHouse Item Journal?

Warehouse Entry Only option

22. Warehouse Register

23. Item Journal Post

24. Whse. Reclass Journal

25.Whse. Phys. Inventory Journal

26. Inventory Period Physical Invt. Counting Period Code on Item Card

27. WareHouse Entry Archieve.

28. How to Enter a lost item?

Whse. Item Journal -> Register -ve Qty. -> Goto Item Journal _> Run Calc. Whse. Adjustment Batch-> Post

29. Pick Worksheet

30. BreakBulk

This is also breaking higher unit of measure to smaller.

31. Integration of Service Order with Warehouse.

All the steps are available in MSDN Sites. This post I had created for demo purpose , if any reader needs a clarification then I can give a full dedicated post.

Nav Purchase Transaction Impact on Chart of Account

Purchase Cycle :

When a Item is purchased in MS Dynamics NAV using purchase order and purchase invoice some accounts are credited and other accounts are debited. So for functional side we must know what is the major impact. Let's see the impact in detail.

Step 1. Create an Item.

Choose any of the default Item Template to complete the Item Setup.

Step 2. Create Purchase Quote and click on Create Order.

Once this is done your quote will be converted to Order and we are receiving the order and now we will check what is the impact of receiving on accounting level.

+ in NAV means Debit and - means Credit for accounting purpose only.

For Inventory concept of sign is same.

Step 3 : When we receive a PO there is no impact on Accounting Side.

Step 4 : Lets post the Receipt using purchase Invoice Page.

When we post the invoice we get this final result.

In this final result we will check the COA in GL Entry which Account is debited and which account is credited.

1.G/L Entry :

Vendor Account Credited by 750

and

Purch. Payable Account is debited by 600 and VAT 150

What is the impact of payment for vendor invoice on G/L Account?

Now, vendor account is debited 

5410 is debited by 750

&

5310 Liability Account is credited by 750.

Top Must Know facts about MS Dynamics NAV

Hi All,

This post is dedicated is to increase the skills in MS Dynamics NAV I will update this page on regular

basis.

 I hope this series will help you all NAV Developer to improve Technical and Funtional both.

1. Data Caption Property of Table 

This property you can see on all masters and transactional pages in navision.

You are viewing the Customer name and No. on top of Page using this property only.

To check this you can see the Property of Table 18 DataCaption on NAV.

2. Master Table Exception

All master table like Vendor , Customer , Item all have first field No. governed by Number Series

Only Eception is GL Account Table which is not governed by Number Series.

3. Item Tracing Page 6520

There is a page in MS Dynamics NAV with ID 6520 which provide us the details about the Serial No.

 of a Item and all its ledgers related to this particular Item.

what is Navision ?
how many version are there is Navision?
How many objects are there in Navision?
Single Instance Codeunit and its Example?
Difference between Nav 13 ,13R2,2016?
what is Fact box?
Purchase line & primary key
Set range & Set filter
tableView in navision.
Get Set in nav
Autosplit key
Pages  ,report n table
Example of Auto Split key
Web Services
Visibilty Condition to hide fields
how to transfer data from 1 table to another table.
Locktable ,Why use
powershell instance ,how its works?
set filter setrange
dataitem link ,n data item view
ILE & value Entry relation
ledger primary key
Posting Routunes purchase line to posted ship
Xml port & export to excel
Rdlc property
basis of grouping
report trigger
instaalltion type
cost cutting
runmodel & page runmodel
job queue exmple
Sum index field exmple
delayed insert property
report flow
primary n seconday key,how itx wrks
flow fields n flow filters, exmple
Soap n o data differences
find n find last, find all difference
use of dimensions
onafter get current record n on after get record
Difference between 2 tier n 3 tier
Set currrent key n Get function
internal data flow in sales n purchase
16 featurs on RTC for Clint

Seven Questions To Ask At Functions Used In Nav.

Hi All,

This post is all about functions which are available in MS Dynamics NAV for Technical customisations.

So the First we have present is :-

1. STRSUBSTNO

Syntax :-

NewString := STRSUBSTNO(String [, Value1] ,...) 

It replaces all the %1 , %2 used in message.

Example:- 

STRSUBSTNO('Your balance is %1',Customer.Balance);

2.STRPOS

Syntax:-

Position := STRPOS(String, SubString)

It provides you the position of the string.

Example:-

Position := STRPOS('Navision','v');

3.STRLEN

Syntax-

Length := STRLEN(String);

It provides the length of the string .

Example :

Length := STRLEN('MSDYNAMICSNAV');

4.INCSTR

Syntax:-

NewString := INCSTR(String)

It increases the integer part in a string.

Example :

NewString := INCSTR('APU12');

Result will be APU13

5. COPYSTR

NewString := COPYSTR(String, Position[, Length])

It copies a part of string into new string.

Example :

Str := COPYSTR('Apurwa', 1, 3);    

6. MAXSTRLEN

MaxLen := MAXSTRLEN(String);

It returns the maximum String Length of the Variable.

Similarly, we have STRLEN to return the Actual String Length of a variable.

7. PADSTR

Str := PADSTR('MS DYNAMICS NAV', 50, 'd'); 

It can be used to select a part of a string on behalf of length and add a string if we want in a part.

8. DELCHR

NewString := DELCHR(String [, Where] [, Which])

To delete a particular character from a string.

You can use where as =,>,<,<>,AND,NOT

9.CONVERTSTR

Str := CONVERTSTR('MS DYnamics Nav', 'D', 'L');

It converts some string to another if present in the orignal string.

10. UPPERCASE & LOWERCASE

It converts a string in Lower and uppercase of orignal string.

11. SELECTSTR 

It retrieves the part of comma separated in a string.

Str := SELECTSTR(2, 'MS ,DYNAMICS ,NAV');

12. DELSTR & INSSTR

It deletes and inserts a part of string in orignal String.

Str := DELSTR('MS DYNAMICS NAV', 3, 8);

Str := INSSTR('MS DYNAMICS NAV', 'Anand', 8);

Thanks for giving your time to read this blog. Please do comment if you want more such post.

these are the system functions provided in MS Dynamics NAV.

The Miracle Of Hook In Ms Dynamics Navision 2016 and 2017?

Why to use Hooks in NAVISION ?

Hooks are the another ways to implement customisation in NAV 2016 and above.

Hooks Advantage :-

1. It increases Transparency.

      2. It increases Testability.

      3. It creates easy Upgradation of NAV versions.

      4. Separate Codunit for each objects. and there will be only a reference in base objects.

      5. Impact of Customisation will be minimum.

How to implement Hooks?

Step1.

Create a new codeunit which will be a parent codeunit and will be used for all customisation in NAV.

Step2.

Naming Conventions of HOOK

Microsoft Suggests Codeunit Process Name_HOOK for Eg. SIH_HOOK For Sales Invoice Header customisations.

Step3.

Create the hook and take an example to update a field and validate it before customisations.

for Example

Step4.

Reference it in Sales Post Codeunit.

Step5.

Implement all business logic in Hook Codeunit.

Summarize:-

Basically , it is another method suggested by MIcrosoft to write all code in one place so that implementation becomes easy to undertand and working smoothly.

To deploy Apps on Microsoft Partner Source you need to follow these guidelines provided by microsoft.

Thanks.

I hope this will surely hlp all my juniors to work and learn fastly, Please share my blog and comment below if you want another post or querry from my side.