Excel Addin imports data sucesfully with Oject Refernece not set to an instance of the object
Richard Prior asked 6 years ago
Versions: GP 2016 RTM, SmartConnect 20.16.0.50
Testing the Excel addin using REST web service, The data imports into GP 2016 successfully but the error ‘Object reference not set to an instance of an object’ is presented. The message appears if the integration is successful or not.
The SmartConnect event log:
CASHRECEIPTS_PBA_RCTI: 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 = 9
APFRDCNM = PYMNT0159512
APTODCTY = 1
APTODCNM = 846788
Related Error Code Parameters for Node : taRMApply
APTODCNM = 846788
<taRMApply>
<APPLYDATE>2017-1-19</APPLYDATE>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<APPTOAMT>490.16</APPTOAMT>
<APTODCNM>846788</APTODCNM>
<APFRDCNM>PYMNT0159512</APFRDCNM>
</taRMApply>
Testing the Excel addin using REST web service, The data imports into GP 2016 successfully but the error ‘Object reference not set to an instance of an object’ is presented. The message appears if the integration is successful or not.
The SmartConnect event log:
CASHRECEIPTS_PBA_RCTI: 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 = 9
APFRDCNM = PYMNT0159512
APTODCTY = 1
APTODCNM = 846788
Related Error Code Parameters for Node : taRMApply
APTODCNM = 846788
<taRMApply>
<APPLYDATE>2017-1-19</APPLYDATE>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<APPTOAMT>490.16</APPTOAMT>
<APTODCNM>846788</APTODCNM>
<APFRDCNM>PYMNT0159512</APFRDCNM>
</taRMApply>