Oracle NetSuite × Multi-Currency COGS

NetSuite Multi-Currency COGS for Cross-Border Shopify Plus Stores

NetSuite multi-currency COGS flowing into Shopify Plus checkout in real time. FX-aware margin enforcement for Shopify stores running global commerce.

The Problem

Cross-border Shopify Plus stores face a structural margin problem: the merchant prices in USD, the supplier invoices in CNY (or EUR or VND), and the FX rate moves 4–8% between PO commitment and invoice settlement. NetSuite tracks this correctly in functional and transaction currencies, but the data does not flow to Shopify checkout, so margin policy at checkout uses a stale COGS in functional currency, and orders ship at margins that no longer reflect the FX-adjusted reality. Multi-currency NetSuite COGS lives in NetSuite; Shopify checkout flies blind.

How Agentis Solves This

Agentis NetSuite multi-currency COGS pulls cost data in both functional and transaction currencies, applies the current FX rate from the NetSuite exchange rate table at checkout, and computes margin in the merchant's reporting currency. When FX rates shift, the next checkout reflects the new economics automatically. The policy engine supports FX-aware floors that adjust dynamically, so a 5% CNY-USD move triggers proportional margin floor adjustment without manual reconfiguration.

Benefits

Technical Details

Agentis ingests NetSuite item costs in both functional and transaction currencies via SuiteScript RESTlets. The NetSuite exchange rate table is polled hourly (configurable) for current rates against the merchant's reporting currency. At Shopify Plus checkout, Agentis applies the current rate to the transaction-currency COGS to compute reporting-currency margin, then evaluates against the merchant's policy floor. The audit log records both raw COGS (transaction currency) and converted COGS (reporting currency) plus the FX rate version applied, supporting accurate retrospective margin analysis.

Frequently Asked Questions

Which NetSuite exchange rates does Agentis use?

By default, the NetSuite spot rate from the exchange rate table at the moment of checkout. For merchants using forward rates or custom rate types (consolidation rate, balance sheet rate), Agentis can be configured to use any rate type from the NetSuite exchange rate table. The configuration is per-currency-pair so different cost flows can use different rate logic.

Does this work for stores selling in multiple presentment currencies?

Yes. Shopify Plus presentment currencies (the customer-facing currency at checkout) are independent of the merchant's reporting currency. Agentis evaluates margin in reporting currency regardless of presentment, so a Shopify Plus store selling in USD, EUR, and GBP gets unified margin policy enforcement against a single reporting-currency floor.

How do FX rate changes propagate?

Polling runs hourly by default with configurable intervals down to every 15 minutes. For high-volatility currency pairs, faster polling is supported. The rate change reflects in the next checkout evaluation, not in already-confirmed orders, which retain the rate that applied at confirmation in the audit log. This pattern keeps the margin reporting consistent and event-sourced.

Related Oracle NetSuite Features

← Back to Oracle NetSuite overview

Free Audit, No Commitment

Protect Every Order's Profit Margin

See exactly how much margin Agentis can recover for your store in 7 days, no commitment required.