Check the NetSuite Manufacturing Workbook's Production Cost Pivot Against Its Transactions

The screenshots show sample data. Company, person, item and location names are fictional. Use your own records and values when following the steps.

Before you start

You need SuiteAnalytics Workbook access and a role that can open the Manufacturing Workbook and see the transactions it reads. This example uses a company that builds assemblies with work orders and Work in Process. The Manufacturing Workbook is a standard template built on the Manufacturing Dataset. In its delivered configuration the dataset is restricted to Assembly Build and Work Order Close transactions and uses a rolling default date filter that starts about two years before the current date, so other transaction types and older transactions may not appear. Confirm the exact row grain and criteria in your dataset rather than inferring them from a sheet. The sheets, fields, sort order and criteria can differ with your features, permissions, release and template version, so check the dataset's field list and criteria in your account.

A workbook is an analytical view, not an accounting report. It's good for checking where a production figure comes from, but it doesn't replace GL reports or a transaction's GL Impact. Before you rely on a quarter total for a close, compare the accounting book, subsidiary, currency and period basis.

01. Open the Manufacturing Workbook

Click Analytics in the navigation bar. The Workbooks tab lists each workbook as a card. Open Manufacturing Workbook, which carries the Template label. It opens on the sheet of the same name, a table of the Manufacturing Dataset with one row for each Assembly Build or Work Order Close that meets the dataset's criteria, newest first. The footer reads Total rows: 16 in this example, and Save As sits at the top right because this is an unmodified template.

Enlarge

02. Add up the October rows

The rows are sorted newest first. In this example the first six have a Posting Period of Oct 2026 and dates from 10/09/2026 to 10/14/2026. Read the Amount (Transaction Currency) column: $0.00, $186.40, $92.00, $248.80, $0.00 and $171.60. They add up to $698.80.

Two of the six are Work Order Close rows for Maple Drawer Box with a $0.00 amount, a quantity of 0 and a blank Cost/Unit. A Work Order Close row can appear with a zero amount. That doesn't mean it was excluded, and it doesn't prove there was no variance. The Amount is a transaction amount in the transaction currency, not a unit cost. The Cost/Unit column is calculated from Amount and Quantity, and only when the quantity is above zero, so it isn't automatically the item's standard or average cost.

Enlarge

03. Open the production cost pivot

Click the sheet tab Pivot - Production Cost per period by Assembly. The layout panel shows how it is built: Assembly as the row, Date (Year) and Date (Quarter) as the columns, and Amount (Transaction Currency) as the measure that gets summed. Under 2026 the grid has a Q3 column, a Q4 column and a 2026 total, followed by a Grand Total column.

The quarters are a calendar grouping of each transaction's Date, not a fiscal quarter. The table also shows Posting Period. They agree when a transaction posts in its own month, as in this example, and they can differ. Check the filters on each sheet as well, because every sheet can have its own layout and filters even though they share a dataset.

04. Compare the Q4 column with the rows

Under 2026, the Q4 column shows Oak Shaker Door $435.20, Birch Face Frame $92.00 and Maple Drawer Box $171.60. The Grand Total row reads $698.80, the same as the six table rows. There are no November or December rows yet, so October is all of Q4.

You can also rebuild a single cell. Oak Shaker Door's $435.20 is two table rows: Work Order Close #WCL213 at $186.40 plus Assembly Build #ASB5111 at $248.80. The pivot has no transaction type dimension, so one cell can combine different transaction types.

Enlarge

Check the result

1. The six October table rows add up to $698.80: $0.00 + $186.40 + $92.00 + $248.80 + $0.00 + $171.60.
2. The pivot's Q4 Grand Total is also $698.80, and the three assembly cells ($435.20, $92.00 and $171.60) add up to the same figure.
3. If the figures differ, check the sheet filters, the Date compared with the Posting Period, the currency and whether any rows are duplicated by a join before you rely on either number.

Common questions

How do I check a pivot figure in the Manufacturing Workbook?

Apply the same dataset criteria, sheet filters, subsidiary and location scope and currency to the table sheet, and add up the Amount (Transaction Currency) of the rows that fall in the pivot cell: the assembly in the row and the year and quarter of the column, matched on Date. In the example, the three Q4 cells of $435.20, $92.00 and $171.60 are the six October rows grouped by assembly. This is a diagnostic. Duplicate rows from joins, sheet filters, mixed currencies or a different measure can make a cell differ.

Why do some Work Order Close rows show $0.00?

The table lists a row for each transaction the dataset includes, and a Work Order Close row can carry a zero Amount. In the example, Work Order Closes WCL214 and WCL212 are both $0.00, with quantity 0 and a blank Cost/Unit. A zero amount doesn't mean the row is excluded, and it doesn't show that the work order had no variance. Use the work order's own cost and variance reports for that question.

Is Amount a unit cost?

No. Amount (Transaction Currency) is a transaction-level amount. Cost/Unit is calculated from Amount and Quantity. Neither is automatically the same as inventory valuation, standard cost, average cost or a GL balance.

Why might a pivot quarter not match the posting period?

The pivot buckets rows by each transaction's Date, while the table also shows Posting Period. They agree when a transaction posts in its own month. A fiscal quarter may also not be a calendar quarter. Compare both before you rely on a quarter total for a financial close.

Can I edit the standard template?

A template can be viewed as it is. Save As makes your own copy, which keeps the template's dataset relationship, visualizations and filters, so review them. The copy can then be changed independently, and access and options depend on your role. When a workbook uses Real-Time Response, NetSuite evaluates it against current account data when a sheet runs or refreshes, subject to processing time, permissions, filters and whether related costing is finished.

Does the Manufacturing Workbook match the general ledger?

Not by design. A workbook is an analytical view. To reconcile to the general ledger, use GL reports or transaction GL Impact with the same accounting book, subsidiary context, currency and date or period basis.