web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Batch Posting Error -Sales Operation on table RM_OPEN (45)

(0) ShareShare
ReportReport
Posted on by

Hi,

   I am getting this Error when I try to POST the Sales Batch. Do anyone knows what causes this Error.

   thumbnail_5F00_image.png

Categories:
I have the same question (0)
  • Community Member Profile Picture
    on at

    Save Operation on table RM_OPEN (45)

  • Verified answer
    Hokuminaria Profile Picture
    2,950 on at

    Hello Noob,

    The (45) error means there is an issue with a trigger on the table. Most times this is a third party or custom trigger.

    Can you check to see what triggers you have on the RM20101 to see what triggers you have on this table?

    1. Open SSMS.
    2. Expand the SQL instance.
    3. Expand the databases.
    4. Expand the company database.
    5. Expand Tables.
    6. Locate the RM20101 and expand it.
    7. Expand Triggers.

    I only have one trigger on this table. It is called  'zDT_RM20101U'.

    If you have any other triggers on this table, in TEST, disable those triggers and see if the same issue happens. If it does not, determine who the owner is of those triggers and contact them for further assistance.

    I hope this helps!

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer

  • Community Member Profile Picture
    on at

    Hi Brandon,

               Yes, I could see the custom trigger in the Table RM20101

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans