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


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'}

Parents Reply
  • 0 in reply to dDub

    Glad you got it working! 

    When it comes to exporting data out of Sage 100, VI is not anywhere near the top of my list of ways to get that done.  Excel (including SI), custom report, external reporting tool (like Visual Cut / SA&WF...), BOI script, VBScript (ODBC)... there are much easier ways.

No Data