Dynamics NAV/Business Central. Use own numbering on posted Sales invoices

Crazy right ? One of clients i support came up with that crazy idea. They wanted to manually capture the Posted sales invoice Numbers.
With Dynamics NAV/ Business Central default setup, Posted Number Series are added from Sales & Receivables setup.
Solution

• Add the "Posting No" to the sales order/sales invoice document page.
• Make sure the posting Nos. selected for Posting Numbers in sales & receivables setup allow manual numbers

The user can now add the posting number manually!

Cheers

Dynamics NAV login error "There is no company in the database. Contact your systems Administrator "/"You do not have the following permissions on TableData profile:Read"

Hello reader. This is my first blog in 2020 so Happy New Year. You are welcome. My colleague ran into a nasty error that took us sometime to resolve. Our client reported a problem so we needed to take a back up so we run it on our PCs for trouble shooting

However, upon restoring the database, and running Dynamics NAV 2018. It would throw this error on the screen.

Trying to run NAV 2018 in configuration mode (Via command-line ) now throws this error

To work around this issue, simply create a new user in Dynamics NAV power shell.

Give the new user super permission set.

To learn how to add users using power shell click here

Cheers!!

How to create Grouping in RDLC for Dynamics NAV Business Central

Hello reader, I would like to share with you a quick trick to  adding groups while designing your RDLC reports. We gonna create something like this!

I will assume you know how to create a basic report in RDLC.
Steps

• Create a dataset
• create layout
• Create your table
• After adding the rows
• Click the cell on the repeating rows where you want to add the grouping
• Right click.
• Select add parent group

• Select the field to be used for the grouping

You are good to go!
Save your report and run it.

For more details click here

Thanks to Archerpoint.com

Dynamics NAV all Customized controls disappear from Navigation menu

Hello reader, I know you are tense for answers. Keep calm because you are about to sort the problem once for all.
Yesterday i was doing final checks on a client's database before golive. Then i discovered my team had forgotten to add company information in the setup.

I was in a rush, so i accidentally selected "BASIC" option in the USER EXPERIENCE fast tab of the COMPANY INFORMATION page. Then hell broke loose! All the customizations on the clients' database suddenly disappeared! The entire team was in shock and we had to reschedule the launch to the next day. Here is the way around it.

That field is by default blank. Everything works just fine. Once you change its content, all customizations will disappear mysteriously.
In case you change it by mistake. Run table 9178 "APPLICATION AREA SETUP" in development environment and delete the record there.
Everything should be back to normal.

I got to know this through Mark Brummel's blog. He explains so much more there. Click here for details.
Good luck

STRMENU dialog in Dynamics NAV

Hello reader, am aware CAL is rapidly becoming old school. However, someone like you and me still find it useful. While i was working on a customization for some client, i realized the need to display a dialog selection menu similar to the one users pick while posting. This is something i had not encountered in a long time. It was time for me to check the archive to remind myself. Fortunately you wont have to check many places as am gonna show you how.
The illustration below shows the selection menu am talking about

Here is a sample code to achieve it. First some rules;

• Identify the menu options you want to display to users i.e invoice,receive, receive and invoice
• Identify the default option
• Craft a descent statement to accompany the dialog

Time to implement your dialog

selection := DIALOG.STRMENU('Order,Received,Processing,Finished',1,'Please select option to update status of transaction');

IF selection = 1 THEN BEGIN
  Status := Rec.Status::Order;
  MESSAGE('Status of order %1 successfully updated to ORDER',Rec."No.");
END ELSE IF selection = 2 THEN BEGIN
  Status := Status::Received;
  MESSAGE('Status of order %1 successfully updated to RECEIVED',Rec."No.");
END ELSE IF selection = 3 THEN BEGIN
  Status := Status::Production;
  MESSAGE('Status of order %1 successfully updated to PROCESSING',Rec."No.");
