You’re offline. This is a read only version of the page.
90
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
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
Wow!! Thank you guys
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
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)
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.
Hi,
You can try with Item Ledger Entry Data Item.
#1
Sohail Ahmed
815
#2
YUN ZHU
773
Super User 2025 Season 1
#3
Mansi Soni
559
Share
Report
All responses (
Answers (
