Transaction Location Rollup
Rolls multi-location transaction lines up to the main line, so the whole transaction can be interrogated by location without manual work.
WHO IT'S FOR
Finance and operations teams on multi-location NetSuite accounts who need location-level visibility on purchase orders for reporting and filtering.
WHAT IT DOES
Keeps a transaction header field automatically in sync with the distinct, active locations used across a multi-location transaction's item and expense lines, since NetSuite only tracks location at line level natively. This makes location usable as a header filter and column in transaction searches and reports on multi-location accounts. Handles edge cases like inactive locations and import-created records, with a one-off historical backfill and a daily reconciliation job.
DEPENDENCIES
SuiteScript bundle — User Event + Map/Reduce + 3 transaction body fields
- NetSuite features: Accounting, Locations, Server-Side Scripting
- Field-level edit access to the aggregation field for every role that saves a PO
- A Purchase Order saved search (one row per open PO) for the backfill — built fresh per account
WHAT IT COSTS
From £75/mo
Priced by tool complexity, with a one-time buyout option for accounts that prefer it. Talk to us for a quote specific to this tool.
START A CONVERSATION