Hi,
I want to get the list of all invoice from sage50 with the .NET SDK 2017.1
I have tried to use
SalesJournal salJourn = SDKInstanceManager.Instance.OpenSalesJournal();
List<LookupLine> lines = salJourn.GetLookupList(string.Empty, DateTime.MinValue, DateTime.UtcNow, string.Empty, 0, 0, false);
lines.ForEach(j => {
salJourn.LoadInvoiceForLookup(string.Empty, j.JournalNumber, false);
// .....
});
but i have lot of Cannot find the transaction with the criteria you entered. Please try using different criteria.
OR
Do a SQl statement and call IDataReader reader = util.ExecuteReader(sql);
with all the join in the SQL
with one is the best?