(Back to G-BK Banking Module SQL Posted to Wiki Listing - G-BK Banking Module SQL Posted to Wiki )
TYPE: Frequently Requested SQL.
AUTHOR NAME: Zal Parchem
PURPOSE AND BACKGROUND: This SQL was created in 2007A SP01 PL05. The SQL list out all incoming payment with payments on account by a specific date range. If you find this SQL helpful, then use “copy and paste” to place and save it using the Query Generator of your SAP B1 installation.
Here is a screen print of the SQL results:
Copy and Paste this SQL:
--G-BK Incoming Payments with Payments On Acct Ver 1 ZP 2011 02 28
--DESCRIPTION: SQL lists all Incoming Payments with Unbalanced Dollars during Cash Application.
--Version 1 Zal Parchem 2011 02 28
T0.DocNum AS 'Inc Pay Numb',
T0.DocDate AS 'Post Date',
T0.CardCode AS 'Cust Numb',
T0.CardName AS 'Customer Name',
T0.DocTotal AS 'Total Check Recd',
T0.NoDocSum AS 'Overpayment'
FROM ORCT T0
WHERE T0.[NoDocSum] < > 0
AND T0.DocTotal < > T0.NoDocSum
AND T0.DocDate >= '[%0]'
AND T0.DocDate <= '[%1]'