I am trying to create a report in Power BI and can't seem to find a table that contains Sales Staff or Sales Group. Just wondering if anyone has input on this.
What I am trying to achieve is one master report for all transactions that happen in D365 F&O, whether that comes from POS, Call Center, or our online integrations.
Looking for input on the two fields and if there is an easy way to see all sales in one place with as much detail as possible, especially the salesperson.
Screenshot is from the canned report in D365 for store sales