Monday, December 5, 2011

eConnect error 568

Apply To Document (APTODCNM) does not exist in the RM Open Table - RM20101

Sometimes you will get this error when you are calling the eConnect method taRMApply. This error will occur when you tried to apply cash receipt document to un-posted invoice.

To handle this error you can save it to the error log file of your integration process and also you should not mark the cash receipt record as processed in your process log table. Then you should post all the invoices and try to run the apply process again.

Note: we can a void such kind of issues in the integration processes by using the GP auto post add-on, this add-on will automatically post all the invoices and other type of documents based on specified schedule, for more information on this product please refer to :

eConnect error 25

Batch is currently being posted, sometimes you will get this error when you are calling the eConnect method taRMCashReceiptInsert.

This issue could occur if you’re trying to create a cash receipt document and you have assigned this cash receipt to a receivable batch is currently being posted. To a void such kind of errors you need to be sure the batch number not been selected to be posted.

To check the posting status you can use call the following query before calling the taRMCashReceiptInsert method. If the @BATCHSTATUS=1 this mean the specified batch is currently being posted so you should use another batch number.


if (exists(select 1 from SY00500 (nolock) where BACHNUMB = @BACHNUMB and MKDTOPST <> 0 and BCHSOURC = @BCHSOURC))
begin
/* The Batch (BACHNUMB) is currently being posted */
SET @BATCHSTATUS = 1
end

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