News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV forum Items Inventory Report

Microsoft Dynamics NAV forum

Answered

Items Inventory Report

(0) Share

Report

Report

Posted on by Puneet Singh

25

Hi Forum members,

I am new to NAV/Business Central product and trying to explore it for a specific need as mentioned below.

I have Dynamics NAV 2018 setup and I am trying to create a report on items inventory based on a date or date range. Required output sample is shown below:

I saw somewhat matching report is available (i.e. Items Inventory List) out of the box but it is not giving me exactly the same output. Is there a quick way I can get similar report or should I create a custom report using NAV developer tool?

Any help on approach is appreciated. Many Thanks.

Thanks,

Puneet

Categories:

Inventory and warehouse management

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Puneet Singh 25 on at

Like (0)

Report

RE: Items Inventory Report

Thanks for your reply, I really appreciate Steve. I will surly give it a try on analysis report

Many thanks!
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Items Inventory Report

Puneet,

I am not a developer so I will let those in the Forum reply... However, I would create an Inventory Analysis Report based on your Items and the Column Layout of No. Description, Description 2, QOH, Unit Cost, Math Calc, Unit Price, Qty Sold. Here is an example:

If this is not what you are looking for, consider Jet Reports. No coding and very simple to use. https://insightsoftware.com/microsoft/microsoft-dynamics-nav/

Hope this helps.

Thanks,

Steve

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2

Martin Dráb 228,625 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans