Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Lewis Rosenberg]

Up

0

Down

::

All inventory transactions are written to the Item ledger Entry table, so you might be able to write a report using the Item Table and the Item Ledger Entry table.

[Blaine Pennypacker]

Up

0

Down

::

Thanks, Lewis.

[Tiffany Collums]

Up

0

Down

::

I agree with Lewis on using the Item Ledger Entries and Item tables.

I go to Item Ledger Entries and sort Posting Date by descending order then export to Excel, then I delete duplicates by Item No. Then to get a comprehensive list of items with no activity or latest transaction date, I also take an export of all Items and do a vlookup against Item No and bring in the Posting Date from the Item Ledger Entries export. I can then filter by whatever date period I am looking for and it also will show me items with no transaction history too.

[Blaine Pennypacker]

Up

0

Down

::

Thanks Tiffany, nice idea!

[Saurav Dhyani (MVP)]

Up

0

Down

::

As Lewis said you can create a report with Item and Item Ledger Entries to identify items.

or You can do a small mod –

1. Create a new flowfield in Item (Ledger Exist).

2. The Flowfield should also utilize date filter to filter data in Item ledger entries.

3. Add that flowfield in List page.

4. Set Limit Total Filter to Date Filter Flowfilter.

5. Filter list with new Boolean as false.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

bit.ly

saurav dhyani

Hello & Welcome To Our You Tube Channel. Thank you for Visiting us. We hope you like the content published on the You Tube Channel. You can read Our Views about Microsoft Dynamics NAV on - Blog & Follow us … Continue reading

[Blaine Pennypacker]

Up

0

Down

::

Thanks, Saurav.

[Chris Warren]

Up

0

Down

::

Another option: If you have Jet Reports, you can quickly create this by filtering on the Item Ledger Entries (as previously mentioned) and doing a table filter based on the posting date. If you want this item-by-item, you can either prompt the report to ask you what Item Number or create a pivot table in that Excel sheet based on the data that Jet brings in.