Skip to end of metadata
Go to start of metadata

Back to D-SL Sales AR Module SQL Posted to Wiki Listing - E-PU Purchasing AP Module SQL Posted to Wiki  )

TYPE: Frequently Requested SQL

AUTHOR NAME: Neetu Dhami

PURPOSE AND BACKGROUND:  This SQL was created in 2007A SP 01 PL 08.This Sql can be used to list supplier open invoices by Due date.

Copy and Paste this SQL:

--SAP B1 SQL E-PU Supplier Open Invoices by Due Date Ver1 ND  2011 12 12

--DESCRIPTION:  This Report will give you information for Open invoices based on due date 

--Version 1 Neetu Dhami  12 Dec. 2011

SELECT 'Open Invoice' as 'Doc Type'

               , T0.[DocNum], T0.[DocDueDate] as [Doc Due Date]

              ,T0.[DocDate], T0.[TaxDate],  T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[DocTotalFC]

             ,T0.[DocCur],   T0.[Comments]


WHERE T0.[DocStatus]  = 'O'

  • No labels