Dynamics Community Forum Thread Details

MRP/WSSI Required in D365 F&O

My first post here, so please forgive if it's in the wrong forum, but I can't see one for D365 F&O.

My client has signed up to implement D365 F&O, but now that they have been shown the system, one of the things that is missing is a comprehensive Weekly Sales & Stock Intake report (WSSI).

The fields the client requires for each SKU are:

Original Business Plan

Forecast/Actual Demand

Original Business Plan Cumulate

Forecast/Act Demand Cumulate

Forecast Customer Returns

Projected Stock Holding (inc Suggested PO's and Actual PO's)

Stock Inc/Dec Units in the last week

Forward Cover Weeks based on Forecast/Actual Demand

Spot Cover Weeks (to be confirmed)?

Purchase Orders that have been confirmed, raised and scheduled

Forecast Sales Back Orders

Safety Stock Wks

Supplier Lead Time Wks

Planned Buy Units (manual override of suggested PO's)

Suggested PO's

D365 as standard only has screens for a few of these and have a screen for each field rather than brining the information together. I've been told that to create a report in Power BI will take hundreds of days for this, so is anyone aware of what apps are out there that would provide this as standard functionality?

TIA

Quick Links