AP Payment Batch contains printed checks not recorded in Bank Services

Posted By KathieK over 7 years ago

A payment batch was created and checks printed. Error Batch was created during posting. The error is Check not found in Bank Services. Cant delete entries or void checks as the checks were not created in Bank Services.

0 Jay Converse Acumen over 7 years ago

The checks are not posted yet. Print the posting error report and see what it says.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 MusickInt over 7 years ago

The payment batch is damaged. The print of the checks did not update bank, so when posting, the check is not found. See if you can void the check batch and re-create it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KathieK over 7 years ago in reply to MusickInt

i cant void batch. i cant re-enter because the cheques are applied to invoices and those invoices are not showing uo in AP.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to KathieK

Read the posting error report!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KathieK over 7 years ago in reply to Jay Converse Acumen

Cheque # 222228 drawn on bank FCIB00002 not found in Bank services. it says that for each of the 4 cheques and changes # to reflect each cheque number.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to KathieK

You have corrupted data, you need to contact a professional to fix it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SergeB over 1 year ago

Necroing this thread to say we had a similar issue and ended up fixing it by resetting the entire batch via SQL. The basis of the script is below. No guarantees it will work for you.

Declare @Batch as varchar(10)
Set @Batch = '12'

delete BKTRAND
where SERIAL in (select CNTDEPSSEQ from APTCR where CNTBTCH=@Batch)

delete BKTRANH
where SERIAL in (select CNTDEPSSEQ from APTCR where CNTBTCH=@Batch)

update APTCR
set IDRMIT='000000000000', SWPRINTED=0, CNTDEPSSEQ=0, SWPRNTRMIT=1
where CNTBTCH=@Batch

update APBTA
set BATCHSTAT=1, SWPRINTED=0, CNTCHKPRNT=0
where CNTBTCH=@Batch
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

AP Payment Batch contains printed checks not recorded in Bank Services

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING