Skip to content

x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 9 replies
  • Subscribers 104 subscribers
  • Views 1942 views
  • Users 0 members are here
Browse Forums
Announcements
326
topics
378
replies
Business Object Interface
1k
topics
8k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
13k
replies
Distribution, Manufacturing, and Applications
2k
topics
8k
replies
General Discussion
1k
topics
4k
replies
Partner Cloud
58
topics
118
replies
Payroll, Time Tracking, and Job Cost
827
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Sage CRM for Sage 100
171
topics
372
replies
Technical and Installation
2k
topics
10k
replies
Year-end Forum
95
topics
254
replies
jland47

ReOrder Points

Posted By

We have set reorder points on all our products we inventory, these items are flagged by a udf in CI_Item.  The reorder point report in Sage looks kind of clunky to me and I was trying to get a notification to order items below the reorder point.  I've read a few other post on this and nothing seems to stand out as best practice.  We do have IRP that will generate the PO when we run it, but still need something to bring it to the purchasers attention.  I did create a spreadsheet pulling data from IM_ItemWarehouse with a few filters and I was going to set a bat file on the windows task scheduler to open the excel file on the specific employee in charge of reordering.  I did see something about scripting to notify a user an item is below the reorder point but, it looks like it would be the user entering the item in SO.  Any better ideas other than purchasing a third party solution.

Parents
  • 0

     I personally use and highly recommend Jeff-Net Report Runner to schedule and automate custom reports. I use this tool to send out Sales and various department reports for the last 5+ years and its amazing. I even use it to generate static Excel sheets on our server and then report off the Excel files in custom reports and batch email those reports. Highly scalable and easy to use. 

    Check them out, I believe they offer a demo.

    https://reportrunner.com/products/crystal-reports-scheduler-automation

    In your case, you could use this UDF as the record selection on your custom report and then email that list every morning to the purchaser.

    Hope this helps.

Reply
  • 0

     I personally use and highly recommend Jeff-Net Report Runner to schedule and automate custom reports. I use this tool to send out Sales and various department reports for the last 5+ years and its amazing. I even use it to generate static Excel sheets on our server and then report off the Excel files in custom reports and batch email those reports. Highly scalable and easy to use. 

    Check them out, I believe they offer a demo.

    https://reportrunner.com/products/crystal-reports-scheduler-automation

    In your case, you could use this UDF as the record selection on your custom report and then email that list every morning to the purchaser.

    Hope this helps.

Children
No Data

*Community Hub is the new name for Sage City