Field notes for curious builders

Useful ideas,
worked through.

Clear notes on code, tools, systems and the small discoveries that make technical work better.

Recently published

Latest notes

27 July 20262 minute read

Understand Customer, CustomerAddressBook and CustomerAddressBookEntityAddress and join them correctly in SuiteQL.

27 July 20262 minute read

Diagnose duplicate customer rows in SuiteQL address queries and choose the correct result grain instead of relying on DISTINCT.

27 July 20262 minute read

Return a customer default billing address, default shipping address or both with SuiteQL while retaining customers without an address.

27 July 20263 minute read

Diagnose SuiteQL dates that appear one day early or late by separating date-only values, timestamps and JavaScript time-zone conversion.

27 July 20262 minute read

Query NetSuite accounting periods with SuiteQL and avoid confusing transaction dates, posting periods and fiscal calendars.

Explore by subject