Share
ReportGreetings 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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (