Skip to main content
Six SuiteQL views of procurement and payables on one page, installed into your team and bound to your NetSuite connection.
A single-page procurement and payables dashboard over live NetSuite SuiteQL: spend trend by month, top vendors, AP aging, recent purchase orders, spend by subsidiary and department, and bills raised without a PO reference. Business area: Accounts Payable · Type: App Built for: AP manager, Procurement lead, Controller Works with: NetSuite

​
Data and resources

  • NetSuite — spend trend (SuiteQL query): Vendor bills and purchase orders by month, read live from NetSuite.
  • NetSuite — top vendors (SuiteQL query): Bill spend by vendor over the selected window.
  • NetSuite — AP aging (SuiteQL query): Open payables bucketed current / 1-30 / 31-60 / 60+ with the amount due in the next 30 days.
  • NetSuite — purchase orders (SuiteQL query): The 300 most recent purchase orders of every status, searchable by vendor.
  • NetSuite — spend by dimension (SuiteQL query): Twelve-month bill spend by subsidiary (header grain) and department (line grain).
  • NetSuite — bills without a PO reference (SuiteQL query): Share of twelve-month bill spend that carries no purchase-order reference number.

​
Install and use

Open Library → Apps in Erstan and select Procurement & AP Dashboard. Review its requirements, choose a destination and the requested resources, then complete the installation review. See Adding Apps. Open the installed App from Artifacts. Review its data and setup status before sharing it. Later edits remain a draft until you publish them. See Create and edit an App.

​
Access and actions

The App uses the viewer’s access to its connected systems and resources. App sharing does not share credentials or grant access to a Sheet, Database, or Data Source. Actions follow the configured permissions and approval policy. See Connect App data.