x Want to participate? Join the group to interact
Options
  • Replies 10 replies
  • Subscribers 120 subscribers
  • Views 1492 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
963
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
Rick Savoy

MP_04SuppliesAndDemands

Posted By

We are upgrading to Sage 2021 from 2017. The  MP_04SuppliesAndDemands view has been retired from Sage 2021. However, my staff does not want to give up the (very robust) MRP tool we  developed in house. Consequently, I need to recreate it. Can someone provide me with the query(s) that were used to build this view?  Thank you!

Parents

  • Rick,

    Did you find that file? I was just told by my reseller that MRP is still available in 2021 and 2022. Your post made me very nervous on Sunday. 

    We also have used MP_04 and MP_05 to make an online MRP that our purchasing staff use. Much better than paper. Losing that would be devastating with a planned, suitable replacement.  

  • in reply to Dain

    No, not in the Premium version. I'm told by my provider that those tables are available in Sage Advanced 2021 (Providex backend) but not in Sage Premium 2021 (SQL backend)- which is what we are upgrading to. I'm also told, those tables will not be available in any version of 2022.  

  • in reply to Rick Savoy

    I should also add that I spoke with Sage support and found out that MRP was designed by Scanco, as was the new IRP module. I am contacting Scanco now to see what information/assistance they can provide.

  • in reply to Rick Savoy

    Exactly. We had been advised to stay with Advanced precisely because of the issue you are having. Your original post did not mention that you were moving to Premium. I should have asked. 

  • in reply to Rick Savoy

    MRP is NOT designed by Scanco.  Production Management and IRP versions 2019 - 2021 were designed by Scanco.

Reply Children
No Data

*Community Hub is the new name for Sage City