​DATA / SEARCHES / REPORTS

---

DATA SCHEMA(s)

Which data schema tool to use? Sometimes I find myself lost looking up data in the wrong tool. Here is a quick cheat list for what to use when:

Schema Browser: Ideal for integrating Netsuite with external systems via SOAP (SuiteTalk)

Records Browser: Essential for scripting and automation within NetSuite (SuiteScript)

Connect Browser: Perfect for SQL-based analytics and reporting outside NetSuite (SuiteAnalytics Connect)

Records Catalog: General data schema including customizations

Bonus! - Use the Connect Browser for legacy NetSuite.com connectivity, use the Records Catalog for the newer NetSuite2.com data source.

---

OTHER REFERENCE NUMBER

I always have the hardest time finding the field 'Other Reference Number.' Often used to reference back to a customer or vendor document number.

In searches, this field is labeled: PO/Check Number and is listed at the top of the 'Ps' in the collating sequence.

---