Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Exclude item without t...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Exclude item without transaction from counting

(1) ShareShare
ReportReport
Posted on by Valentin DORNIER 51
Hello experts ! 

Is there a way to exclude items for which no transactions have been made when generating a count job ? 
 
I'm using cycle count plans / Cycle count wok by item / Cycle count wok by location menus.
 
Thank you for your help :)
  • Valentin DORNIER Profile Picture
    Valentin DORNIER 51 on at
    Exclude item without transaction from counting
    Hello,

    Thank you very much for your answers. 
     
    @André Arnaud de Calavon, 
    I have found how to add the InventTrans table join. in the "Cycle count work by item" menu. 
    I will play with that to find the right filter to apply.
     
    Thank you very much ! :)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    Exclude item without transaction from counting
    Hi Valentin,
     
    In case you have an option to specify a query, you can add a table join. Then add the Inventory transactions (InventTrans) as table join which then will filter the item data source with items that have a transaction. In case an item is used in e.g. a quotation, then there is an inventory transaction. You can then add a range to include items with transactions having a specific status.
  • Suggested answer
    lvdtang Profile Picture
    lvdtang 1,901 on at
    Exclude item without transaction from counting
    Good day Valentin,
     
    I don't think so, I cannot find a function or feature for this requirement. 
     
    Best regards,
     
    Laurens van der Tang

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans