Sunday, April 15, 2012

eConnect error 190 - taRMTransaction

Document number (DOCNUMBR) already exists in either RM00401, RM10301, RM20101 or RM30101.

This issue could occur if you’re trying to create a AR document (Invoice , Debit Memo, Credit Memo ..etc) which has document number / document type already exists RM Keys Master Table (RM00401) or RM Work table (RM10301) or RM Open(RM20101) or in RM History (RM30101), there could be many reasons behind this issue e.g. if you are calling eConnect or any other script to generate the document number and if this script failed to update the next document number properly you will end with this issue.

As solution before you call the taRMTransaction. you need to verify the document number which you passing to eConnect and if the document number already exists in RM00401, RM10301, RM20101 or RM30101 then you can get another document number, also you can through an error in the integration process and you can investigate more behind this issue.

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