Check Registry Report

[Former Member]

Experts,

Hi all, I have a client who is wanting to run a check registry report and wants to use the print date or creation date. If you have any suggestions please let me know. Thanks!

Jeff Haldeman

Support One

[Former Member · Accepted solution]

Hi Jeff,

If you want to customize system query, you can catch it by profiler.

Open SQL Server Management Studio.

From Menu select Tools -> SQL Server Profiler

Create a New Trace by selecting File -> New Trace

Then click on the report in SAP B1. By the SQL Trace, you can find out the System Query in the Trace Window.

Thanks,

Gordon

[former_member583013 · Accepted solution]

The System Reports which are available in the Query Manager have the SQL accessible ...You do not really need SQL Profiler, etc....

[former_member583013]

Jeff,

The Selection option that you see on the Check Register Report - Selection Criteria screen are the only ones you have. Due Date is the only field which you have which should in most cases be the same as posting date.

Suda

[Former Member]

I found that there is a system query that would work for the date, but the customer also wants the vendor to be a selection. So, she is wanting to get a report based on the vendor and the print date (or the date that the check was originated).

Jeff Haldeman

Support One

[former_member583013]

Are you talking about Checks for Payment in Date Cross Section Report

The code below will also take Vendor as a parameter

SELECT T0.CheckNum, T0.Branch, T0.BankNum, T0.CheckDate, T0.CheckSum, T0.VendorCode, T0.VendorName

FROM OCHO T0 WHERE (T0.CheckDate >= '[%0\]' AND T0.CheckDate <= '[%1\]') AND T0.VendorCode = '[%2\]'