Hello,

I have set up an electronic whiteboard for work and every hour of the day, the excel whiteboard queries the QB database for any orders that have been entered and modified today.  I am using the sp_report approach over the Select statement because it seems to be much faster.  I also can't use MS Query because that is not available in a shared file.  With all that said, the only orders that are returned are the orders that were entered today.  It does not return the orders that were modified today.

My statement is:

sp_report SalesByCustomerDetail show TxnType, Memo, DueDate, Item, Quantity , PONumber, Amount, Account, RefNumber, SourceName, Date, Class parameters ModifiedDateMacro='Today', ReportDetailLevelFilter='AllExceptSummary', ReportPostingStatusFilter='Either' WHERE rowtype='DataRow'

Can you please tell me how to get the orders modified today, as well as the ones that were first entered today?  I have also used DateFrom and DateTo with no success.  I am using QB Enterprise Solutions 7 with QODBC 7.00.00.207.  Thanks for your help!

Robin

If you're talking about Sales Orders, try:

Select Memo, DueDate, SalesOrderLineItemRefFullName, SalesOrderLineDesc, SalesOrderLineQuantity,
PONumber, SalesOrderLineAmount, RefNumber, CustomerRefFullName, TxnDate, SalesOrderLineClassRefFullName
from SalesOrderLine where TimeModified >= {fn TIMESTAMPADD(SQL_TSI_YEAR, 0, {fn CURDATE()})}