Hi,
i recently had an open question,
http://dyndeveloper.com/thread.aspx?Threadid=1874
I am trying to apply a credit to a non posted invoice and its giving me this error.
From the previous thread i didnt think that the invoice had to be posted for the credit to apply, however its going to the RM20101
to try to find the invoice. Am i looking in the wrong direction for this?
when i create the invoice i am attaching the initial payment record also since it is an eft payment. afterwards i am creating the credit to be applied to the invoice if there are any credits. Is it possible to add the credits to the taCreateSopPaymentInsertRecord ?
right now the way our accounting dept does this
1. Invoice with payment record is created through econnect
2. Maunaully go in and apply the credit and post.
I am trying to streamline this by have econnect do everything either all at once or after the invoice is created and then the credit memo can be applied
Action:
Service Create
Current User Name:
KRETEK2\eConnectService
Input parameters:
Exception type:
Microsoft.Dynamics.GP.eConnect.eConnectException
Exception message:
Sql procedure error codes returned:
Error Number = 568 Stored Procedure= taRMApply Error Description = Apply To Document (APTODCNM) does not exist in the RM Open Table - RM20101
Node Identifier Parameters: taRMApply
APFRDCTY = 7
APFRDCNM = CREDT004647
APTODCTY = 1
APTODCNM = 500015
Related Error Code Parameters for Node : taRMApply
APTODCNM = 500015
<taRMApply>
<APTODCNM>500015</APTODCNM>
<APFRDCNM>CREDT004647</APFRDCNM>
<APPTOAMT>110.00000</APPTOAMT>
<APFRDCTY>7</APFRDCTY>
<APTODCTY>1</APTODCTY>
</taRMApply>
Stack Trace:
at Microsoft.Dynamics.GP.eConnect.EntityMessageProcessor.ExecuteSqlCommands(XElement transactionNode, EntityMessage message)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessMessageImport(EntityMessage message)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML)
at Microsoft.Dynamics.GP.eConnect.Service.CreateEntity(String ConnectionString, String sXML)
Exception type:
Microsoft.Dynamics.GP.eConnect.eConnectException
Exception message:
Error Number = 568 Stored Procedure taRMApply Error Description = Apply To Document (APTODCNM) does not exist in the RM Open Table - RM20101
Stack Trace: