I have imported a large number of Cash Receipts into Dynamics GP via eConnect with no issue. However, when I try to post them, via a Series Post, I get the following error message on a small percentage of them.
“Batch xxxxx failed to complete posting. Use the Batch Recovery window to complete the posting process.”
When I click on More Info, I get the following
“Index 26 of local array is out of range in script 'RM_Post_Validate_Cash_TRX_GL_Dist'. Script terminated.”
Unfortunately, when I try to recover the batch that fails as well which means I am left with a situation that I cannot recover from.
*This post is locked for comments
Hi
Im Stevenson (Peru - InsideB2B.com)
When u try integrate with eConnect, must know that "Round account type" has the value "10" on table rm10101 but GP gives "26" so here is the problem.
The distribution is not correct, I users have to modified OR run a Store after Econnect integration, something like this.
CREATE PROCEDURE [dbo].[PRD_ECONNECT_PM_RM_DISTRIBUTION_VALIDATE] (@documento VARCHAR(50),@origen VARCHAR(50)) AS
BEGIN
IF @origen ='RM'
BEGIN
UPDATE RM10101 SET DISTTYPE=10 WHERE DOCNUMBR=@DOCUMENTO AND DISTTYPE=26
END
GO
GRANT EXECUTE ON [PRD_ECONNECT_PM_RM_DISTRIBUTION_VALIDATE] TO DYNGRP
GO
I hope u solve it.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156