Friday 28 August 2020

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 



Friday 14 August 2020

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!!!

Friday 7 August 2020

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 !!!