This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Does someone have a saved search example or report that shows total inventory in transit on a given day

my suggestions here _might_ help:
<https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1692656330080169?thread_ts=1692360225.778899&amp;cid=C298P0BCK>

Do a transaction search. Criteria:

Posting = yes
Account = your account for inventory in transit

Result set:

Sum(Amount)

Filter:

Date

—

Run the report and set the ”date to” to the date you want. Leave date from blank. 



Elaborate with group(item) and sum(quantity) in the result set if you want to show details 