checks on GL account

[Former Member]

The GL account does not show the actual CK #, nor does the Bank Rec module. Is there an option so this shows in each of these modules/reporting?

[jitin_chawla · Accepted solution]

Hi,

Check these if they help in any ways to your requirement :

select t.transid as 'Transaction Number', t.cardcode as 'Business Partner', 
t.CardName as 'Business Partner Name',
v.Checknum as 'Incoming Payment Cheque Number', t.docdate as 'Posting Date',
v.docnum as 'Incoming Payment Number', v.[checksum] as 'Check Amount',
CASE when v.ManualChk ='N' Then 'Automatic' Else 'Manual' END
from ORCT t 
inner join RCT1 v on t.docentry = v.docnum

select t.transid as 'Transaction Number', t.cardcode as 'Business Partner', 
t.CardName as 'Business Partner Name',
v.Checknum as 'Outgoing Payment Cheque Number', t.docdate as 'Posting Date',
v.docnum as 'Outgoing Payment Number', v.[checksum] as 'Check Amount',
CASE when v.ManualChk ='N' Then 'Automatic' Else 'Manual' END
from OVPM t 
inner join VPM1 v on t.docentry = v.docnum

You can further include and exclude whatever you need.

Kind Regards,

Jitin

SAP Business One Forum Team

[jitin_chawla]

Hi,

Are you looking for the Cheque Number in the G\L account window?

What is CK# which you are trying to find?

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

outgoing and incoming checks.

[Former Member]

Hi,

The easiest solution for you would be through reporting either by SQL query or Crystal Report.

Thanks,

Gordon

[Former Member]

if you dont mind can you tell me all the tables that i have to pull for this.

[Former Member]

At least from the following list:

OJDT, JDT1, OVPM, VPM1, OCHO