This should be easy, but I'm having difficulty.

First off, I'm using Sage 100.  I am trying to get yesterdays orders in an automated report by adding a where clause such as below, however, its not working.  Any help would be appreciated!

INNER JOIN "AR_Customer"
ON "SO_SalesOrderHistoryHeader"."ARDivisionNo" = "AR_Customer"."ARDivisionNo" AND "SO_SalesOrderHistoryHeader"."CustomerNo" = "AR_Customer"."CustomerNo")
WHERE "SO_SalesOrderHistoryHeader"."OrderDate" = GETDATE()-1

Thanks in advance!!!

Views: 71

Reply to This

Replies to This Discussion

Ok, I figured it out.  SI needed Parentheses surrounding the GETDATE()-1 expression.

Good to hear Karl!


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service