MP_04SuppliesAndDemands

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
  • After much research, I found that I didn't need MP_04SuppliesAndDemands to be completely recreated. I only needed about 6 fields which turned out to not be that difficult. We use a macro enabled Excel spreadsheet that incorporates all the logic need to create a full MRP dataset for our buyers. It pulls the data directly from the SQL database via a set of stored procedures. And, it's much, MUCH faster than IRP! (Using a spreadsheet gives them the ability to manipulate the data according to their needs.)

Reply
  • After much research, I found that I didn't need MP_04SuppliesAndDemands to be completely recreated. I only needed about 6 fields which turned out to not be that difficult. We use a macro enabled Excel spreadsheet that incorporates all the logic need to create a full MRP dataset for our buyers. It pulls the data directly from the SQL database via a set of stored procedures. And, it's much, MUCH faster than IRP! (Using a spreadsheet gives them the ability to manipulate the data according to their needs.)

Children
No Data