Skip to end of metadata
Go to start of metadata

Below is a listing of SQL which you can review for ideas or use in your SAP B1 System:

 (Back to SAP B1 SQL Tips and Tricks Main Page - SAP B1 SQL Tips and Tricks  )

SAP B1 SQL G-BK Deposit with AR Invoices from Lockbox .  Frequently Requested SQL.  This SQL brings together the deposit, the incoming payments, and the AR Invoice Numbers associated with the deposit done through the check lockbox.  This information is not a standard report in SAP B1, but it is generally requested by Customers.

SAP B1 SQL G-BK Incoming Payments with Payments On Account .  Frequently Requested SQL.  This SQL lists all incoming payments with payments on account by a specific date range.

SAP B1 SQL G-BK Payments by Bank Transfer within Date Range .  Frequently Requested SQL.  The SQL lists all incoming payments processed as "Bank Transfers" with a specific range selected by the end-user.  The SQL can be run for a single day or it can be run to find multiple payments over a month.

  • No labels