Announcements
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
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.
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
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?
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?
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.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156