
Hi
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