Manual AP Checks Accounting Cancellation

How do you handle manual checks if they are processed within the same bank account as system checks? Here's scenario:

  • Manual checks range is 1000-1500
  • System Checks 5000-5999; These range is set under checkbook. 
  • Sage EM does not allow for two check ranges as above.

Manual checks can be recorded in the EM, but cannot be reversed using accounting cancellation as checkbook is not set for the range 1000-1500

Error: 
Table: CHQNUM [CHN]
Key: Bank Name CheckNo
No current record
Transaction stopped

My proposed solutions were:

  • Change TRS/BNK/CHQCT Check Controls Parameters is set to "No" every time you need to cancel manual check and then change the parameter back to Yes. This would have to be done every time manual check would have to be canceled. 
  • Create another bank account with the same cash account as the system check bank and add a range for manual checks. 

None of the solutions are ideal and wondering if anyone came up with something else. 

Thanks!

  • 0

    Hi,

    What version and patch level are you on? Have you tried adding the manual check range to the bank book?

  • FormerMember
    0 FormerMember

    Hi I was able to meet the same kind of problem in the company that I have been working in and I was able to solve this one in our end surprisingly. I was able to solve it by registering the cheque number used in the manual check transaction by going to Common Data -> BP Accounting Tables -> Cheque and then I create a new check and thus registering it in the system. By the way, the error why I was not able to do the manual cancellation before I solve it was because sage said the the check number used was not  registered in sage and so I registered it in the system. Viola. It worked! Hope this solution works on your end too.