Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Record in ReqTrans wit...
Supply chain | Supply Chain Management, Commerce
Unanswered

Record in ReqTrans with zero quantity causes error in Planning optimization

(1) ShareShare
ReportReport
Posted on by Lennart Lauterbach 73
Dear community members,
 
from time to time we find faulty records in ReqTrans table. Those records contain no item number, no quantity and refer to a plan version /0/. Here's an example:
 
When Planning optimization is enabled those records prevent the master planning to be executed from explosion or net requirements:
 
We have already been in touch with MS support and they provided an SQL query to select and delete faulty records from ReqTrans table. But it's not an ideal solution if we have to run that query every few month, not knowing how those records are created in the first place. So if anyone of you has experienced the same issue or has an idea how to prevent that from happening again, your help would be highly appreciated!
  • Lennart Lauterbach Profile Picture
    Lennart Lauterbach 73 on at
    Record in ReqTrans with zero quantity causes error in Planning optimization
    Hi Andre,
     
    thank you for your suggestion. I will set up an alert and see if I can see any correlation once the issue occurs again.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,661 Super User 2024 Season 2 on at
    Record in ReqTrans with zero quantity causes error in Planning optimization
    Hi Lennart,
     
    In the initial question, you mentioned "from time to time". Now you mentioned that this happened "only the second time". I do understand you concern when you would do a rollout and the root cause is unknown. In theory it can happen more and more. 
    I can't judge if your customization can be related or not. You can review it. You can also set alerts when records will be created without an Item ID. In case it would happen again, you can get notified and probably you have then some fresh information to check for a root cause.
     
  • Lennart Lauterbach Profile Picture
    Lennart Lauterbach 73 on at
    Record in ReqTrans with zero quantity causes error in Planning optimization
    Hi Andre,
     
    we have added some fields from PurchTable and SalesTable to the Net requirements form which are updated when MRP is run. But so far I have not connected those extensions to our issue. This is only the second time it has happended during the past three years, in two different legal entities. But due to the fact that more and more of our legal entities will implement D365 in the coming years, I have the fear that we will face that issue more often.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,661 Super User 2024 Season 2 on at
    Record in ReqTrans with zero quantity causes error in Planning optimization
    Hi Lennart,
     
    I haven't seen this behavior myself. Do you know if you have customizations in this area? How many times does this happen in your environment?

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans