Opening, Received, and Closing Stock per location Report

(0) Share

Report

Posted on by Dynamics 365 F7O

Greetings Experts,

Kindly advise on the data items that I can use I designing a report that shows Opening, Received, and Closing Stock per location at a specific date

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

You can try with Item Ledger Entry Data Item.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Or you could use the Item table and set a flowfilter covering the location and period you want to have a look at.

I think that would be easier then using the item ledger entry table. Especially if it is only the inventory level you want to look at.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

To add to Inge's comment.

Filter Item Ledger to location and date filter (..beginning date)

Filter Item Ledger to location and date filter (beginning date..ending date)

Filter Item Ledger to location and date filter (..ending date)

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,449 Super User 2025 Season 2 on at

Like (0)

Report

Hi, There is no perfect inventory report in NAV. I recommend developing a simple Query using Item ledger Entries.

PS: If you use Item to query, you can query the results through Limit Total, but you need to check each location separately. (because only one inventory is shown)

If you use Item Ledger Entries to query, there are only line records, no summary.

Hope this will help.

Thanks.
ZHU

Was this reply helpful? Yes No
Verified answer

Dynamics 365 F7O 90 on at

Like (0)

Report

Wow!! Thank you guys

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Dynamics 365 F7O,

In NAV I would create a report that pulls the Item Ledger Entries based on Starting Posting Date, Date Range for Month for Posted Receipts, Ending Date.

You could design a Jet Report very easily doing for these fields.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No