Hello would like to know if it's possible to get a list of all open invoices using SDKDatabaseUtility RunSelectQuery command?
I've looked around here and also the DataDict but can't really find what tables I need to link to get this data. Any help or guide to where I can look for more info would be apreciated. I believe I can also get this info using the OpenSalesJournal GetLookupList but not sure if that's the best way since I only need to get the open ones.
Thanks,