Error 'The value 01/07/21 cant be evaluated into type date'

 I happened to encounter the above error. The rest of the users can run the same report without any issue. The problem is isolated to just this single user.

First i noticed the date format on the users PC is set to dd/mm/yy.

• To resolve the issue, change the date format to mm/dd/yy on the user's PC
•  Run the report, clear any date filters that are set on the report request page
• close the report
• Change the date format settings back to dd/mm/yy on the PC
• Close NAV and restart NAV
• The issue should be resolved

Uploading Development License to Business Central V17 on premise

 Hello reader. I would like to share something that took me some minutes to learn.Obviously if you are new to BC moving from older versions of NAV. You are used to importing the development license via development environment. In Business Central V17, things changed a bit, now uploading the license is done via Administration Shell using a few commands.

To make things easy, first move your development license to C:\ directory.

Run Business Central Administration Shell as administrator

Check the existing license information by executing command Export- NavServerLicenseInformation

The system will prompt you for the serverInstance  e.g BC170

Executing the command will display the license information.

Upload the new development license

With you Administration shell open.

• Run Import-NAVServerLicense command
• Provide licenseFile path in my case its in C: & the BC17.flf is the file name
• Provide ServerInstance in my case BC170
• Restart-NavServerInstance as in preceeding screen shot

You may check whether the new license is uploaded by running the command as in screen below

Good luck!!!

Credit  GoDigit

Dynamics NAV Item Unit Cost over a period

 Hello, i happened to get a request from our team in regards to item unit cost. They wanted to see how the unit cost of a certain item had been changing over a year. After reading on many blogs and trying out a couple of things. Something finally worked. So buckle up for the ride.

• First, when you open the item card and;
• Expand the invoicing Fast tab
• Click assist edit on standard cost for standard cost items or unit cost for items using average cost costing method.
• The average cost Calculation window/page is displayed.
• The closing entry on each date shows the adjusted average unit cost for the item as of that date.
• When you expand one of the closing entries, you see inbound & out bound entries (Un-adjusted) along with the unit cost for the item.

The second option will give us the inventory unit cost (Not adjust as in average cost calc overview) but the unit cost of all inbound entries.

• Open item card
• Select Navigate tab on the ribbon of item card
• Under item availability group, select statistics. Item statistics page is displayed
• On the general tab of item statistics page.
• Select "Cost specification" in the show as lines
• Select "Period" in the show as columns
• Capture the date range in "Date filter"
• Select "Calculate cost per unit" in the options fast tab

Then click show matrix

Then the unit cost statistics for the selected date range

Notice the inventory cost (LCY) i consider that as the unit cost.

Read more from community forum 

Dynamics NAV -No report data in report preview mode

 Dear Reader, my report doesn't display data in preview mode. However, when i print the document in PDF, the report prints out well.

I tried reading from a couple of blogs but could not get the cause. After trying out a couple of things something worked out.

• To solve the problem go to report properties
• Change the PreviewMode property to PrintLayout

That should solve the issue.

Cheers!!!

Dynamics NAV Error "Unable to open SQL Report builder, illegal Characters in Path"

 Hello reader, the above error is solved by repairing SQL report builder.

• Go to control panel
• Find SQL report builder
• Select & click Repair

Try running your report layout again, it should be fine.

Cheers !!!

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