Friday, April 20, 2012

eConnect error 9522 - taRMTransaction

Batch Checkbook ID (BatchCHEKBKID) is set to inactive in the Checkbook Master Table - CM00100.

Sometimes you will get this error when you are calling the eConnect method taRMTransaction and you’re passing checkbook ID which was inactivated in the checkbook master (CM00100). To get rid from this issue you need to be sure checkbook ID which you passing to the eConnect method is active you can run the following query before you call the taRMTransaction method:

if (exists SELECT 1 FROM CM00100 (nolock) WHERE CHEKBKID = 'xxx' and INACTIVE = 1)
begin
record an error in the error log and dont call the econnect taRMTransaction method
end


Note: replace the xxx with your check book.

No comments:

Post a Comment

SSRS - How to Parameterizing the SQL Query

We need to create separated dataset to handle the pre defined list in that dataset we will use simple select statement to define the li...