Workflow · Stock and products · Opening soon

Supplier lead time analysis

See supplier lead times from NetSuite purchase orders and item receipts. Summarize average and worst lead time by supplier.

Book a demo

Someone typed

“calculate average and worst lead time by supplier from purchase order date to receipt date”

The agent read it as

Calculate average and worst lead time by supplier from NetSuite Purchase Orders purchase order date to NetSuite Item Receipts receipt date.

What the agent built

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

File

NetSuite Purchase Orders

CSV export · 16 rows

File

NetSuite Item Receipts

CSV export · 16 rows

Join

Bring in receipt dates

16 of 16 paired

Step

Summarize supplier lead times

Step 2

Result

Supplier Lead Times

8 rows

Schedule

Runs when you say

Proposed

File
NetSuite Purchase Orders
CSV export · 16 rows
File
NetSuite Item Receipts
CSV export · 16 rows
Join
Bring in receipt dates
16 of 16 paired
Step
Summarize supplier lead times
Step 2
Result
Supplier Lead Times
8 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 16 of 16 rows.

Download NetSuite Purchase Orders sample (16 rows)NetSuite: Transactions > Purchases > Purchase Orders > Export
Download NetSuite Item Receipts sample (16 rows)NetSuite: Transactions > Purchases > Item Receipts > Export

What you get back

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

Supplier Lead TimesSample data8 rows

Supplier	Average lead time (days)	Worst lead time (days)
Cedar Ridge Packaging	18	18
DuneLine Electronics	4.5	5
Foxglove Paper	5	6
Avery Metals	3.5	4
BriarWorks Plastics	4	4
Evergreen Fasteners	2.5	3
Northstar Components	13	21
Summit Textile Co	2.5	3

8 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate average and worst lead time by supplier?

Export purchase orders and item receipts from NetSuite, then match each receipt back to its purchase order. Mammoth calculates lead time from purchase order date to receipt date, then groups the results by supplier. You get average and worst lead time by supplier.

How it works

How to use the Supplier Lead Times workflow

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.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Supplier Lead Times: questions

What export should I use?

Use a purchase order export from NetSuite and an item receipt export from NetSuite. The workflow needs the order date on the purchase orders and the receipt date on the item receipts.

What happens to rows that do not match?

Rows that do not match stay out of the summary for that step. You can review them separately and decide whether they need a different key, a rule change, or a data fix.

How do I change the rules?

You change the rules in plain words, such as which columns to match, which dates to compare, and how to group the results. You can also change the wording of the condition if you want a different supplier breakdown.