Follow a WooCommerce order from cart to cash in Dynamics GP

**Objective:** Trace WooCommerce order {order-number} through Dynamics GP and report where it stands in each system: sales documents, lines, invoice balance and payments.

**Step 1: Read the store order (woocommerce)**

Call `woocommerce-get-order` with order-number set to {order-number}. If nothing comes back, say the order does not exist in the store and stop. Then call `woocommerce-get-order-line` and `woocommerce-get-refund`, both with order-number set to {order-number}.

**Step 2: Find the GP sales documents (dynamics-gp)**

Call `dynamics-gp-get-rm-sales-trx` with customer-po-number set to {order-number}. If nothing comes back, try once more with the store order-id. If there is still nothing, report the order as present in WooCommerce and absent from GP, show the store side from step 1, and stop.

**Step 3: Compare the lines (dynamics-gp)**

For each GP document call `dynamics-gp-get-rm-sales-line-item` with sop-number and sop-type. Match store lines to GP lines by line-sku and item-number, then compare quantity and unit price.

**Step 4: Follow the invoice into receivables (dynamics-gp)**

For each GP document that is an invoice, call `dynamics-gp-get-rm-trx` with customer-id and document-number set to the sop-number. current-transaction-amount is the amount still owed. Then call `dynamics-gp-get-rm-trx-apply` with applied-to-document-number set to the sop-number to list the payments and credits applied to it.

**Step 5: Report**

1. Store: order number, date, status, customer, total, refunds.
2. GP: each sales document with SOP number, type, date, posting status and amount.
3. Line differences: missing on either side, or a different quantity or price.
4. Receivables: invoice amount, amount still owed, due date, and each payment applied with its date and amount.
5. One sentence on where the order stands, such as invoiced and paid, invoiced and unpaid, or ordered but not invoiced.

**Rules & Guidelines:**

* Tools whose names start with woocommerce- are on the woocommerce MCP server; tools whose names start with dynamics-gp- are on the dynamics-gp MCP server. If a tool from either server is not available, stop and say which server is not connected.
* If the user names a Dynamics GP company, pass it as company on every dynamics-gp call.
* Match a store SKU to a GP item number exactly, after trimming spaces. If that fails, try the SKU in upper case once. Never match on descriptions or partial codes.
* This prompt is read-only. Do not call `woocommerce-update-order`, `woocommerce-add-order-note`, `woocommerce-add-refund`, `dynamics-gp-rm-sales-trx-update`, `dynamics-gp-rm-sales-trx-note` or `dynamics-gp-rm-trx-add`.

**Validation:**

* If GP has an invoice but receivables returns nothing for it, report the invoice as not yet posted to receivables.
* If the store shows refunds and GP shows no return or credit applied, say so.
* If GP returns more than one document of the same type for this PO number, list them all and flag it as a possible duplicate.