I may have posted this in the wrong channel earlier but... How do we get gl data from a soap transaction search? Trying to get the accounts on an item on a sales order via a soap transaction search without using a saved search

I've never used SOAP before, especially NS soap. Do you happen to know of an article that would show me how to use an advanced search to lookup a transaction by an internalId?

its the soap equivalent of a saved search

Does it have the ability to bring back all columns? That's the annoying requirement they are wanting. Every column associated with the transaction needs to come back. So basically a select * from Transaction

not without specifying all the columns

So the issue we are running into is we are pulling back the CashSale, but it does not lists the account associated with the line (basically the GL impact)

live with specifying all the columns

Hahaha. That's what I said. The other solution is to create a custom column that houses that info (which I don't like)