I'm looking for help dealing with similarly named ...
# suiteanalytics
b
I'm looking for help dealing with similarly named columns in the analytics workbook. I have a transaction workbook where I am reporting on Purchase Orders. The column I'm looking for is
shipDate
from the PO. I've included a screenshot of the field from the Netsuite Schema browser. However, when I try to use the
shipdate
field in the Transaction table of the workbook, the date does not match what is populated on my actual PO's. I searched for other possible shipdate fields in the workbook, but nothing looks correct. Where have I gone wrong? At this point I feel like I'm probably better just setting up an ODBC connection and querying directly... however I only work for this client occasionally and don't want to leave them with something that brittle. Thanks in advance!!!