Cross Reference No – Item


Hey Friends,

There’s many features in standard NAV which we normally don’t use, not because we don’t want to but just because we are not aware. Item Cross Reference is one of the out of the box feature which I belief is rarely used by the end users but it’s really an awesome one for them to use in there day to day data entry process. The basic benefit of this is you don’t have to look for Item No every time, just your unique reference and it will automatically bring the respective item, Variant and so on.

So here’s what you need to do – Open Item List

Here as highlighted in screenshot you need to open Cross Reference and do the respective setup’s. This you need to do for each and every Item. So here we are doing for Item I000009.

Here you need to put the Customer No for the Customer’s you want to do along with the Variant and Unit of Measure Codes. Cross Ref No will be the key to identify this.

Now you need to navigate to Sales Order and you are supposed to make the new one.

Now as you see the screenshot we took the same customer for which we did the setup, Now we need to navigate to Line Items and push the drop down for Cross Reference No. Generally Cross Reference No is not visible so you need to choose it from Choose Columns. So once you hit the Drop Down you will have the list of Cross Reference’s that you did the setup for. Now you just have to hit OK and you will have your line item ready.

So by this you don’t have to look for your Item No every time. Just one setup as per your convenience and you are good to go.



Custom Form – Dynamics NAV

Hey Friends,

As we all know we have certain limitations while designing a Page in NAV, i.e. We deliberately cant design our NAV Page as we want to, Actions OR Buttons must be on the Top, We cant make buttons somewhere on the middle of the Page, We can’t design a page in which we can have multiple controls like Buttons, Radio Buttons and so on and possibly anywhere on the Page.

This limitation could be sorted out if we have certain hands on, on Dot Net variables. I just got a requirement where client was asking for certain design on the Page as per his requirement and he hardly cares for the limitations. So I just make a custom Windows Form which anyhow fulfilled his requirement.

You have the liberty to add n number of buttons or other controls or how badly you want to customise it.

WinForm := WinForm.Form;
Colour := Colour.Color;
WinText := WinText.TextBox;
WinForm.Width := 733;
WinForm.Height := 415;
WinForm.BackColor := Colour.Green;
WinForm.ForeColor := Colour.Green;
WinForm.Text := ‘SMS BODY’;
WinForm.StartPosition := StartPosition.Manual;

WinForm         DotNet       System.Windows.Forms.Form.’System.Windows.Forms, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089′

WinText          DotNet        System.Windows.Forms.TextBox.’System.Windows.Forms, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089′

Colour            DotNet          System.Drawing.Color.’System.Drawing, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’

Off The Topic – Shutdown Machine from NAV

Hey Friends,

This Post is just a part of Brainstorming, and doing a research worth needed having out of the box thought that If Client just want to shutdown Machine directly from NAV. Though it will never be demanded but on the counterpart Client Expectation has no limits. 🙂

The interesting part is it’s just a single line of Code which will do the Job .

Process.Start(‘shutdown’,’/s /t 0′); – Shutdown
Process.Start(‘shutdown’,’/r /t 0′); – Restart

Process – DotNet – System.Diagnostics.Process.’System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089′