Hi everyone.
I need help with selecting tables and how to set up data for the reports I need.
I am getting data from the Business Central system.
1. Gross and net income - overview of individual customers by order amount + displaying the corresponding average discount.
This should include:
a) Issued financial approvals (replacements and product returns, testers, free products, and additional discounts on the order)
b) Additional graphical representation of revenue projection over time (by client)
2. Financial market overview (countries) by corresponding customers
Additional graphical representation of revenue projection over time (by client)
3. Sales overview by product name (by customer and by market)
Each report should include:
a) The ability to sort by customer size / sold products
b) The ability to change the time frame.
Thanks in advance.
I lost days for this without any results.