END ELSE IF selection  = 4 THEN BEGIN
  Status := Status::Finished;
  MESSAGE('Status of order %1 successfully updated to FINISHED',Rec."No.");
END;

Details of the function
DIALOG.STRMENU(list of menu options, default choice represented as an integer, message to accompany dialog);
The function returns an integer

please note;

"selection" is an integer variable.

"Status" is a table field whose options include {Order,Received,Production,Finished}

The text in message() maybe declared under text variables

Cheers!

MSDYN365BC - Cumulative Update 04 released for Business Central on Premises

Hello reader, Microsoft has released an update for Business central on premise according to Saurav Dhyani

There are a number of changes that Microsoft has made in the update. The most notable one is the fix for error when using the report "save as " function. For details about the fixes please follow this link

Cumulative Update 04 is available for following localized version (19) and Worldwide release.
AT - Austria
AU - Australia
BE - Belgium
CH - Switzerland
CZ - Czech
DE - Germany
DK - Denmark
ES - Spain
FI - Finland
FR - France
GB - United Kingdom
IS - Iceland
IT - Italy
NA - North America
NL - Netherlands
NO - Norway
NZ - New Zealand
RU - Russia
SE - Sweden
W1 - (All other countries)

Follow the link to the download site; https://www.microsoft.com/en-us/download/details.aspx?id=58092
Kind regards!!

DIMENSIONS IN DYNAMICS NAV 2018/BUSINESS CENTRAL

Hello guest;
I had an encounter with one of my clients. They needed a simple explanation about Dimensions in Dynamics NAV. I thought sharing it with you would be a whole lot better.

What is a Dimension?

A Dimension is the term used in Microsoft Dynamics NAV to define an analysis category. Dimensions are used to group, or categorize, data for the purpose of analysis. Dimensions consist of Dimension Values. A Dimension Value is a “subcategory” or a “tag” attached to data to conduct meaningful analysis (think of them like article tags on a blog). A Dimension can consist of any amount of Dimension Values.

An example of a dimension would be Product with dimension values

·       Drugar screen 18

·       Drugar Screen 15

·       Drugar Screen 12

Shortcut Dimensions 

Are analysis categories which facilitate financial, inventory, production, and other analyses.

Shortcut Dimensions can be assigned directly to journal, sales, or purchase lines; they can also be assigned to master data (e.g. a Customer, a Vendor, an Item, etc.).

We can only work with up to 4 shortcut dimensions in an analysis view.

This means we can categorize our data based on up to 4 categories using an analysis view.

To cover other categories, other analysis views have to be created

Example of a Shortcut Dimension

If a company sells coffee, and they are interested in running financial reports based on what categories of coffee are sold and where they were sold, the following Shortcut Dimensions can be created: Product and Area.

Area dimension with dimension values EU, COMESA, EAC, AGOA, US.

Product dimension as explained above

Global Dimensions in Dynamics NAV

Global Dimensions are the most important Dynamics NAV Dimensions for a company.

The maximum amount of Global Dimensions is 2.

Global Dimensions can be used in the same way as Shortcut Dimensions.

But unlike Shortcut Dimensions, Global Dimensions are located in the same database table as your master records.

This means that besides the possibility of using Global Dimensions as a filter on all Account Schedules, Batch Jobs, and reports, Global Dimensions can also be used as a filter on G/L entries.

Another unique feature of Global Dimensions is that they can be used as additional fields on purchase and sales document headers.

Example of a Global Dimension

If an institution is an NGO dedicated to promoting girl child education, an example of two Global Dimensions could be:

Project (what project/program donations are provided) and

Donor ( a private donor or an organization, a local donor or foreign, etc.).

These Global Dimensions would allow using a quick filter on the Chart of Accounts to break down an amount by Project and/or by Donor.

It is possible to break down an amount on a G/L Account by using Shortcut Dimensions. However, it would be necessary to create an Analysis View or Account Schedule report.