/
/
Trace a product's sales and purchasing in Sage Intacct
For operations teams who want demand for one SKU by asking their AI assistant.
On this page
Connector
Connect Akeneo, pick your AI tool and paste the prompt.
The problem
Adding up sales and purchasing by hand
Planners hop between Akeneo and the Sage Intacct sales and purchasing screens to see how much of a product was sold and bought. Totals are added by hand and top customers are hard to see.
Without PopdockAI
- Look up the product in Akeneo
- Open sales lines in Intacct
- Open purchasing lines separately
- Total and rank customers by hand
With PopdockAI
- Product read from Akeneo
- Sales and purchasing lines totalled since your date
- Top five customers and vendors named
- No activity stated plainly, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Akeneo product {sku}, report its sales and purchasing activity in Sage Intacct since a start date {since} (default: the last 90 days), for the Intacct company {company}.
**Step 1: Read the product (akeneo)**
Call `akeneo-get-product` with identifier set to {sku}. Keep product-name, family, brand and enabled. If nothing matches, say so and stop.
**Step 2: Read sales lines (intacct)**
Call `intacct-get-order-entry-document-line` with item-id set to the product identifier and created-date.from set to {since} (and company when given). Keep document-id, customer-name, quantity, price, extended-price and created-date. Total the quantity and extended-price.
**Step 3: Read purchasing lines (intacct)**
Call `intacct-get-purchasing-transaction-line` with item-id set to the product identifier and created-date.from set to {since}. Keep document-id, vendor-name, quantity, price and created-date. Total the quantity and extended-price.
**Step 4: Report**
Product header, then sales totals with the top 5 customers by extended-price, then purchasing totals with the vendors used. Say plainly when there is no sales activity or no purchasing activity in the window.
**Rules & Guidelines:**
* Tools starting akeneo- are on the akeneo server (the product catalog, PIM). Tools starting intacct- are on the intacct server (Sage Intacct, the ERP). Both servers must be connected.
* The join key is the Akeneo product identifier (the SKU) and the Intacct item-id. Compare them exactly first, then trimmed and case-insensitive; report a record that only matches the loose way as a format mismatch, not a match.
* Intacct tools take an optional company; pass {company} when it is given and say which company the answer is for.
* The order entry lines include every document type, so state that the totals mix them unless a line field shows the type.
* This prompt is read-only. Do not call `akeneo-add-product`, `akeneo-update-product`, `akeneo-delete-product`, `akeneo-submit-proposal-product`, or any other akeneo-add-, akeneo-update- or akeneo-delete- tool, and do not call `intacct-create-vendor`, `intacct-update-vendor`, `intacct-create-customer`, `intacct-update-customer`, `intacct-create-order-entry-document`, `intacct-update-order-entry-document`, or any other intacct-create- or intacct-update- tool.
**Validation:**
* If the product has no ERP lines at all, report it as a product with no recorded demand, not an error.
* If the date is not valid, ask for a corrected one and stop.Who it's for
One answer, three teams that use it
Demand planners
See recent demand for a SKU
Sales totals and top customers show who is buying.
Who bought the most of SKU HB-2201 in Intacct this quarter?
Buyers
Check recent purchasing
Purchasing totals and vendors show what has been bought in.
How much of SKU KT-330 did we buy in Intacct since July, and from whom?
Operations managers
Compare buying with selling
Both totals side by side show whether supply keeps up.
Compare Intacct sales and purchases for SKU TS-2050 over 180 days.
How it works
What PopdockAI does when you ask
You give a SKU and a start date, and your AI assistant totals the product's sales and purchasing in Sage Intacct. It notes that order lines mix document types.
01
Ask
You give a SKU, a start date and, if needed, a company.
02
Read
It reads the product from Akeneo.
03
Total
It totals the sales and purchasing lines in Sage Intacct.
04
Report
It shows the totals, the top customers and the vendors used.
What PopdockAI provides
The tools behind the answer
Ready made tools for Akeneo and one secure connection to your AI tool. No code, no exports.
akeneo-get-product
sage-intacct-get-order-entry-document-line
sage-intacct-get-purchasing-transaction-line
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Sales and purchasing for a product in one answer
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
