Transaction search.
Criteria:
[LIST]
[*]Type = Sales Order[/LIST]
Results:
[LIST]
[*]Customer : Name
[*]Customer : Phone
[*]Item : Name
[*]ShipVia
[*]ShipDate
[*]TrackingNumbers[/LIST]
I'm running this search from SuiteScript with an additional filter to narrow it down to one specific customer who happens to have only one sales order.
I get back 3 rows of data, each has different fields that are null for each row.
If I enable MainLine I don't get any of the item fields, they are all null.
I do however only get one single result (good).
I'm pretty sure this has to do with my lack of understanding on how and when main line is supposed to be used.
I've tried different group by settings to try and roll all the results into one.
I'm just guessing at this point.
If anyone can suggestion something to try I would really appreciate it.
Thanks,
Steve