Skip to Content
0
Former Member
Jan 10, 2012 at 04:34 AM

Bank Reconciliation report missing transtype=57

154 Views

Hi

we are using SAP B1 version 8.81(8.81.313) PL 05

We have a cyrstal report for Bank Reconciliation which is missing all transactions with transtype=57 (Checks for Payment).

1. Is this a standard report for SAP B1 or has this been developed for us? I have not been here long and while some reports were developed by the reseller, I am not sure which ones they were.

2. The Show SQL Query code includes the following which I have not been able to find anywhere in the report.I have looked in all the reports both main and sub-reports under report->selection formula->record selection as well as in all formula fields and section experts.

AND ("JDT1"."TransType"=N'30'

OR "JDT1"."TransType"=N'-4'

OR "JDT1"."TransType"=N'46'

OR "JDT1"."TransType"=N'24'

OR "JDT1"."TransType"=N'25')

I understand that this is the piece of code I need to add " OR "JDT1"."TransType"=N'57' "

3.Can anyone help where else I might find the above code?

4. Does anyone know what TransType=-4 in table JDT1 represents?

Thanks Chris