Notice of Maintenance on October 9th. Click here for further details.

Export Invoices From Prior Day and Where Sales Order Begins With J

SOLVED

I need to export invoices that are from yesterday's date and the related Sales Order begins with a J.

I am a novice at using Sage Intelligence, but I have some SQL experience. I understand that it's not actually SQL.

I'm able to get the below SQL to work with a hard coded date.

SELECT AR_InvoiceHistoryHeader.CustomerPONo WHERE AR_InvoiceHistoryHeader.CustomerNo='INSERT CUSTOMER NAME HERE' AND AR_InvoiceHistoryHeader.InvoiceDate={d'2023-01-18'}