How to Query NetSuite Data with AI When Multi-Book Silently Doubles Every Dollar
NetSuite's standard reports filter the transaction accounting line to one accounting book automatically. The warehouse copy of the same tables does not, so a naive SUM adds every dollar once per book.