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