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.

Development with XMLPORT

XMLPORT is used for importing/exporting data from excel , text or XML in NAV.

What are the common requirement for XMLPORT by Client are listed below with ERRORS NAV Developer can face. So get ready to learn and explore.

Requirement 1. SKIP EXCEL Header.

This requirement is common while importing from Excel in NAV tables.

Solution.
Define a Boolean Field and write code as in Screen Shot.

 

Requirement 2.
Use OF EVALUATE Function to convert the Datatype.

Error 1.

Microsoft Dynamics NAV
---------------------------
Data at the root level is invalid. Line 1, position 1.
---------------------------
OK
---------------------------
Solution:

Error 2.

Microsoft Dynamics NAV
---------------------------
'', hexadecimal value 0x03, is an invalid character. Line 1, position 82.
---------------------------
OK
---------------------------
Solution :

Convert your Excel File to CSV Format.

 

Flow of Triggers in XMLPORT during Import of XMLPORT

OnInit

 

OnPre

 

OnAfterInit

 

Text Variable OnAfter Assign

 

OnBeforeInsert

 

OnAfterInsert

 

Root Import

 

OnPost Trigger

What is the difference between ODATA URL and ODATAV4 URL in NAV?

Hi ,

Today while working on API I got this new ODATA V4 url in NAV 2018. Best part is it will help Nav developers to provide JSON data.

Yes this is correct whenever you will give ODATA V4 Login you will receive a json format data from NAV 2018.

ODATA V4 URL :

Result 1 : ODATA URL

Result 2 : ODATA V4 URL

Result 3 : SOAP Result.

API communication in MS Dynamics NAV 2018 Now Business Central.

Hi All ,

Once again I am getting stuck with calling of API in MS Dynamics NAV in my Germany office so I

thought why not get a dive into the sea of API. And lets check what it is in reality.

What is an API ?

Google says API is an Application Programming Interface. A way which provides us a facility to get 

data from another server.

But I cant understand now also. So lets get some diagrammatic view of an API.

I have a requirement from customer whenever a payment is done by a customer we need to check 

whether the customer has a credit balance to buy the article if no then send the notification to 

customer please contact the owner to increase your credit balance.

So here we were suggested to come with a solution of API we need to create one API which will be 

used by Paypal developers to checks whether this transaction is allowed or not.

I hope you got the point that what is an API.

API is generally a program written to say outer world that we will give you your data just send me 

the url for this requirement. In our example , my developed API will take the parameter of customer 

No. and will check in our customer table below points :

1. Customer Exist or Not.

2. If Exist , check the credit balance and proceed.

I hope concept is clear and requirement is also clear.

So what NAV developers will do now , we will create codeunit and will check the conditions and 

expose it to web service. But now we want to interpret with Paypal and they suggested API.

How to use API in NAV 2018?

First we will see how we can use then we will create API also.

Requirement from NAV Side :

1. Enable your NAV 2018 Admin for Soap and Odata Url.

If you want to go in more deep about API follow this video.

2. Search for API Setup page. Open it and click on Integrate API function it will populate all API present in NAV in Table API Web Service.  This is new system table.

3. We can check the data in Page but we need to create one page for this , as I had created this page on table API Web Service.

Please check how to create page on this table if you dont know in NAV from MSDN.

Lets Run this page.

You can create a web service for this page and check the data for this on browser.

The result of the data will be in JSON Format.

These are the following APIs provided by NAV 2018.

How to call API of NAV?

This is the URL provided by MSDN:

 http://<<Server Name>>:<<OData Port>>/<<Service Name>>/api/beta

For me its :

http://localhost:7048/DynamicsNAV110/api/beta

Hint : If you are not familiar with the url just open web service page and click on URL fields. There are 3 fields

ODATA V4 URL

ODATA URL

SOAP URL

With this you will get the desired URL for your system I followed the same.

After some time the result is as in Screen.

Now if its an API URL it should be present in POSTMAN. Lets check there also the result of our API  data is it available to other world.

For this I will write a new POST.

But I get 1 point now Microsoft is going to Business Central to a next Level of Data Library.

How to create New Nav Company using powershell?

Hi All,

Today I got one situation where we need to create a new NAV database from database itself and add the FOB and when we try to open it.

NAV will give us the ERROR 'No Company is found' or something like that.

So I interacted with powershell and sharing the basic steps to create Company in powershell if my nav developers get stuck in between.

