Bank Transaction Entry Integration

[GPUser05]

I am trying to do the Bank transaction entry integration to bring in non-AP checks and direct debits information.

Can I bring the Bank transactions information in batch like AP and AR module so that I can look at it and decide if I want to post the batch or not?

Also if anybody has done any script to verify if the check number already exists in the chekbook register or can give some pointers on how to do the script.

Any help is highly appreciated.

Thank you,

 

[VictoriaYudin]

Since there are no batches in the Bank Rec module, you cannot import them in a batch.

To verify the check numbers you can check against column CMTrxNum in the CM20200 table.

Victoria
Flexible Solutions, Inc.

 

[GPUser05]

Thanks Victoria, I appreciate your reply. I will try to write a script using the information and post here if I am successfull.

Thank you,