Skip to content
NewAI dashboards.See how →
Open MammothTry free
Workflow · Stock and products · Opening soon

Backorder report

Turn a NetSuite sales order export into a backorder report. See each item and customer, with quantity backordered and days waiting.

Early access opens shortly. Check back soon.

Book a demo
Someone typed

“list sales orders on backorder by item and customer with quantity backordered and days waiting”

The agent read it as

List NetSuite Sales Orders on backorder by item and customer with quantity backordered and days waiting.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    NetSuite Sales Orders
    CSV export · 14 rows
  2. Step
    List backordered sales orders
    Step 1
  3. Result
    Sales Backorder List
    14 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 14 rows came out.

What you get back

The result of that run, the rows to look at first.

Sales Backorder ListSample data14 rows
ItemItem nameCustomerSales orderQuantity backorderedDays waitingOrder date
SKU-ALPHA-01Aurora Desk LampAster Lane SupplySO104882322026-11-09
SKU-ALPHA-01Aurora Desk LampCrescent RetailSO1049262102026-11-01
SKU-ALPHA-01Aurora Desk LampNorthstar OutfittersSO1049811322026-10-10
SKU-BETA-14Boreal Storage BinBayside Home GoodsSO104903542026-11-07
SKU-BETA-14Boreal Storage BinCrescent RetailSO10499410392026-10-03
SKU-BETA-14Boreal Storage BinLumen MarketSO1049446182026-10-24
SKU-DELTA-03Drift Cord OrganizerBayside Home GoodsSO1050443112026-10-31
SKU-DELTA-03Drift Cord OrganizerHarbor FieldworksSO1049384142026-10-28
SKU-EPSILON-22Ember Reusable BottleAster Lane SupplySO1049577222026-10-20
SKU-GAMMA-08Cinder Travel MugNorthstar OutfittersSO104915872026-11-04
SKU-GAMMA-08Cinder Travel MugSolstice StudioSO1050184502026-09-22
SKU-GAMMA-08Cinder Travel MugWillow & Pine CoSO1049699272026-10-15
14 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you list sales orders on backorder by item and customer?

Export your NetSuite sales orders, then upload the file. The workflow lists sales orders on backorder by item and customer, with quantity backordered and days waiting. You get a backorder report from the rows that match the rules.

How it works

How to use the Sales Backorder List workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Sales Backorder List: questions

What export should you use?
Use a sales order export from NetSuite. Include the order, item, customer, quantity backordered, and any date fields needed to work out days waiting.
What happens to rows that do not match?
Rows that do not meet the backorder rules are left out of the report. Only sales orders on backorder are listed.
How do you change the rules?
Change the steps in plain words, for example, which rows count as backordered, which fields to group by, and which columns to show in the report.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Book a demo

Workflows like this

Find the few products that make most of your sales, what sells together, and the stock that sits too long.

All stock and product templates →

Keep reading

Read nextAll workflowsDescribe yours, or start from one the agent already built.Take a lookProductData EngineConnected sources, cleaning and scheduled refresh.Take a lookConnectorsConnectorsBring the data in from the tools you already use.Take a look