Hi everyone! Is there any way to filter the transactionline table on record type (i.e. 'SalesOrd') without joining it to the transaction table, or any other table? I don't see any column in transactionline that would allow one to do such a thing
04/19/2022, 7:31 PM
I don’t believe you can. It’s easy enough to join to the transaction table though
04/26/2022, 10:09 AM
Yeah that's what we have been doing, but it's a bit trickier with the extraction tool that we are using (CData Sync). It works though, so I guess I shouldn't worry about it.