Connectors

/

Akeneo

/

Trace Akeneo product demand in Intacct
Report
Cross-Connector

Trace a product's sales and purchasing in Sage Intacct

For operations teams who want demand for one SKU by asking their AI assistant.

Try PopdockAI free
Get a live demo
Trace Akeneo product demand in Intacct
How much of SKU TS-1042 have we sold and bought in Intacct over the last 90 days?
TS-1042 Linen Shirt, enabled, family apparel. Period: last 90 days, company Northwind. - Sales: 420 units, 16,380.00 across 38 documents - Top customers: Contoso Retail 6,240.00, Fabrikam Stores 3,900.00 - Purchasing: 500 units from Fabrikam Textiles Sales lines mix document types. Want the top five customers?
Akeneo
Sample figures. Your results come from your own account.
akeneo-get-product
sage-intacct-get-order-entry-document-line
sage-intacct-get-purchasing-transaction-line

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Akeneo

Akeneo
Run it on your own Akeneo data.

Connect Akeneo, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads the product from Akeneo.

akeneo-get-product

03

Total

It totals the sales and purchasing lines in Sage Intacct.

sage-intacct-get-order-entry-document-line
sage-intacct-get-purchasing-transaction-line

04

Report

It shows the totals, the top customers and the vendors used.

Your AI tool

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.

get-data

akeneo-get-product

Returns products from Akeneo PIM with their family, categories, enabled status, completeness and update dates. Filter by family, category, enabled status or update date.
get-data

sage-intacct-get-order-entry-document-line

Returns order entry document lines from Sage Intacct. Filter by document ID (from Get order entry documents) to get one document's lines.
get-data

sage-intacct-get-purchasing-transaction-line

Returns purchasing transaction lines from Sage Intacct. Filter by document ID (from Get purchasing transactions) to get one document's lines.
Read only.Nothing in Akeneo Changes

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.

How Popdock AI secures your data

The outcome

Sales and purchasing for a product in one answer

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation