Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Scribe RM Integration ...
Microsoft Dynamics GP (Archived)

Scribe RM Integration Commission Issue

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello!

We are using the GP adapter in Scribe to import Receivables Management Transactions into GP. We added the Salesperson, Commission amount and the Distributions for commission into the integration. No matter what, when we have an amount in the Commission Amount field, it gives us the following error message:

 

"The commission dollar amount passed does not match what is in the rm commission table - rm10501. check the following field on the rm transaction object 'commission amount'."

 

The Commission amount is being pushed to the RM10301 table. I looked at the RM10501 table and it is a separate commissions table that is populated when information is entered into the commissions on the receivables transaction. We have tried everything but cannot get the commission amount to push over.

 

Has anyone ever had this issue or know why we may be having this issue?

*This post is locked for comments

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Scribe RM Integration Commission Issue

    Basically, if you go to SQL Server Management Studio, open your company database and drill-down into the Programmability > Stored Procedures entry, you will see a procedure called taRMCommissionsPre. You will want to right-click on it and select the Modify option from the context menu. You can add your code after the "as" keyword. The code would look something like this:

    if not exists(select * from RM10501 where ..)
   insert RM10501 (...)
   values (@someparam, @someparam2...);
end if;


  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Scribe RM Integration Commission Issue

    Hi Mariano,

    I'm sorry. I didn't see your response to my question until today. I have experience in SQL but I never done something like that before. Do you have any instructions or links that may help with changing it?

    Thank you!

    RM82

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Scribe RM Integration Commission Issue

    You can extend the taRMCommissionsPre stored procedure to do the insert into the RM10501 table prior to the record being created in the RM10301 table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans