web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Reorder Point Report
Microsoft Dynamics SL (Archived)

Reorder Point Report

(0) ShareShare
ReportReport
Posted on by Steve Field 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

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    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.

  • Steve Field Profile Picture
    Steve Field 60 on at

    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?

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    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

    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

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans