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]
FROM OPCH T0
WHERE T0.[DocStatus] = 'O'