JoeSmith
JoeSmith

Reputation: 13

Duplicate Entries Saved Search NetSuities

When doing a search I am getting duplicate invoices. So invoices can have both drop shipment and ship from factory. So I want to create a report that only shows the invoice for drop shipment and all other invoices if not drop shipped. So if one part is dropped ship show only that invoice and not the other invoice with the same invoice number. End result, the dropship invoice, and all other not dropped shipped, invoice can not be duplicate keep in mind a invoice can be both dropshipped and shipped from factory thus leading to double entries for these results. How do I go about ride of this duplication what must I add?

Upvotes: 0

Views: 1505

Answers (1)

erictgrubaugh
erictgrubaugh

Reputation: 8847

On the Criteria tab, select the filter named "Mainline". Set it to Yes if you only want one result for the transaction, or set it to No if you want one result for each line item on the transaction. Read the comments in the duplicate question for a more detailed explanation of how mainline works. It works the same in the UI and in SuiteScript.

Upvotes: 3

Related Questions