Sage 300

Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …

Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

How do I write a SQL query to select only today's date in OEINVH.invdate. I see that the invdate is not in a date format but in a decimal format.