Workflow · Stock and products · Opening soon

Purchase order tracking

Use a NetSuite purchase orders export to track open orders by supplier. See what is ordered, what has been received, what is still outstanding, and which orders are late.

Book a demo

Someone typed

“track open purchase orders by supplier with what is ordered, received and still outstanding, and which are late”

The agent read it as

Track open purchase orders by supplier with what is ordered, received and still outstanding, and which are late in NetSuite Purchase Orders export.

What the agent built

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

File

NetSuite Purchase Orders export

CSV export · 16 rows

Step

Show open orders and late status

Step 1

Result

Open Purchase Orders

14 rows · 14 flagged

Schedule

Runs when you say

Proposed

File
NetSuite Purchase Orders export
CSV export · 16 rows
Step
Show open orders and late status
Step 1
Result
Open Purchase Orders
14 rows · 14 flagged
Schedule
Runs when you say
Proposed

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

Download NetSuite Purchase Orders export sample (16 rows)NetSuite: Transactions > Purchases > Enter Purchase Orders > Saved Search export

What you get back

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

Open Purchase OrdersSample data14 rows

5 late9 not late

Supplier	Purchase order	Item	Quantity ordered	Quantity received	Quantity outstanding	Status	Expected receipt date
Asterfield Packaging	PO10496	Mailer boxes 12x9x4	900	0	900	Not late	2026-11-16
Boreal Components	PO10497	USB-C cable 1m	1,100	0	1,100	Not late	2026-11-12
Evergreen Textiles	PO10486	Cotton tote bag natural	1,000	0	1,000	Not late	2026-11-18
Fjord Labs	PO10487	Bluetooth scanner cradle	48	0	48	Not late	2026-11-25
Juniper Printworks	PO10491	Coated insert cards A6	1,500	0	1,500	Not late	2026-11-14
Kestrel Beauty	PO10492	Amber glass dropper bottles	600	150	450	Not late	2026-11-20
Larkspur Plastics	PO10493	Poly mailer 10x13	3,000	0	3,000	Not late	2026-11-29
Morrow Stationery	PO10494	Ballpoint pen blue	800	0	800	Not late	2026-11-19
Northstar Hardware	PO10495	Hex bolt M8x30	1,400	0	1,400	Not late	2026-11-17
Asterfield Packaging	PO10482	Kraft shipping cartons 14x10x8	1,200	900	300	Late	2026-10-28
Cinderline Office Supply	PO10484	Laser printer toner black	160	40	120	Late	2026-10-22
Dovetail Coffee Roasters	PO10485	House blend 12oz bags	240	120	120	Late	2026-11-03

14 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you track open purchase orders by supplier?

Export your NetSuite purchase orders file, then upload it to Mammoth. It shows open orders by supplier, with ordered, received, outstanding, and late status. The sample output shows 5 late and 9 not late.

How it works

How to use the Open Purchase Orders 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.

Open Purchase Orders: questions

What export should you use for purchase order tracking?

Use a NetSuite Purchase Orders export. It should include the order lines or rows you want to track, plus the fields for supplier, ordered quantity, received quantity, and any due date or status fields available in the export.

What happens to rows that do not match the rules?

Rows that do not match stay out of the final view for that step. You can keep them separate, inspect them, or change the rules so more rows are included.

How do you change the late and open order rules?

Edit the rule in words, for example, what counts as open, what counts as late, and how to compare ordered and received amounts. Then run the workflow again on a fresh export if needed.