Rank an Akeneo product family by what actually sold

**Objective:** Rank the products in the Akeneo family {family} by sales order line revenue in Dynamics GP since {from-date}, for the company {company}. Default the start date to 90 days ago.

**Step 1: List the family's products (akeneo)**

Call `akeneo-get-product` with family set to {family} and max-records 40. Keep identifier, product-name and brand. If nothing comes back, say so and stop.

**Step 2: Read the sales lines (dynamics-gp)**

For each identifier, call `dynamics-gp-get-rm-sales-line-item` with item-number set to it, document-date.from set to {from-date}, and company when given. Add up quantity and extended-price, and count distinct sop-number values and distinct customer-id values.

**Step 3: Report**

A table ranked by extended price: SKU, product name, brand, units, revenue, documents, customers. Name the products with no sales in the period as a separate list, and give the period used.

**Rules & Guidelines:**

* Tools starting keneo- are on the akeneo server (the product catalog, PIM). Tools starting dynamics-gp- are on the dynamics-gp server (the ERP). Both servers must be connected.
* The join key is the Akeneo product identifier (the SKU) and the Dynamics GP item number. Compare them exactly first, then trimmed and case-insensitive; report any record that only matches that loose way as a format mismatch rather than a match.
* Dynamics GP tools take an optional company; pass {company} when it is given, and say which company the answer is for.
* This prompt is read-only. Do not call any write tool on either server.

**Validation:**

* Sales lines include several document types (sop-type); say that the totals mix them unless you filtered, and do not net out returns unless the type shows them.
* Do not add amounts that are in different currencies; if any are unclear, say so.