Friday, April 20, 2012

eConnect error 363 - taRMTransaction

Batch Checkbook ID (BatchCHEKBKID) does not exist in the Checkbook Master Table - CM00100.

Sometimes you will get this error when you are calling the eConnect method taRMTransaction and you’re pass checkbook ID which not been defined in the checkbook master (CM00100). To get rid of this issue you need to be sure checkbook ID which you passing to the eConnect method already exists in the Checkbook Master you can run the following query before you call the taRMTransaction method:

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

Note: replace the xxx with your check book.

One more option if you used above query and the provided checkbook ID not defined in the system you other than quit the process you can call eConnect method taCreateCheckbook method to create the checkbook master and then you can processed with calling the taRMTransaction method.


If there is no business need to assign specific checkbook to the AR batch you can ignore the BatchCHEKBKID element of the taRMTransaction method and in the background eConnect will access the Receivable setup and get the default checkbook ID which has been defined and system will use this checkbook ID while creating the AR batch.

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...