Dynamics NAV "You donot have permissions to modify Item Ledger Entry table"

Hello, one the users for the client i support came up with a crazy request for change. They wanted some data to be added to the external document number from Posted Purchase Invoice for Purchase Receipts.
I had to create a process only report & run it as a batch job to do it.
However on running the report, i received an error above.
The user i was using had super rights in the user permission set.

I looked up the web for some solutions.

The solution is to explicitly add the permission to the object via the object permissions property.

Dynamics NAV/Business Central Inventory Opening Balances

Hello there, as part of setting up new Dynamics NAV/Business Central Production Database. You will be required to import opening balances.
Today I will only talk about Inventory Opening Balances.

First you will be required to;

• Setup "Inventory Posting Setup" for your inventory items
• Setup "Gen. Product Posting Groups"

I am assuming that the items are already added to the item register

On your chart of accounts. Create an "Opening Balance Control Account"  Income/Balance should be Balance Sheet

Modify the setup "Gen. Product Posting Groups" let "Inventory Adjmt. Account" be set to "Opening Balance Control Account"

Using Item Journal.
Capture Journal Line.
Posting date should be Closing date of your financial year
Document No. your choice
Entry Type =Positive Adj
Item No. = Select Item
Quantity
The cost is automatically picked by the system
Post the entry.

Verify the Opening Balance Control Account is credited with the total value of stock
Check that the inventory item has the right quantity
Verify the inventory account is debited

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!