SO lets start with powershell.

Step 1.

Open MS DYNAMICS NAV 2018 Administration Shell with Administrator Mode (Very important)

Import the Module using this command.

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

Step 2 .

Once it is imported Follow below screenshot :

It will take a while , if instance is running and everything works fine you can proceed with running your new company in RTC.

How to call stored procedure from MS Dynamics NAV 2018 using Automation Variable?

Automation Variable in NAV 2018

Frankly this is my first interaction with automation variable in my project. So I want to share with NAV community how can we connect our SQL Database and interact with stored procedures to process NAV database.

Step 1. Take the below variables.

Name                  DataType                          Subtype

lADOConnection Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection

lADOCommand Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Command

lADOParameter Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Parameter

lvarActiveConnection Variant

Step 2. Write the below code :-

IF ISCLEAR(lADOConnection) THEN

CREATE(lADOConnection,FALSE,TRUE);

//lADOConnection.ConnectionString := 'Driver={SQL Server};Server=Server Address;Database=Database NAme;Uid=sa;Pwd=Password;

Check with other users also but provide some admin rights on SQL.

  lADOConnection.Open;

  IF ISCLEAR(lADOCommand) THEN
  CREATE(lADOCommand,FALSE,TRUE);
           
  lvarActiveConnection := lADOConnection;
  lADOCommand.ActiveConnection := lvarActiveConnection; 

  lADOCommand.CommandText := 'Stored Procedure Name';

  lADOCommand.CommandType := 4;
  lADOCommand.CommandTimeout := 0; 


  lADOCommand.Execute;

  lADOConnection.Close;
  CLEAR(lADOConnection);
  CLEAR(lADOParameter);
  CLEAR(lADOCommand);

 MESSAGE('Done Successfully');

So NAV Readers just try this code if you face any issue , comment below. Also for some usage bookmark this page.

Dynamics NAV 2018 Cumulative Update 03 is Available

Nav 2018 CU3

Hi All ,

You can download your latest updated CU3 for NAV 2018 from this below link :

https://www.microsoft.com/en-us/download/details.aspx?id=56618

Cumulative update installation and other pre requisites are also available on the web page.

This cumulative update is available in below regions :

Download Summary:

1.	CU 03 NAV 2018 AT.zip
2.	CU 03 NAV 2018 AU.zip
3.	CU 03 NAV 2018 BE.zip
4.	CU 03 NAV 2018 CH.zip
5.	CU 03 NAV 2018 CZ.zip
6.	CU 03 NAV 2018 DE.zip
7.	CU 03 NAV 2018 DK.zip
8.	CU 03 NAV 2018 ES.zip
9.	CU 03 NAV 2018 FI.zip
10.	CU 03 NAV 2018 FR.zip
11.	CU 03 NAV 2018 GB.zip
12.	CU 03 NAV 2018 IS.zip
13.	CU 03 NAV 2018 IT.zip
14.	CU 03 NAV 2018 NA.zip
15.	CU 03 NAV 2018 NL.zip
16.	CU 03 NAV 2018 NO.zip
17.	CU 03 NAV 2018 NZ.zip
18.	CU 03 NAV 2018 RU.zip
19.	CU 03 NAV 2018 SE.zip
20.	CU 03 NAV 2018 W1.zip

Download MS Dynamics NAV 2018

Finally Download your MS Dynamics NAVISION 2018

Finally the wait is over and you can download your latest version of MS Dynamics NAV 2018.

If you have your partner source email id then Visit Here.

Download with Partner Source Email ID

Direct Download From Waldo

Enjoy the new Deal from Microsoft.

Microsoft New Latest Release NAV 2018

Microsoft Latest Release TENERIFE MS Dynamics NAV 2018

So Friends,

Microsoft is going to release its next version of NAV and it is known to be MS Dynamics NAV 2018.

TENERIFE

So wait for the latest release of MS Dynamics NAV 2018 at my blog.

This blog post will update you all latest knowledge of MS Dynamics NAV 2018.

"Tenerife" will be able to use online 24 * 7 Artificial Inteligance Web Services like capability to take decision on behalf 

of images and activities.

Hope So ,Microsoft will also extend its capabilities in Dynamics 365 Finance and

Operations Business edition.

New Development tools for NAV 2018

Drag and Drop Facility for several customization steps.

Visual Studio to develop extensions in MS Dynamics NAV.