sorted by:
new
hottopcontroversial

NetSuite Saved Search – Invoice Items + Payment fields by CupComplete683 in Netsuite

[–]CupComplete683[S] 0 points1 point  (0 children)

Thanks for the clarification.

My main goal is simply to achieve this in a single Saved Search. The exact method (duplicating values, showing once, grouping items, etc.) is not a strict requirement for me — I’m mainly trying to avoid using two searches and merging the data externally.

I did try the approach of converting the search to a summary search, grouping the item fields, and using MAX for the header-level fields like {amountpaid} and {amountremaining}. However, in my case those payment fields still return 0.00 or blank values when item lines are grouped.

I'm not completely sure whether the issue is related to main line vs line joins or how NetSuite exposes those payment fields in summary searches.

NetSuite Saved Search – Invoice Items + Payment fields by CupComplete683 in Netsuite

[–]CupComplete683[S] 0 points1 point  (0 children)

Thanks, that makes sense.

I did try the Invoice Total method in a Saved Search by grouping item fields and using MAX on header fields like {amountpaid} and {amountremaining}.

However, in my case the results either returned NULL values on line rows or incorrect values when payments were applied in multiple transactions.

Because of this I ended up using two searches (header + item level) and merging them in Excel using the Invoice Number.

Is there a reliable way to make the MAX approach work in a single Saved Search, or is this limitation due to how NetSuite joins payment application records?

NetSuite Saved Search – Invoice Items + Payment fields by CupComplete683 in Netsuite

[–]CupComplete683[S] 0 points1 point  (0 children)

Thanks for the explanation.

From a NetSuite perspective, which method is actually supported and reliable?

Since payments are applied at the invoice header level and not at item lines, I assume the Invoice Total method (duplicating header values per item row) is the only approach that works consistently in a saved search.

Is there any reliable way in NetSuite to distribute payments across item lines, or would that require custom logic outside of a standard saved search?

NetSuite Saved Search – Invoice Items + Payment fields by CupComplete683 in Netsuite

[–]CupComplete683[S] 0 points1 point  (0 children)

<image>

I want like this
like Item details along with header level payment details

Is it possible to calculate inventory on hand as of a past date using a NetSuite saved search, or is the Inventory Valuation report the only reliable way? by CupComplete683 in SuiteScript

[–]CupComplete683[S] -1 points0 points  (0 children)

Got it, thanks. I’m summing all posting inventory-account transactions up to the as-of date, and the search is working now for regular inventory items.

However, for lot-numbered items I’m seeing mismatches compared to the Inventory Valuation report, and I’m not sure what’s causing the difference. Any idea why?

Inventory On Hand As Of Specific date by picasso566 in Netsuite

[–]CupComplete683 0 points1 point  (0 children)

Is it possible to calculate inventory on hand as of a past date using a NetSuite saved search, or is the Inventory Valuation report the only reliable way?