In dynamics 365 Business Central The /Customer/Item Sales/ report displays data based on the Bill-to customer no. instead of the Sell-to customer no. How can I produce a /Customer/Item Sales/ report for a Sell-to customer?
We have many Sell-to customers that are part of a buying group, to they each have the buying group customer number in their Bill-to customer on the Customer card. All posted invoices are against the Bill-to customer.
Our account managers, who visit the Sell-to customers, would like a report detailing what items the sell-to customer has purchased in a specified time range when talking to the Sell-to customer.