In our business we have a need to frequently inform our customers with current price information, since our policy for pricing is customer based. We have agreements for fixed prices during half year periods with the possibility to make changes based on “Force majeure” at any time. This means we must show the differences when we do changes in our prices actual against for a date in the future. Since we use group pricelists, we also have a need to only display prices useful for a specific customer, ie those items they bought from us from that pricelist, say R12. We also need to analyse our price list information where we found Power BI to be the best tool.
Which is the correct way to go?Customizing a standard report in D365 or using “paginated reports” in Power BI.