Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

(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:

G-BK Inc Payments with Pay On Acct.png

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.

--AUTHOR(s):
--Version 1 Zal Parchem 2011 02 28

SELECT

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

ORDER BY

T0.CardName,
T0.DocDate

FOR BROWSE

  • No labels