Bank Reconciliation Report Error

[Former Member]

Hi,

Need help.

I'm about to generate the bank reconciliation report and I supply the following parameters, Please see attached screenshot of the error.

Account Code: Bank500

Reconciliation Number: 20131231

and got error stating below,

This field name is not known.

Details: errorKind

Error in File RCRI0002

{dbd2e8dc-8c55-4ac1-885e....

{.......}.rpt

Error in formula Record Selection:

'{OBNK.AcctCode} = { ?GLAccount@Select Distinct

OBNK.AcctCode, OACT.AcctName From OBNK inner join dsc1 on

DSC1.GLAccount=OBNK.AcctCode inner join OACT on

OACT. AcctCode=OBNK.AcctCode} and

'

This field name is not known.

Details: errorKind

Thank you for your help.

Cheers.

Ryan

[Former Member]

Hi Experts,

Please help regarding this, I need a query for Bank Reconciliation Report since our SAP B1 8.81 is not working if we are going to generate from Banking > Banking Reports > External Reconciliation > Bank Reconciliation Reports. Error displays above.

Thank you.

Ryan Villarosa

[Former Member]

Hi Experts,

Since our Bank Reconcillation Report in our SAP B1 8.81 is not working, do you have any query for this? Thank you.

[Former Member]

Any ideas on this? Still unanswered. Thank you

[Former Member]

Hi ,

What if you execute your query in SQL Server ?

Is it executed without errors ?

[Former Member]

Hi Moayed,

I'm using  the Bank Reconciliation report in Banking > External Reconciliation > Bank Reconciliation Report. Do you any sample crystal report or query to where these data reside? THank you

Cheers.

Ryan Villarosa