Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Reorder Point Report

(0) ShareShare
ReportReport
Posted on by 60

We do not use the replenishment module, so I am trying to use the Reorder Point Report with Fixed Reorder Quantity as the report format.  I have tried entering data at both the item and site level (we only have one site for raw material)  but cannot get the information to show up correctly on this report.  Any guidance on system set up for using fixed reorder point reporting will be greatly appreciated.

Steve

*This post is locked for comments

  • Re: Reorder Point Report

    Hi Steve,

    I have been testing this on my demo database.  I looked for an inventory item that wasn't appearing on the report.  I noted the quantity available and set the reorder points to an amount lower than the quantity available.  The item wouldn't appear on the report until I updated several periods in the Item2Hist table to show that there was significant activity in the PTDSlsQtyxx fields 3 periods prior to the current period.  I also had to make sure on the Option tab, that I ran the report for the 3 periods in which I indicated amounts in the PTDSlsQtyxx fields. Now the item appears on the report for reorder.

    Average demand for the product is taken into account on this report.  That's the way it seems to work.  It's not going to recommend reordering the item if it doesn't think the demand history for the item shows a need to reorder.

  • Steve Field Profile Picture
    Steve Field 60 on at
    Re: Reorder Point Report

    I sorry, but the explanation does not make sense.  It would if we were using the Replenishment module but we are not.  Historic (and sometimes future) demand can be used to set reorder points but once the reorder point is set, demand should have nothing to do with the item number showing up on the Reorder Point Report or not.

    Answering an earlier question, I have nothing populated in the options tab.

    Steve

  • Re: Reorder Point Report

    Steve,

    All I know at this point is what I explained above.  I can do more research and update this post when I have other information to give you.

    Based on what you have entered for your inventory item, does the above explanation make sense?

  • Steve Field Profile Picture
    Steve Field 60 on at
    Re: Reorder Point Report

    Carolyn, thank you for your answer, but the reorder point report should not have anything to do with demand.  My expectation is that once the on hand inventory quantity falls below a predetermined level, the item will show up on this report regardless of any demand.  Open purchase orders could also effect what shows up on the report.  That is how reorder point systems work.  Does SL do it differently incorporating demand?

  • Re: Reorder Point Report

    Hi Steve,

    There has to be sufficient demand for the item to have it appear on the report.  Here are some facts about the report.

    1. The demand quantity is built from the item2hist ptdqtysls?? by summing the history records together.

    2. It then determines the Dailyavgdemand (the average daily demand based on the ptdqtysls?? in the itemhist.

    3. It also looks at the PO lead time

    4. If the available is sufficient enough to cover the lead time, then reorder quantity is not populated and the item is left off of the report as the supply is sufficient as of now based on the average demand.

    You could test this by setting a high value into the ptdqtysls10 for this item / site in the item2hist using query.  Then rerun the report. You can see the Dailyavgdemand value in the PO04740_wrk while the report is running.

    Try putting a value in the ptdqtysls10, run the report and look at the work table value.  Close the report and update the ptdqtysls10  to maybe half that amount, rerun the report and look at the value. You should see the dailyavgdemand values changing between the two reports.

    Also let me know if you have anything populated on the  Options tab of the report.

    Let me know what you find.

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans