Workflow · Stock and products · Opening soon

Supplier on-time delivery

Use exported NetSuite purchase orders and item receipts to measure supplier performance. See each supplier’s on-time delivery rate, with counts, using due dates and receipt dates.

Book a demo

Someone typed

“from the netsuite purchase orders and item receipts, show each supplier’s on-time delivery rate using due date vs receipt date, excluding orders not yet due; include the rate and counts.”

The agent read it as

From the NetSuite Purchase Orders and NetSuite Item Receipts, show each supplier’s on-time delivery rate using due date vs receipt date, excluding orders not yet due; include the rate and counts.

What the agent built

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

File

NetSuite Purchase Orders

CSV export · 24 rows

File

NetSuite Item Receipts

CSV export · 24 rows

Step

Make receipt order key

Step 1

Step

Make purchase order key

Step 2

Join

Bring in receipt dates

24 of 24 paired

Step

Calculate supplier delivery rates

Step 4

Result

Supplier On-Time Delivery

8 rows

Schedule

Runs when you say

Proposed

File
NetSuite Purchase Orders
CSV export · 24 rows
File
NetSuite Item Receipts
CSV export · 24 rows
Step
Make purchase order key
Step 2
Step
Make receipt order key
Step 1
Join
Bring in receipt dates
24 of 24 paired
Step
Calculate supplier delivery rates
Step 4
Result
Supplier On-Time Delivery
8 rows
Schedule
Runs when you say
Proposed

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

Download NetSuite Purchase Orders sample (24 rows)Transactions > Purchases > Enter Purchase Orders > List > Export
Download NetSuite Item Receipts sample (24 rows)Transactions > Purchases > Receive Orders > List > Export

What you get back

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

Supplier On-Time DeliverySample data8 rows

Supplier	On-time orders	Orders due	On-time delivery rate (%)
Briar Steel Supply	1	3	33.3
Cobalt Packaging	2	3	66.7
Harbor Electronics	2	2	100
Aster Components	2	3	66.7
Delta Precision Parts	1	3	33.3
Evergreen Logistics	2	2	100
Fjord Industrial	1	2	50
Granite Fasteners	2	2	100

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

How do you calculate each supplier's on-time delivery rate?

Export [purchase_orders|NetSuite Purchase Orders] and [item_receipts|NetSuite Item Receipts]. Match receipts to purchase orders, compare each due date with its receipt date, and exclude orders that are not yet due. Then group by supplier and show the on-time delivery rate with counts.

How it works

How to use the Supplier On-Time Delivery 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 On-Time Delivery: questions

Which export should you use?

Use the export that contains the rows you need for the workflow, usually one file for purchase orders and one file for item receipts. The files should include a stable key, the due date, the receipt date, and the supplier name or ID.

What happens to rows that do not match?

Rows that do not find a match are left out of the matched result for that step. You can review them separately, then decide whether to fix the source data or leave them out of the final rate.

How do you change the rules?

Edit the step in words. For this workflow, you would change the date rule, the matching key, or the way you group suppliers, then rerun the file through the steps.