CODEWITHSUNDEEP
sqlnetsuitepartition-bysaved-searches
BillyZ87
BillyZ87

Reputation: 1

Running Total formula in Netsuite Saved Search is duplicating each row

I am using the SUM OVER PARTITION formula in Netsuite transaction saved search to get the running total of item quantity.

SUM /* comment */ {quantity} OVER(PARTITION BY {item} ORDER BY {trandate} ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

The formula works but it duplicates each row as shown below. Each transaction # of the item appears twice here

Any advise on how can I correct this?

Search formula and results

Search criteria

Upvotes: 0

Views: 946

Answers (1)

Krypton
Krypton

Reputation: 5231

You don't show your Criteria tab, but I suspect you have not filtered by COGS Line. Transactions affecting inventory movements typically include COGS Lines (unseen in the UI) which include the Item field, so they show up where you're filtering by Item.

Criteria Tab > Filter = COGS Line > Description = true

Upvotes: 0

Related Questions